How to verify the catalog recovery capabilities in Oracle

1, set up catalog library, and register target database and synchronous catalog db

--Establish a backup of the database

[Oracle@rh4 ~]$ Rman Target/catalog rman/rman@catdb

Recovery manager:release 10.2.0.1.0-production on Sun Feb 19 11:43:13 2012

Copyright (c) 1982, +, Oracle. All rights reserved.

Connected to target Database:prod (dbid=187338998)

Connected to Recovery Catalog database

Rman> Backup Database format '/disk1/rman/prod/cold_bak/%d_%s.bak ';

Starting backup at 19-feb-12

Allocated Channel:ora_disk_1

Channel ora_disk_1:sid=159 Devtype=disk

Channel ora_disk_1:starting full datafile backupset

Channel ora_disk_1:specifying DataFile (s) in Backupset

Input datafile fno=00001 name=/u01/app/oracle/oradata/prod/system01.dbf

Input datafile fno=00003 name=/u01/app/oracle/oradata/prod/sysaux01.dbf

Input datafile fno=00005 name=/u01/app/oracle/oradata/prod/example01.dbf

Input datafile fno=00006 name=/u01/app/oracle/oradata/prod/lxtbs1.dbf

Input datafile fno=00002 name=/u01/app/oracle/oradata/prod/undotbs01.dbf

Input datafile fno=00004 name=/u01/app/oracle/oradata/prod/users01.dbf

Channel ora_disk_1:starting piece 1 at 19-feb-12

Channel ora_disk_1:finished piece 1 at 19-feb-12

Piece Handle=/disk1/rman/prod/cold_bak/prod_71.bak tag=tag20120219t114346 comment=none

Channel Ora_disk_1:backup set complete, elapsed time:00:01:05

Finished backup at 19-feb-12

Starting control File and SPFILE autobackup at 19-feb-12

Piece HANDLE=/U01/APP/ORACLE/FLASH_RECOVERY_AREA/PROD/AUTOBACKUP/2012_02_19/O1_MF_S_775655094_7N0W1QR5_.BKP Comment=none

Finished control File and SPFILE autobackup at 19-feb-12

rman> list backup;

List of Backup Sets

===================

BS Key Type LV Size Device Type Elapsed Time Completion time

------- ---- -- ---------- ----------- ------------ ---------------

389 full 597.17M DISK 00:01:01 19-feb-12

BP key:390 status:available Compressed:no tag:tag20120219t114346

Piece Name:/disk1/rman/prod/cold_bak/prod_71.bak

List of datafiles in backup set 389

File LV Type Ckp SCN Ckp time Name

---- -- ---- ---------- --------- ----

1 Full 634042 19-feb-12/u01/app/oracle/oradata/prod/system01.dbf

2 Full 634042 19-feb-12/u01/app/oracle/oradata/prod/undotbs01.dbf

3 Full 634042 19-FEB-12/U01/APP/ORACLE/ORADATA/PROD/SYSAUX01.DBF

4 Full 634042 19-FEB-12/U01/APP/ORACLE/ORADATA/PROD/USERS01.DBF

5 Full 634042 19-FEB-12/U01/APP/ORACLE/ORADATA/PROD/EXAMPLE01.DBF

6 Full 634042 19-FEB-12/U01/APP/ORACLE/ORADATA/PROD/LXTBS1.DBF

BS Key Type LV Size Device Type Elapsed Time Completion time

------- ---- -- ---------- ----------- ------------ ---------------

405 Full 7.27M DISK 00:00:02 19-feb-12

BP key:412 status:available Compressed:no tag:tag20120219t114454

Piece Name:/U01/APP/ORACLE/FLASH_RECOVERY_AREA/PROD/AUTOBACKUP/2012_02_19/O1_MF_S_775655094_7N0W1QR5_.BKP