Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

999

积分

1

好友

942

主题
1#
发表于 2017-4-15 10:12:14 | 查看: 974| 回复: 0
大家好,我现在的数据库做了不完成恢复后,数据库副本号是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
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-6-1 21:04 , Processed in 0.047013 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569