------
恢复过程:不管是否有catalog数据库,有备份就可以恢复;若无catalog数据库,则需要指定control file的绝对路径；若有catalog则无需此操作.
rman target /
Recovery Manager: Release 10.2.0.3.0 - Production on Tue Jul 1 17:44:33 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database (not started)
RMAN> startup nomount;
Oracle instance started
Total System Global Area 1610612736 bytes
Fixed Size 2073192 bytes
Variable Size 402656664 bytes
Database Buffers 1191182336 bytes
Redo Buffers 14700544 bytes
RMAN> restore controlfile from '/VOL4/lpar4/subta/rman/controlfile_c-2249798765-20080701-0f';
Starting restore at 01-JUL-08
using channel ORA_DISK_1
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
output filename=/subtaoradata/control01.ctl
output filename=/subtaredolog1/control02.ctl
output filename=/subtaredolog2/control03.ctl
Finished restore at 01-JUL-08
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
RMAN> restore database;
Starting restore at 01-JUL-08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=321 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /subtaoradata/system01.dbf
restoring datafile 00002 to /subtaoradata/undotbs01.dbf
restoring datafile 00003 to /subtaoradata/sysaux01.dbf
restoring datafile 00004 to /subtaoradata/users01.dbf
restoring datafile 00005 to /subtadata/SUBTA.dbf
channel ORA_DISK_1: reading from backup piece /VOL4/lpar4/subta/rman/subta_full_backup_i0jkdhpo_1_1_1_20080701.bk
channel ORA_DISK_1: restored backup piece 1
piece handle=/VOL4/lpar4/subta/rman/subta_full_backup_i0jkdhpo_1_1_1_20080701.bk tag=FULL_BACKUP
channel ORA_DISK_1: restore complete, elapsed time: 00:01:06
Finished restore at 01-JUL-08
RMAN> recover database;
Starting recover at 01-JUL-08
using channel ORA_DISK_1
starting media recovery
channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=5
channel ORA_DISK_1: reading from backup piece /VOL4/lpar4/subta/rman/subta_archlog_i3jkdhr9_1_1_20080701.bk
channel ORA_DISK_1: restored backup piece 1
piece handle=/VOL4/lpar4/subta/rman/subta_archlog_i3jkdhr9_1_1_20080701.bk tag=TAG20080701T173953
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
archive log filename=/archivelog/subta_arch_log/1_5_658949077.dbf thread=1 sequence=5
unable to find archive log
archive log thread=1 sequence=6
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 07/01/2008 17:47:15
RMAN-06054: media recovery requesting unknown log: thread 1 seq 6 lowscn 5145640
RMAN> alter database open resetlogs;
database opened
RMAN>