请教关于在RMAN中恢复数据库副本出错的问题
大家好，我现在的数据库做了不完成恢复后，数据库副本号是489我在控制文件(select checkpoint_change# from v$database)和数据文件的SCN值为1607756是做了数据库全备后的SCN值，现在我想恢复到之前的数据库副本号2，于是我执行了以下命令脚本：
RMAN> startup force mount;
RMAN> reset database to incarnation 2;
RMAN> run {
2> startup force nomount;
3> set until scn=1607756; ##这里的scn=1607756是v$database 视图中的checkpoint_change#的值，不是current_scn 的值，有问题吗？
4> restore controlfile;
5> }
RMAN> run {
2> sql 'alter database mount';
3> restore database;
4> recover database;
5> sql 'alter database open resetlogs';
6> }
但最后提示了以下“在恢复目录中找不到目标数据库的副本”：
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 03/13/2013 15:46:55
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20003: target database incarnation not found in recovery catalog
-------
请问这是怎么回事？错在哪里了？应如何解决才能恢复到数据库之前副本号2呢？
待复，感谢！
RMAN> list backup;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
438 2.60M DISK 00:00:01 2013-03-13 17:59:09
BP Key: 448 Status: AVAILABLE Compressed: NO Tag: TAG20130313T175908
Piece Name: /ora01/oracle/oradata/demo/rman_bak/database_fullback/DEMO_1_1.ARC.bak
List of Archived Logs in backup set 438
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 1 1604344 2013-01-19 22:13:08 1606323 2013-03-13 17:59:07
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
439 Full 2.08M DISK 00:00:26 2013-03-13 17:59:40
BP Key: 449 Status: AVAILABLE Compressed: NO Tag: TAG20130313T175910
Piece Name: /ora01/oracle/oradata/demo/rman_bak/database_fullback/DEMO_5.bak
List of Datafiles in backup set 439
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
4 Full 1606340 2013-03-13 17:59:18 /ora01/oracle/oradata/demo/users01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
440 Full 49.02M DISK 00:00:32 2013-03-13 17:59:43
BP Key: 450 Status: AVAILABLE Compressed: NO Tag: TAG20130313T175910
Piece Name: /ora01/oracle/oradata/demo/rman_bak/database_fullback/DEMO_4.bak
List of Datafiles in backup set 440
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
2 Full 1606338 2013-03-13 17:59:14 /ora01/oracle/oradata/demo/undotbs01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
441 Full 153.53M DISK 00:00:35 2013-03-13 17:59:46
BP Key: 451 Status: AVAILABLE Compressed: NO Tag: TAG20130313T175910
Piece Name: /ora01/oracle/oradata/demo/rman_bak/database_fullback/DEMO_3.bak
List of Datafiles in backup set 441
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
3 Full 1606335 2013-03-13 17:59:11 /ora01/oracle/oradata/demo/sysaux01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
442 Full 152.00K DISK 00:00:30 2013-03-13 17:59:48
BP Key: 452 Status: AVAILABLE Compressed: NO Tag: TAG20130313T175910
Piece Name: /ora01/oracle/oradata/demo/rman_bak/database_fullback/DEMO_6.bak
List of Datafiles in backup set 442
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
7 Full 1606343 2013-03-13 17:59:23 /ora01/oracle/oradata/demo/user_01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
443 Full 353.34M DISK 00:00:37 2013-03-13 17:59:48
BP Key: 453 Status: AVAILABLE Compressed: NO Tag: TAG20130313T175910
Piece Name: /ora01/oracle/oradata/demo/rman_bak/database_fullback/DEMO_2.bak
List of Datafiles in backup set 443
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 Full 1606334 2013-03-13 17:59:11 /ora01/oracle/oradata/demo/system01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
444 Full 6.98M DISK 00:00:13 2013-03-13 17:59:49
BP Key: 454 Status: AVAILABLE Compressed: NO Tag: TAG20130313T175910
Piece Name: /ora01/oracle/oradata/demo/rman_bak/database_fullback/DEMO_7.bak
Control File Included: Ckp SCN: 1606346 Ckp time: 2013-03-13 17:59:33
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
445 Full 344.00K DISK 00:00:01 2013-03-13 17:59:50
BP Key: 455 Status: AVAILABLE Compressed: NO Tag: TAG20130313T175910
Piece Name: /ora01/oracle/oradata/demo/rman_bak/database_fullback/DEMO_8.bak
List of Datafiles in backup set 445
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
5 Full 1606352 2013-03-13 17:59:49 /ora01/oracle/oradata/demo/test_tbs01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
446 Full 80.00K DISK 00:00:00 2013-03-13 17:59:50
BP Key: 456 Status: AVAILABLE Compressed: NO Tag: TAG20130313T175910
Piece Name: /ora01/oracle/oradata/demo/rman_bak/database_fullback/DEMO_10.bak
SPFILE Included: Modification time: 2013-03-13 17:51:13
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
447 Full 88.00K DISK 00:00:01 2013-03-13 17:59:50
BP Key: 457 Status: AVAILABLE Compressed: NO Tag: TAG20130313T175910
Piece Name: /ora01/oracle/oradata/demo/rman_bak/database_fullback/DEMO_9.bak
List of Datafiles in backup set 447
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
6 Full 1606353 2013-03-13 17:59:49 /ora01/oracle/oradata/demo/test_tbs02.dbf
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
477 2.00K DISK 00:00:01 2013-03-13 17:59:54
BP Key: 479 Status: AVAILABLE Compressed: NO Tag: TAG20130313T175953
Piece Name: /ora01/oracle/oradata/demo/rman_bak/database_fullback/DEMO_11_2.ARC.bak
List of Archived Logs in backup set 477
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 2 1606323 2013-03-13 17:59:07 1606357 2013-03-13 17:59:52
页:
[1]