Saturday, May 26, 2012

Validate RMAN Backup



[oracle@omr dbs]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Sat May 26 12:26:58 2012

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

connected to target database: OMRDB (DBID=1430679315)

RMAN> 


RMAN> backup database;
Starting backup at 26-MAY-12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=30 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00001
name=/u01/app/oracle/oradata/omrdb/system01.dbf
input datafile file number=00002
name=/u01/app/oracle/oradata/omrdb/sysaux01.dbf
input datafile file number=00003
name=/u01/app/oracle/oradata/omrdb/undotbs01.dbf
input datafile file number=00004
name=/u01/app/oracle/oradata/omrdb/users01.dbf
channel ORA_DISK_1: starting piece 1 at 26-MAY-12
channel ORA_DISK_1: finished piece 1 at 26-MAY-12
piece handle=/u01/app/oracle/flash_recovery_area/OMRDB/backupset/2012_05_26/o
1_mf_nnndf_TAG20120526T081552_7w0sr8g2_.bkp tag=TAG20120526T081552
comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:04:01
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 26-MAY-12
channel ORA_DISK_1: finished piece 1 at 26-MAY-12
piece handle=/u01/app/oracle/flash_recovery_area/OMRDB/backupset/2012_05_26/o
1_mf_ncnnf_TAG20120526T081552_7w0szwnd_.bkp tag=TAG20120526T081552
comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 26-MAY-12

