本文共 4378 字，大约阅读时间需要 14 分钟。

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Dec 11 19:02:05 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.connected to target database: CRM (DBID=3601019238)RMAN> list backup of spfile;BS Key Type LV Size Device Type Elapsed Time Completion Time13 Full 7.11M DISK 00:00:04 09-DEC-12BP Key: 13 Status: AVAILABLE Compressed: NO Tag: TAG20121209T040058Piece Name: /oracle/app/db1/dbs/0dnsd96i_1_1SPFILE Included: Modification time: 09-DEC-12

RMAN> list backup of controlfile;

BS Key Type LV Size Device Type Elapsed Time Completion Time13 Full 7.11M DISK 00:00:04 09-DEC-12BP Key: 13 Status: AVAILABLE Compressed: NO Tag: TAG20121209T040058Piece Name: /oracle/app/db1/dbs/0dnsd96i_1_1Control File Included: Ckp SCN: 2779528241 Ckp time: 09-DEC-12

RMAN> list backup of database;

BS Key Type LV Size Device Type Elapsed Time Completion Time12 Full 599.38M DISK 00:03:33 09-DEC-12BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20121209T040058Piece Name: /oracle/app/db1/dbs/0cnsd8vq_1_1List of Datafiles in backup set 121 Full 2779528081 09-DEC-12 /oracle/test/system1.dbf2 Full 2779528081 09-DEC-12 /oracle/test/zxb.dbf3 Full 2779528081 09-DEC-12 /oracle/test/sysaux01.dbf4 Full 2779528081 09-DEC-12 /oracle/test/users01.dbf5 Full 2779528081 09-DEC-12 /oracle/test/zxa.dbf6 Full 2779528081 09-DEC-12 /oracle/test/test1.dbf7 Full 2779528081 09-DEC-12 /oracle/test/zxc.dbf8 Full 2779528081 09-DEC-12 /oracle/test/undotbs1.dbf9 Full 2779528081 09-DEC-12 /oracle/test/zxbig.dbf

RMAN> list backup of archivelog all;

RMAN> restore spfile to '/oracle/app/db1/dbs/spfileCRM.ora' from '/oracle/app/db1/dbs/0dnsd96i_1_1';Starting restore at 10-DEC-12allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=34 devtype=DISKchannel ORA_DISK_1: autobackup found: /oracle/app/db1/dbs/0dnsd96i_1_1channel ORA_DISK_1: SPFILE restore from autobackup completeFinished restore at 10-DEC-12

RMAN> restore controlfile to '/oracle/CRM2/CRM/control01.ctl' from '/oracle/app/db1/dbs/0dnsd96i_1_1';

Starting restore at 10-DEC-12allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=210 devtype=DISKchannel ORA_DISK_1: restoring control filechannel ORA_DISK_1: restore complete, elapsed time: 00:00:04Finished restore at 10-DEC-12cp /oracle/CRM2/CRM/control01.ctl /oracle/CRM2/CRM/control02.ctl

RMAN> alter database mount;

database mountedreleased channel: ORA_DISK_1

RMAN> catalog start with '/backup/';

searching for all files that match the pattern /backup/List of Files Unknown to the DatabaseFile Name: /backup/0ensd96n_1_1File Name: /backup/0bnsd8vn_1_1File Name: /backup/0cnsd8vq_1_1

Do you really want to catalog the above files (enter YES or NO)? yes

cataloging files...cataloging done

List of Cataloged Files

File Name: /backup/0ensd96n_1_1File Name: /backup/0bnsd8vn_1_1File Name: /backup/0cnsd8vq_1_1

RMAN> restore database;

Starting restore at 10-DEC-12allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=209 devtype=DISKchannel ORA_DISK_1: starting datafile backupset restorechannel ORA_DISK_1: specifying datafile(s) to restore from backup setrestoring datafile 00001 to /oracle/test/system1.dbfrestoring datafile 00002 to /oracle/test/zxb.dbfrestoring datafile 00003 to /oracle/test/sysaux01.dbfrestoring datafile 00004 to /oracle/test/users01.dbfrestoring datafile 00005 to /oracle/test/zxa.dbfrestoring datafile 00006 to /oracle/test/test1.dbfrestoring datafile 00007 to /oracle/test/zxc.dbfrestoring datafile 00008 to /oracle/test/undotbs1.dbfrestoring datafile 00009 to /oracle/test/zxbig.dbfchannel ORA_DISK_1: reading from backup piece /oracle/app/db1/dbs/0cnsd8vq_1_1channel ORA_DISK_1: restored backup piece 1piece handle=/oracle/app/db1/dbs/0cnsd8vq_1_1 tag=TAG20121209T040058channel ORA_DISK_1: restore complete, elapsed time: 00:02:56Finished restore at 10-DEC-12

RMAN> recover database;

Starting recover at 10-DEC-12using channel ORA_DISK_1archive log thread 1 sequence 16 is already on disk as file /oracle/CRM2/CRM/redo04b.logarchive log thread 1 sequence 17 is already on disk as file /oracle/CRM2/CRM/redo05.logarchive log filename=/oracle/CRM2/CRM/redo04b.log thread=1 sequence=16archive log filename=/oracle/CRM2/CRM/redo05.log thread=1 sequence=17media recovery complete, elapsed time: 00:00:05Finished recover at 10-DEC-12

RMAN> alter database open resetlogs;

Database altered.

转载地址：http://pmpfk.baihongyu.com/