Get the App
SLTechnology News&Howtos  ›  Database  › 

Verify the validity of RMAN backup of oracle 11g database

Shulou Source: shulou.com Published: 2022-06-01 05:59:18 10月01日 Update

[oracle@db1 ~] $rman target /

Recovery Manager: Release 11.2.0.3.0-Production on Tue Dec 12 16:08:43 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to target database: PRD (DBID=893924085)

RMAN > list backup of database

Using target database control file instead of recovery catalog

List of Backup Sets

=

BS Key Type LV Size Device Type Elapsed Time Completion Time

18552 Full 5.70G DISK 00:10:08 08-DEC-17

BP Key: 18552 Status: AVAILABLE Compressed: YES Tag: TAG20171208T230015

Piece Name: / backup/scprd1/rman/Full_SCPRD_20171208_18569.bak

List of Datafiles in backup set 18552

File LV Type Ckp SCN Ckp Time Name

6 Full 1353576289 08-DEC-17 + DATA/scprd/datafile/sce_common.296.929901311

7 Full 1353576289 08-DEC-17 + DATA/scprd/datafile/sce_component.298.929901313

10 Full 1353576289 08-DEC-17 + DATA/scprd/datafile/wmwhse3_data.304.929901317

17 Full 1353576289 08-DEC-17 + DATA/scprd/datafile/wmwhse10_data.318.929901327

21 Full 1353576289 08-DEC-17 + DATA/scprd/datafile/wmwhse14_data.326.929901333

25 Full 1353576289 08-DEC-17 + DATA/scprd/datafile/wmwhse18_data.334.929901339

27 Full 1353576289 08-DEC-17 + DATA/scprd/datafile/wmwhse20_data.338.929901343

30 Full 1353576289 08-DEC-17 + DATA/scprd/datafile/wmwhse16_data.392.938904035

BS Key Type LV Size Device Type Elapsed Time Completion Time

18674 Full 5.73G DISK 00:09:39 11-DEC-17

BP Key: 18674 Status: AVAILABLE Compressed: YES Tag: TAG20171211T230016

Piece Name: / backup/scprd1/rman/Full_SCPRD_20171211_18691.bak

List of Datafiles in backup set 18674

File LV Type Ckp SCN Ckp Time Name

6 Full 1363677571 11-DEC-17 + DATA/scprd/datafile/sce_common.296.929901311

7 Full 1363677571 11-DEC-17 + DATA/scprd/datafile/sce_component.298.929901313

10 Full 1363677571 11-DEC-17 + DATA/scprd/datafile/wmwhse3_data.304.929901317

17 Full 1363677571 11-DEC-17 + DATA/scprd/datafile/wmwhse10_data.318.929901327

21 Full 1363677571 11-DEC-17 + DATA/scprd/datafile/wmwhse14_data.326.929901333

25 Full 1363677571 11-DEC-17 + DATA/scprd/datafile/wmwhse18_data.334.929901339

27 Full 1363677571 11-DEC-17 + DATA/scprd/datafile/wmwhse20_data.338.929901343

30 Full 1363677571 11-DEC-17 + DATA/scprd/datafile/wmwhse16_data.392.938904035

RMAN > validate backupset 18674

Starting validate at 12-DEC-17

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: SID=3401 instance=SCPRD1 device type=DISK

Channel ORA_DISK_1: starting validation of datafile backup set

Channel ORA_DISK_1: reading from backup piece / backup/scprd1/rman/Full_SCPRD_20171211_18691.bak

Channel ORA_DISK_1: piece handle=/backup/scprd1/rman/Full_SCPRD_20171211_18691.bak tag=TAG20171211T230016

Channel ORA_DISK_1: restored backup piece 1

Channel ORA_DISK_1: validation complete, elapsed time: 00:11:45

Finished validate at 12-DEC-17

Only complete verification is carried out for RMAN's FULL.

Tags: Verify complete valid backup data database validity Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno NVidia Linux MariaDB MySQL Apple