RMAN> backup archivelog all;
Starting backup at 26-MAY-12
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=5 RECID=1 STAMP=784282821
input archived log thread=1 sequence=6 RECID=2 STAMP=784282833
input archived log thread=1 sequence=7 RECID=3 STAMP=784282835
input archived log thread=1 sequence=8 RECID=4 STAMP=784282835
input archived log thread=1 sequence=9 RECID=5 STAMP=784282842
input archived log thread=1 sequence=10 RECID=6 STAMP=784282843
input archived log thread=1 sequence=11 RECID=7 STAMP=784282850
channel ORA_DISK_1: starting piece 1 at 26-MAY-12
channel ORA_DISK_1: finished piece 1 at 26-MAY-12
piece handle=/u01/app/oracle/flash_recovery_area/OMRDB/backupset/2012_05_26/o
1_mf_annnn_TAG20120526T082050_7w0t1m34_.bkp tag=TAG20120526T082050
comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 26-MAY-12
RMAN> validate recovery area;
Starting validate at 26-MAY-12
using channel ORA_DISK_1
specification does not match any datafile copy in the repository
channel ORA_DISK_1: starting validation of archived log
channel ORA_DISK_1: specifying archived log(s) for validation
input archived log thread=1 sequence=5 RECID=1 STAMP=784282821
input archived log thread=1 sequence=6 RECID=2 STAMP=784282833
input archived log thread=1 sequence=7 RECID=3 STAMP=784282835
input archived log thread=1 sequence=8 RECID=4 STAMP=784282835
input archived log thread=1 sequence=9 RECID=5 STAMP=784282842
input archived log thread=1 sequence=10 RECID=6 STAMP=784282843
input archived log thread=1 sequence=11 RECID=7 STAMP=784282850
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
List of Archived Logs
=====================
Thrd Seq     Status Blocks Failing Blocks Examined Name
---- ------- ------ -------------- --------------- ---------------
1    5       OK     0              1960          
/u01/app/oracle/flash_recovery_area/OMRDB/archivelog/2012_05_26/o1_mf_1_5_7w0t0og9_.arc
1    6       OK     0              1              
/u01/app/oracle/flash_recovery_area/OMRDB/archivelog/2012_05_26/o1_mf_1_6_7w0t11bd_.arc
1    7       OK     0              4              
/u01/app/oracle/flash_recovery_area/OMRDB/archivelog/2012_05_26/o1_mf_1_7_7w0t12yb_.arc
1    8       OK     0              1              
/u01/app/oracle/flash_recovery_area/OMRDB/archivelog/2012_05_26/o1_mf_1_8_7w0t12z1_.arc
1    9       OK     0              1              
/u01/app/oracle/flash_recovery_area/OMRDB/archivelog/2012_05_26/o1_mf_1_9_7w0t1b0w_.arc
1    10      OK     0              1              
/u01/app/oracle/flash_recovery_area/OMRDB/archivelog/2012_05_26/o1_mf_1_10_7w0t1c1k_.arc
1    11      OK     0              6              
/u01/app/oracle/flash_recovery_area/OMRDB/archivelog/2012_05_26/o1_mf_1_11_7w0t1lts_.arc
channel ORA_DISK_1: input backup set: count=2, stamp=784282460, piece=1
channel ORA_DISK_1: starting piece 1 at 26-MAY-12
channel ORA_DISK_1: backup piece
/u01/app/oracle/flash_recovery_area/OMRDB/backupset/2012_05_26/o1_mf_nc
nnf_TAG20120526T081419_7w0sohnq_.bkp
piece handle=/u01/app/oracle/flash_recovery_area/OMRDB/backupset/2012_05_26/o
1_mf_ncnnf_TAG20120526T081419_7w0t24o2_.bkp comment=NONE
channel ORA_DISK_1: finished piece 1 at 26-MAY-12
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:03
channel ORA_DISK_1: input backup set: count=3, stamp=784282552, piece=1
channel ORA_DISK_1: starting piece 1 at 26-MAY-12
channel ORA_DISK_1: backup piece
/u01/app/oracle/flash_recovery_area/OMRDB/backupset/2012_05_26/o1_mf_nn
ndf_TAG20120526T081552_7w0sr8g2_.bkp
piece handle=/u01/app/oracle/flash_recovery_area/OMRDB/backupset/2012_05_26/o
1_mf_nnndf_TAG20120526T081552_7w0t27p2_.bkp comment=NONE
channel ORA_DISK_1: finished piece 1 at 26-MAY-12
channel ORA_DISK_1: backup piece complete, elapsed time: 00:01:45
channel ORA_DISK_1: input backup set: count=4, stamp=784282793, piece=1
channel ORA_DISK_1: starting piece 1 at 26-MAY-12
channel ORA_DISK_1: backup piece
/u01/app/oracle/flash_recovery_area/OMRDB/backupset/2012_05_26/o1_mf_nc
nnf_TAG20120526T081552_7w0szwnd_.bkp
piece handle=/u01/app/oracle/flash_recovery_area/OMRDB/backupset/2012_05_26/o
1_mf_ncnnf_TAG20120526T081552_7w0t5jvw_.bkp comment=NONE
channel ORA_DISK_1: finished piece 1 at 26-MAY-12
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:03
channel ORA_DISK_1: input backup set: count=5, stamp=784282821, piece=1
channel ORA_DISK_1: starting piece 1 at 26-MAY-12
channel ORA_DISK_1: backup piece
/u01/app/oracle/flash_recovery_area/OMRDB/backupset/2012_05_26/o1_mf_an
nnn_TAG20120526T082021_7w0t0p12_.bkp
piece handle=/u01/app/oracle/flash_recovery_area/OMRDB/backupset/2012_05_26/o
1_mf_annnn_TAG20120526T082021_7w0t5mvx_.bkp comment=NONE
channel ORA_DISK_1: finished piece 1 at 26-MAY-12
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:01
channel ORA_DISK_1: input backup set: count=6, stamp=784282850, piece=1
channel ORA_DISK_1: starting piece 1 at 26-MAY-12
channel ORA_DISK_1: backup piece
/u01/app/oracle/flash_recovery_area/OMRDB/backupset/2012_05_26/o1_mf_an
nnn_TAG20120526T082050_7w0t1m34_.bkp
piece handle=/u01/app/oracle/flash_recovery_area/OMRDB/backupset/2012_05_26/o
1_mf_annnn_TAG20120526T082050_7w0t5o0h_.bkp comment=NONE
channel ORA_DISK_1: finished piece 1 at 26-MAY-12
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:01
Finished validate at 26-MAY-12

-- Validate database

RMAN> restore database validate;
Starting restore at 26-MAY-12
using channel ORA_DISK_1
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece
/u01/app/oracle/flash_recovery_area/OMRDB/backupset/2012_05_26/o1_mf_nn
ndf_TAG20120526T083547_7w0txmg6_.bkp
channel ORA_DISK_1: piece
handle=/u01/app/oracle/flash_recovery_area/OMRDB/backupset/2012_05_26/o
1_mf_nnndf_TAG20120526T083547_7w0txmg6_.bkp tag=TAG20120526T083547
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:15
Finished restore at 26-MAY-12

-- Validate Control file 

