从RAC恢复到单实例数据库操作步骤(六)
to "/u01/app/oradata/csora/wcm_tmp.dbf";
SET NEWNAME FOR TEMPFILE 5 to "/u01/app/oradata/csora/trswcmv6_adintrs_temp.dbf";
RESTORE DATABASE;
SWITCH DATAFILE ALL;
SWITCH TEMPFILE ALL;
}
10、执行以上批处理脚本，进行文件（数据文件和临时文件）重定义，并RESTORE数据库
11、查看日志SCN号，这里只用归档日志备份集恢复，如用到归档日志文件恢复，
则查询V$ARCHIVED_LOG视图
则查询V$ARCHIVED_LOG视图
RMAN> list backupset;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
31710 Full 15.21G DISK 00:45:25 05-AUG-12
BP Key: 31779 Status: AVAILABLE Compressed: YES Tag: TAG20120805T040034
Piece Name: /mnt/rmanbak/csora_rmanbackup/dbfull_31103_1_790488035
List of Datafiles in backup set 31710
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 1292469329 05-AUG-12 /u01/app/oradata/csora/system01.dbf
2 Full 1292469329 05-AUG-12 /u01/app/oradata/csora/sysaux01.dbf
3 Full 1292469329 05-AUG-12 /u01/app/oradata/csora/undotbs1.dbf
4 Full 1292469329 05-AUG-12 /u01/app/oradata/csora/undotbs2.dbf
5 Full 1292469329 05-AUG-12 /u01/app/oradata/csora/users01.dbf
6 Full 1292469329 05-AUG-12 /u01/app/oradata/csora/wcmts.dbf
9 Full 1292469329 05-AUG-12 /u01/app/oradata/csora/wcm.dbf
10 Full 1292469329 05-AUG-12 /u01/app/oradata/csora/wcm_log.dbf
11 Full 1292469329 05-AUG-12 /u01/app/oradata/csora/wcm_document.dbf
12 Full 1292469329 05-AUG-12 /u01/app/oradata/csora/wcm_plugin.dbf
14 Full 1292469329 05-AUG-12 /u01/app/oradata/csora/wcmvideo.dbf
15 Full 1292469329 05-AUG-12 /u01/app/oradata/csora/trswcmv6_adintrs.dbf
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
31711 3.44M DISK 00:00:01 05-AUG-12
BP Key: 31780 Status: AVAILABLE Compressed: YES Tag: TAG20120805T044608
Piece Name: /mnt/rmanbak/csora_rmanbackup/arch_31105_1_790490768
List of Archived Logs in backup set 31711
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 6911 1292469298 05-AUG-12 1292480692 05-AUG-12
2 6854 1292469302 05-AUG-12 1292480688 05-AUG-12
……………………省略中间部分…………………………
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
32699 3.44M DISK 00:00:01 25-AUG-12
BP Key: 32924 Status: AVAILABLE Compressed: YES Tag: TAG20120825T140029
Piece Name: /mnt/rmanbak/csora_rmanbackup/arch_32097_1_792252029
List of Archived Logs in backup set 32699
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 7909 1302135697 25-AUG-12 1302146359 25-AUG-12
1 7910 1302146359 25-AUG-12 1302146578 25-AUG-12
2 7845 1302135702 25-AUG-12 1302146353 25-AUG-12
2 7846 1302146353 25-AUG-12 1302146582 25-AUG-12
12、根据SCN号RECOVER数据库
从11步的查询结果可以看到Next SCN 为 1302146582
RMAN> recover database until scn 1302146582;
最后报如下错误，归档日志找不到，可能是日志损坏或没有注册，这是不管它了，
只要数据库SCN号一致就OK,继续。
只要数据库SCN号一致就OK,继续。
unable to find archived log
archived log thread=1 sequence=7911
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: =============================