RMAN备份异机恢复并创建新DBID(五)
812304874 filename=/u01/oradata/orcl/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=40 stamp=812304874 filename=/u01/oradata/orcl/DEALSPACE_002.dbf
datafile 5 switched to datafile copy
input datafile copy recid=41 stamp=812304874 filename=/u01/oradata/orcl/DEALSPACE_001.dbf
datafile 6 switched to datafile copy
input datafile copy recid=42 stamp=812304874 filename=/u01/oradata/orcl/l5mspace01.dbf
datafile 7 switched to datafile copy
input datafile copy recid=43 stamp=812304874 filename=/u01/oradata/orcl/RCFSPACE_002.dbf
datafile 8 switched to datafile copy
input datafile copy recid=44 stamp=812304874 filename=/u01/oradata/orcl/RCFSPACE_001.dbf
datafile 9 switched to datafile copy
input datafile copy recid=45 stamp=812304874 filename=/u01/oradata/orcl/DTSPACE_001.dbf
如果不需要更改文件目录的话，就简单了
RMAN> restore database;
8. recover DB
RMAN> recover database;
Starting recover at 09-APR-13
using channel ORA_DISK_1
using channel ORA_DISK_2
starting media recovery
channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_2: 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 /u03/RMAN/arch0fo6kr6t_15_1.bak
channel ORA_DISK_2: restoring archive log
archive log thread=1 sequence=6
channel ORA_DISK_2: reading from backup piece /u03/RMAN/arch0io6kr7a_18_1.bak
channel ORA_DISK_2: restored backup piece 1
piece handle=/u03/RMAN/arch0io6kr7a_18_1.bak tag=TAG20130409T093640
channel ORA_DISK_2: restore complete, elapsed time: 00:00:01
channel ORA_DISK_1: restored backup piece 1
piece handle=/u03/RMAN/arch0fo6kr6t_15_1.bak tag=TAG20130409T093640
channel ORA_DISK_1: restore complete, elapsed time: 00:00:04
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_04_09/o1_mf_1_5_8p7mmykf_.arc thread=1 sequence=5
channel default: deleting archive log(s)
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_04_09/o1_mf_1_5_8p7mmykf_.arc recid=17 stamp=812305026
archive log filename=/u01/app/oracle/flash_recovery_area/ORCL/archivelog/2013_04_09/o1_mf_1_6_8p7mmykb_.arc thread=1 sequence=6
unable to find archive log
archive log thread=1 sequence=1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 04/09/2013 16:17:20
RMAN-06054: media recovery requesting unknown log: thread 1 seq 1 lowscn 3524945668
RMAN> list backupset;
其中的这么一个archivelog的备份文件，/u03/RMAN/arch0io6kr7a_18_1.bak的最大SCN是3524945667，
系统recover到这个文件后找不到下一次SCN，就会报这个错，这是正常的，如不想出现这个错误的话，则需要用recover database until scn 3524945667 来不完全恢复。
如需要全完恢复，则需将备份之后产生的所有archivelog。
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
14 2.00K DISK 00:00:01 09-APR-13
BP Key: 14 Status: AVAILABLE Compressed: YES