RMAN> restore controlfile validate;
Starting restore at 26-MAY-12
using channel ORA_DISK_1
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece
/u01/app/oracle/flash_recovery_area/OMRDB/autobackup/2012_05_26/o1_mf_n
_784283872_7w0v1k3f_.bkp
channel ORA_DISK_1: piece
handle=/u01/app/oracle/flash_recovery_area/OMRDB/autobackup/2012_05_26/
o1_mf_n_784283872_7w0v1k3f_.bkp tag=TAG20120526T083752
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:00
Finished restore at 26-MAY-12

-- Validate Spfile 

RMAN> restore spfile validate;

Starting restore at 26-MAY-12
using channel ORA_DISK_1
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece
/u01/app/oracle/flash_recovery_area/OMRDB/autobackup/2012_05_26/o1_mf_s
_784296870_7w17qqmw_.bkp
channel ORA_DISK_1: piece
handle=/u01/app/oracle/flash_recovery_area/OMRDB/autobackup/2012_05_26/
o1_mf_s_784296870_7w17qqmw_.bkp tag=TAG20120526T121430
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:00
Finished restore at 26-MAY-12

-- Validate archive logs

RMAN> restore archivelog from time 'SYSDATE-1' validate;
Starting restore at 26-MAY-12
using channel ORA_DISK_1
channel ORA_DISK_1: scanning archived log
/u01/app/oracle/flash_recovery_area/OMRDB/archivelog/2012_05_26/o1_mf_1
_5_7w0t0og9_.arc
channel ORA_DISK_1: scanning archived log
/u01/app/oracle/flash_recovery_area/OMRDB/archivelog/2012_05_26/o1_mf_1
_6_7w0t11bd_.arc
channel ORA_DISK_1: scanning archived log
/u01/app/oracle/flash_recovery_area/OMRDB/archivelog/2012_05_26/o1_mf_1
_7_7w0t12yb_.arc
channel ORA_DISK_1: scanning archived log
/u01/app/oracle/flash_recovery_area/OMRDB/archivelog/2012_05_26/o1_mf_1
_8_7w0t12z1_.arc
channel ORA_DISK_1: scanning archived log
/u01/app/oracle/flash_recovery_area/OMRDB/archivelog/2012_05_26/o1_mf_1
_9_7w0t1b0w_.arc
channel ORA_DISK_1: scanning archived log
/u01/app/oracle/flash_recovery_area/OMRDB/archivelog/2012_05_26/o1_mf_1
_10_7w0t1c1k_.arc
channel ORA_DISK_1: scanning archived log
/u01/app/oracle/flash_recovery_area/OMRDB/archivelog/2012_05_26/o1_mf_1
_11_7w0t1lts_.arc
channel ORA_DISK_1: scanning archived log
/u01/app/oracle/flash_recovery_area/OMRDB/archivelog/2012_05_26/o1_mf_1
_12_7w0wd3pf_.arc
Finished restore at 26-MAY-12

-- Validate USERS tablespace

RMAN> restore tablespace users validate;

Starting restore at 26-MAY-12
using channel ORA_DISK_1
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece
/u01/app/oracle/flash_recovery_area/OMRDB/backupset/2012_05_26/o1_mf_nn
ndf_TAG20120526T083547_7w0txmg6_.bkp
channel ORA_DISK_1: piece
handle=/u01/app/oracle/flash_recovery_area/OMRDB/backupset/2012_05_26/o
1_mf_nnndf_TAG20120526T083547_7w0txmg6_.bkp tag=TAG20120526T083547
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
Finished restore at 26-MAY-12


-- Validate backup sets

RMAN> list backup summary;

List of Backups
===============
Key     TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
1       B  F  A DISK        26-MAY-12       1       2       NO         TAG20120526T081419
2       B  F  A DISK        26-MAY-12       1       2       NO         TAG20120526T081552
3       B  F  A DISK        26-MAY-12       1       2       NO         TAG20120526T081552
4       B  A  A DISK        26-MAY-12       1       2       NO         TAG20120526T082021
5       B  A  A DISK        26-MAY-12       1       2       NO         TAG20120526T082050

