How to verify the catalog recovery capabilities in Oracle

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.