RMAN> validate backupset 1,2,3,4,5 ;
Starting validate at 26-MAY-12
using channel ORA_DISK_1
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece
/u01/app/oracle/flash_recovery_area/OMRDB/backupset/2012_05_26/o1_mf_nc
nnf_TAG20120526T081419_7w0t24o2_.bkp
channel ORA_DISK_1: piece
handle=/u01/app/oracle/flash_recovery_area/OMRDB/backupset/2012_05_26/o
1_mf_ncnnf_TAG20120526T081419_7w0t24o2_.bkp tag=TAG20120526T081419
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece
/u01/app/oracle/flash_recovery_area/OMRDB/backupset/2012_05_26/o1_mf_nn
ndf_TAG20120526T081552_7w0sr8g2_.bkp
channel ORA_DISK_1: piece
handle=/u01/app/oracle/flash_recovery_area/OMRDB/backupset/2012_05_26/o
1_mf_nnndf_TAG20120526T081552_7w0sr8g2_.bkp tag=TAG20120526T081552
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting validation of datafile backup set
channel ORA_DISK_1: reading from backup piece
/u01/app/oracle/flash_recovery_area/OMRDB/backupset/2012_05_26/o1_mf_nc
nnf_TAG20120526T081552_7w0t5jvw_.bkp
channel ORA_DISK_1: piece
handle=/u01/app/oracle/flash_recovery_area/OMRDB/backupset/2012_05_26/o
1_mf_ncnnf_TAG20120526T081552_7w0t5jvw_.bkp tag=TAG20120526T081552
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:00
channel ORA_DISK_1: starting validation of archived log backup set
channel ORA_DISK_1: reading from backup piece
/u01/app/oracle/flash_recovery_area/OMRDB/backupset/2012_05_26/o1_mf_an
nnn_TAG20120526T082021_7w0t0p12_.bkp
channel ORA_DISK_1: piece
handle=/u01/app/oracle/flash_recovery_area/OMRDB/backupset/2012_05_26/o
1_mf_annnn_TAG20120526T082021_7w0t0p12_.bkp tag=TAG20120526T082021
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:00
channel ORA_DISK_1: starting validation of archived log backup set
channel ORA_DISK_1: reading from backup piece
/u01/app/oracle/flash_recovery_area/OMRDB/backupset/2012_05_26/o1_mf_an
nnn_TAG20120526T082050_7w0t1m34_.bkp
channel ORA_DISK_1: piece
handle=/u01/app/oracle/flash_recovery_area/OMRDB/backupset/2012_05_26/o
1_mf_annnn_TAG20120526T082050_7w0t1m34_.bkp tag=TAG20120526T082050
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: validation complete, elapsed time: 00:00:00
Finished validate at 26-MAY-12



-- Validate recovery area

RMAN> validate recovery area;
Starting validate at 26-MAY-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=33 device type=DISK
specification does not match any datafile copy in the repository
channel ORA_DISK_1: starting validation of archived log
channel ORA_DISK_1: specifying archived log(s) for validation
input archived log thread=1 sequence=12 RECID=8 STAMP=784285238
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
List of Archived Logs
=====================
Thrd Seq     Status Blocks Failing Blocks Examined Name
---- ------- ------ -------------- --------------- ---------------
1    12      OK     0              68339           /u01/app/oracle/flash_recovery_area/OMRDB/archivelog/2012_05_26/o1_mf_1_12_7w0wd3pf_.arc
channel ORA_DISK_1: input backup set: count=8, stamp=784283747, piece=1
channel ORA_DISK_1: starting piece 1 at 26-MAY-12
channel ORA_DISK_1: backup piece /u01/app/oracle/flash_recovery_area/OMRDB/backupset/2012_05_26/o1_mf_nnndf_TAG20120526T083547_7w0txmg6_.bkp
piece handle=/u01/app/oracle/flash_recovery_area/OMRDB/backupset/2012_05_26/o1_mf_nnndf_TAG20120526T083547_7w190t2j_.bkp comment=NONE
channel ORA_DISK_1: finished piece 1 at 26-MAY-12
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:35
channel ORA_DISK_1: input backup set: count=11, stamp=784296870, piece=1
channel ORA_DISK_1: starting piece 1 at 26-MAY-12
skipping backup piece handle /u01/app/oracle/flash_recovery_area/OMRDB/autobackup/2012_05_26/o1_mf_s_784296870_7w17qqmw_.bkp; already exists
channel ORA_DISK_1: finished piece 1 at 26-MAY-12
channel ORA_DISK_1: backup piece complete, elapsed time: 00:00:00
Finished validate at 26-MAY-12

RMAN> 



Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)