9i RMAN災難恢復問題

唐诗三百首 2009-08-12 08:30:42
現有目標數據庫服務器A,恢復目錄數據庫也在機器A上(不同DB), 使用RMAN方式進行備份至機器B.

假設一種最糟糕的情況: 目標數據庫服務器磁盤全部損壞不可讀取,恢復目錄也在同一臺機器上無法使用.

請問此時如何僅依靠機器B上的文件進行恢復? 注: 機器B上有1個0級備份和若干1級備份.還有0級備份前的1個冷備份.恢復目錄有EXP方式做過備份. 試過很多方法,均無法恢復.請教各位了,謝!!
...全文
250 16 打赏 收藏 转发到动态 举报
写回复
用AI写文章
16 条回复
切换为时间正序
请发表友善的回复…
发表回复
唐诗三百首 2009-08-19
  • 打赏
  • 举报
 回复
現已測試正常,雖與各位提供方法有所差異,但總體思路相同,謝謝jinxino_o及各位的指導!
IndependentDeveloper 2009-08-15
  • 打赏
  • 举报
 回复 


再看一下备份集

RMAN> list backup;

List of Backup Sets

===================



BS Key  Size       Device Type Elapsed Time Completion Time    

------- ---------- ----------- ------------ -------------------

1       22.89M     DISK        00:00:03     2009-07-14 19:09:29

        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20090714T190926

        Piece Name: /backup/rman_bk/SINGLE_1_1.bak



  List of Archived Logs in backup set 1

  Thrd Seq     Low SCN    Low Time            Next SCN   Next Time

  ---- ------- ---------- ------------------- ---------- ---------

  1    11      173335     2009-07-13 15:55:13 180113     2009-07-14 19:09:23



BS Key  Type LV Size       Device Type Elapsed Time Completion Time    

------- ---- -- ---------- ----------- ------------ -------------------

2       Full    356.73M    DISK        00:00:41     2009-07-14 19:10:12

        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20090714T190930

        Piece Name: 



/database/oracle/flash_recovery_area/SINGLE/backupset/2009_07_14/o1_mf_nnndf_TAG20090714T190



930_55rsvcg8_.bkp

  List of Datafiles in backup set 2

  File LV Type Ckp SCN    Ckp Time            Name

  ---- -- ---- ---------- ------------------- ----

  1       Full 180120     2009-07-14 19:09:31 /database/oracle/oradata/single/system01.dbf

  2       Full 180120     2009-07-14 19:09:31 /database/oracle/oradata/single/undotbs01.dbf

  3       Full 180120     2009-07-14 19:09:31 /database/oracle/oradata/single/sysaux01.dbf

  4       Full 180120     2009-07-14 19:09:31 /database/oracle/oradata/single/users01.dbf



BS Key  Type LV Size       Device Type Elapsed Time Completion Time    

------- ---- -- ---------- ----------- ------------ -------------------

3       Full    6.77M      DISK        00:00:01     2009-07-14 19:10:17

        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20090714T190930

        Piece Name: 



/database/oracle/flash_recovery_area/SINGLE/backupset/2009_07_14/o1_mf_ncnnf_TAG20090714T190



930_55rsws06_.bkp

  Control File Included: Ckp SCN: 180141       Ckp time: 2009-07-14 19:10:16



BS Key  Size       Device Type Elapsed Time Completion Time    

------- ---------- ----------- ------------ -------------------

4       11.00K     DISK        00:00:01     2009-07-14 19:10:19

        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20090714T191018

        Piece Name: /backup/rman_bk/SINGLE_4_1.bak



  List of Archived Logs in backup set 4

  Thrd Seq     Low SCN    Low Time            Next SCN   Next Time

  ---- ------- ---------- ------------------- ---------- ---------

  1    12      180113     2009-07-14 19:09:23 180144     2009-07-14 19:10:18



BS Key  Type LV Size       Device Type Elapsed Time Completion Time    

------- ---- -- ---------- ----------- ------------ -------------------

5       Full    6.80M      DISK        00:00:01     2009-07-14 19:10:21

        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20090714T191020

        Piece Name: 



/database/oracle/flash_recovery_area/SINGLE/autobackup/2009_07_14/o1_mf_s_692219420_55rswxkm



_.bkp

  Control File Included: Ckp SCN: 180150       Ckp time: 2009-07-14 19:10:20

  SPFILE Included: Modification time: 2009-07-14 19:06:08



BS Key  Type LV Size       Device Type Elapsed Time Completion Time    

------- ---- -- ---------- ----------- ------------ -------------------

6       Full    386.41M    DISK        00:00:42     2009-08-15 06:24:27

        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20090815T062345

        Piece Name: /backup/rman_bk/SINGLE_6_1.bak

  List of Datafiles in backup set 6

  File LV Type Ckp SCN    Ckp Time            Name

  ---- -- ---- ---------- ------------------- ----

  1       Full 265852     2009-08-15 06:23:45 /database/oracle/oradata/single/system01.dbf

  2       Full 265852     2009-08-15 06:23:45 /database/oracle/oradata/single/undotbs01.dbf

  3       Full 265852     2009-08-15 06:23:45 /database/oracle/oradata/single/sysaux01.dbf

  4       Full 265852     2009-08-15 06:23:45 /database/oracle/oradata/single/users01.dbf



BS Key  Type LV Size       Device Type Elapsed Time Completion Time    

------- ---- -- ---------- ----------- ------------ -------------------

7       Full    6.80M      DISK        00:00:02     2009-08-15 06:24:34

        BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20090815T062432

        Piece Name: 



/database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694938272_58cs11tf



_.bkp

  Control File Included: Ckp SCN: 265880       Ckp time: 2009-08-15 06:24:32

  SPFILE Included: Modification time: 2009-08-15 06:17:15



BS Key  Type LV Size       Device Type Elapsed Time Completion Time    

------- ---- -- ---------- ----------- ------------ -------------------

8       Incr 0  386.62M    DISK        00:00:41     2009-08-15 06:30:55

        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20090815T063014

        Piece Name: /backup/rman_bk/0_SINGLE_8_1.bak

  List of Datafiles in backup set 8

  File LV Type Ckp SCN    Ckp Time            Name

  ---- -- ---- ---------- ------------------- ----

  1    0  Incr 266106     2009-08-15 06:30:15 /database/oracle/oradata/single/system01.dbf

  2    0  Incr 266106     2009-08-15 06:30:15 /database/oracle/oradata/single/undotbs01.dbf

  3    0  Incr 266106     2009-08-15 06:30:15 /database/oracle/oradata/single/sysaux01.dbf

  4    0  Incr 266106     2009-08-15 06:30:15 /database/oracle/oradata/single/users01.dbf



BS Key  Type LV Size       Device Type Elapsed Time Completion Time    

------- ---- -- ---------- ----------- ------------ -------------------

9       Full    6.80M      DISK        00:00:00     2009-08-15 06:37:41

        BP Key: 9   Status: AVAILABLE  Compressed: NO  Tag: TAG20090815T063741

        Piece Name: 



/database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694939061_58cssp0n



_.bkp

  Control File Included: Ckp SCN: 266935       Ckp time: 2009-08-15 06:37:41

  SPFILE Included: Modification time: 2009-08-15 06:17:15



BS Key  Type LV Size       Device Type Elapsed Time Completion Time    

------- ---- -- ---------- ----------- ------------ -------------------

10      Full    6.80M      DISK        00:00:00     2009-08-15 06:39:22

        BP Key: 10   Status: AVAILABLE  Compressed: NO  Tag: TAG20090815T063922

        Piece Name: 



/database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694939162_58cswv6x



_.bkp

  Control File Included: Ckp SCN: 267025       Ckp time: 2009-08-15 06:39:22

  SPFILE Included: Modification time: 2009-08-15 06:17:15



BS Key  Type LV Size       Device Type Elapsed Time Completion Time    

------- ---- -- ---------- ----------- ------------ -------------------

11      Full    6.80M      DISK        00:00:00     2009-08-15 06:31:02

        BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: TAG20090815T063102

        Piece Name: 



/database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694938662_58csf6hn



_.bkp

  Control File Included: Ckp SCN: 266133       Ckp time: 2009-08-15 06:31:02

  SPFILE Included: Modification time: 2009-08-15 06:17:15



BS Key  Type LV Size       Device Type Elapsed Time Completion Time    

------- ---- -- ---------- ----------- ------------ -------------------

12      Incr 2  624.00K    DISK        00:00:00     2009-08-15 06:37:16

        BP Key: 12   Status: AVAILABLE  Compressed: NO  Tag: TAG20090815T063715

        Piece Name: /backup/rman_bk/2_SINGLE_12_1.bak

  List of Datafiles in backup set 12

  File LV Type Ckp SCN    Ckp Time            Name

  ---- -- ---- ---------- ------------------- ----

  1    2  Incr 266922     2009-08-15 06:37:16 /database/oracle/oradata/single/system01.dbf

  2    2  Incr 266922     2009-08-15 06:37:16 /database/oracle/oradata/single/undotbs01.dbf

  3    2  Incr 266922     2009-08-15 06:37:16 /database/oracle/oradata/single/sysaux01.dbf

  4    2  Incr 266922     2009-08-15 06:37:16 /database/oracle/oradata/single/users01.dbf



BS Key  Type LV Size       Device Type Elapsed Time Completion Time    

------- ---- -- ---------- ----------- ------------ -------------------

13      Incr 0  6.77M      DISK        00:00:00     2009-08-15 06:31:00

        BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: TAG20090815T063014

        Piece Name: /backup/rman_bk/0_SINGLE_9_1.bak

  Control File Included: Ckp SCN: 266129       Ckp time: 2009-08-15 06:31:00



BS Key  Type LV Size       Device Type Elapsed Time Completion Time    

------- ---- -- ---------- ----------- ------------ -------------------

14      Incr 2  6.77M      DISK        00:00:00     2009-08-15 06:36:27

        BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: TAG20090815T063626

        Piece Name: /backup/rman_bk/2_SINGLE_11_1.bak

  Control File Included: Ckp SCN: 266897       Ckp time: 2009-08-15 06:36:27



BS Key  Type LV Size       Device Type Elapsed Time Completion Time    

------- ---- -- ---------- ----------- ------------ -------------------

15      Incr 2  320.00K    DISK        00:00:00     2009-08-15 06:38:56

        BP Key: 15   Status: AVAILABLE  Compressed: NO  Tag: TAG20090815T063856

        Piece Name: /backup/rman_bk/2_SINGLE_14_1.bak

  List of Datafiles in backup set 15

  File LV Type Ckp SCN    Ckp Time            Name

  ---- -- ---- ---------- ------------------- ----

  1    2  Incr 266977     2009-08-15 06:38:56 /database/oracle/oradata/single/system01.dbf

  2    2  Incr 266977     2009-08-15 06:38:56 /database/oracle/oradata/single/undotbs01.dbf

  3    2  Incr 266977     2009-08-15 06:38:56 /database/oracle/oradata/single/sysaux01.dbf

  4    2  Incr 266977     2009-08-15 06:38:56 /database/oracle/oradata/single/users01.dbf



全都有了,开始恢复操作

RMAN> run {

2> restore database;

3> recover database;

4> sql 'alter database open';

5> }

O了
IndependentDeveloper 2009-08-15
  • 打赏
  • 举报
 回复 


先看一下备份集都有什么

RMAN> list backup;





List of Backup Sets

===================



BS Key  Size       Device Type Elapsed Time Completion Time    

------- ---------- ----------- ------------ -------------------

1       22.89M     DISK        00:00:03     2009-07-14 19:09:29

        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20090714T190926

        Piece Name: /backup/rman_bk/SINGLE_1_1.bak



  List of Archived Logs in backup set 1

  Thrd Seq     Low SCN    Low Time            Next SCN   Next Time

  ---- ------- ---------- ------------------- ---------- ---------

  1    11      173335     2009-07-13 15:55:13 180113     2009-07-14 19:09:23



BS Key  Type LV Size       Device Type Elapsed Time Completion Time    

------- ---- -- ---------- ----------- ------------ -------------------

2       Full    356.73M    DISK        00:00:41     2009-07-14 19:10:12

        BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20090714T190930

        Piece Name: 



/database/oracle/flash_recovery_area/SINGLE/backupset/2009_07_14/o1_mf_nnndf_TAG20090714T190



930_55rsvcg8_.bkp

  List of Datafiles in backup set 2

  File LV Type Ckp SCN    Ckp Time            Name

  ---- -- ---- ---------- ------------------- ----

  1       Full 180120     2009-07-14 19:09:31 /database/oracle/oradata/single/system01.dbf

  2       Full 180120     2009-07-14 19:09:31 /database/oracle/oradata/single/undotbs01.dbf

  3       Full 180120     2009-07-14 19:09:31 /database/oracle/oradata/single/sysaux01.dbf

  4       Full 180120     2009-07-14 19:09:31 /database/oracle/oradata/single/users01.dbf



BS Key  Type LV Size       Device Type Elapsed Time Completion Time    

------- ---- -- ---------- ----------- ------------ -------------------

3       Full    6.77M      DISK        00:00:01     2009-07-14 19:10:17

        BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20090714T190930

        Piece Name: 



/database/oracle/flash_recovery_area/SINGLE/backupset/2009_07_14/o1_mf_ncnnf_TAG20090714T190



930_55rsws06_.bkp

  Control File Included: Ckp SCN: 180141       Ckp time: 2009-07-14 19:10:16



BS Key  Size       Device Type Elapsed Time Completion Time    

------- ---------- ----------- ------------ -------------------

4       11.00K     DISK        00:00:01     2009-07-14 19:10:19

        BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20090714T191018

        Piece Name: /backup/rman_bk/SINGLE_4_1.bak



  List of Archived Logs in backup set 4

  Thrd Seq     Low SCN    Low Time            Next SCN   Next Time

  ---- ------- ---------- ------------------- ---------- ---------

  1    12      180113     2009-07-14 19:09:23 180144     2009-07-14 19:10:18



BS Key  Type LV Size       Device Type Elapsed Time Completion Time    

------- ---- -- ---------- ----------- ------------ -------------------

5       Full    6.80M      DISK        00:00:01     2009-07-14 19:10:21

        BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20090714T191020

        Piece Name: 



/database/oracle/flash_recovery_area/SINGLE/autobackup/2009_07_14/o1_mf_s_692219420_55rswxkm



_.bkp

  Control File Included: Ckp SCN: 180150       Ckp time: 2009-07-14 19:10:20

  SPFILE Included: Modification time: 2009-07-14 19:06:08



BS Key  Type LV Size       Device Type Elapsed Time Completion Time    

------- ---- -- ---------- ----------- ------------ -------------------

6       Full    386.41M    DISK        00:00:42     2009-08-15 06:24:27

        BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20090815T062345

        Piece Name: /backup/rman_bk/SINGLE_6_1.bak

  List of Datafiles in backup set 6

  File LV Type Ckp SCN    Ckp Time            Name

  ---- -- ---- ---------- ------------------- ----

  1       Full 265852     2009-08-15 06:23:45 /database/oracle/oradata/single/system01.dbf

  2       Full 265852     2009-08-15 06:23:45 /database/oracle/oradata/single/undotbs01.dbf

  3       Full 265852     2009-08-15 06:23:45 /database/oracle/oradata/single/sysaux01.dbf

  4       Full 265852     2009-08-15 06:23:45 /database/oracle/oradata/single/users01.dbf



BS Key  Type LV Size       Device Type Elapsed Time Completion Time    

------- ---- -- ---------- ----------- ------------ -------------------

7       Full    6.80M      DISK        00:00:02     2009-08-15 06:24:34

        BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20090815T062432

        Piece Name: 



/database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694938272_58cs11tf



_.bkp

  Control File Included: Ckp SCN: 265880       Ckp time: 2009-08-15 06:24:32

  SPFILE Included: Modification time: 2009-08-15 06:17:15



BS Key  Type LV Size       Device Type Elapsed Time Completion Time    

------- ---- -- ---------- ----------- ------------ -------------------

8       Incr 0  386.62M    DISK        00:00:41     2009-08-15 06:30:55

        BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20090815T063014

        Piece Name: /backup/rman_bk/0_SINGLE_8_1.bak

  List of Datafiles in backup set 8

  File LV Type Ckp SCN    Ckp Time            Name

  ---- -- ---- ---------- ------------------- ----

  1    0  Incr 266106     2009-08-15 06:30:15 /database/oracle/oradata/single/system01.dbf

  2    0  Incr 266106     2009-08-15 06:30:15 /database/oracle/oradata/single/undotbs01.dbf

  3    0  Incr 266106     2009-08-15 06:30:15 /database/oracle/oradata/single/sysaux01.dbf

  4    0  Incr 266106     2009-08-15 06:30:15 /database/oracle/oradata/single/users01.dbf



没有增量备份,追加一下

RMAN> catalog start with '/backup/rman_bk';



Starting implicit crosscheck backup at 2009-08-15 06:58:14

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=159 devtype=DISK

Crosschecked 8 objects

Finished implicit crosscheck backup at 2009-08-15 06:58:15



Starting implicit crosscheck copy at 2009-08-15 06:58:15

using channel ORA_DISK_1

Crosschecked 1 objects

Finished implicit crosscheck copy at 2009-08-15 06:58:16



searching for all files in the recovery area

cataloging files...

cataloging done



List of Cataloged Files

=======================

File Name: 



/database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694939061_58cssp0n



_.bkp

File Name: 



/database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694939162_58cswv6x



_.bkp

File Name: 



/database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694938662_58csf6hn



_.bkp



searching for all files that match the pattern /backup/rman_bk



List of Files Unknown to the Database

=====================================

File Name: /backup/rman_bk/2_SINGLE_12_1.bak

File Name: /backup/rman_bk/0_SINGLE_9_1.bak

File Name: /backup/rman_bk/2_SINGLE_11_1.bak

File Name: /backup/rman_bk/2_SINGLE_14_1.bak



Do you really want to catalog the above files (enter YES or NO)? yes

cataloging files...

cataloging done



List of Cataloged Files

=======================

File Name: /backup/rman_bk/2_SINGLE_12_1.bak

File Name: /backup/rman_bk/0_SINGLE_9_1.bak

File Name: /backup/rman_bk/2_SINGLE_11_1.bak

File Name: /backup/rman_bk/2_SINGLE_14_1.bak

继续
IndependentDeveloper 2009-08-15
  • 打赏
  • 举报
 回复
我刚在oracle 10.2.0.1上完全按楼主的条件测试了一下:(9i的库暂时没有)


SINGLE (DBID=3664176175)

原库的ID



RMAN> backup incremental level 0 format='/backup/rman_bk/0_%d_%s_%p.bak'

2> database include current controlfile;



Starting backup at 2009-08-15 06:30:14

using channel ORA_DISK_1

channel ORA_DISK_1: starting incremental level 0 datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00001 name=/database/oracle/oradata/single/system01.dbf

input datafile fno=00002 name=/database/oracle/oradata/single/undotbs01.dbf

input datafile fno=00003 name=/database/oracle/oradata/single/sysaux01.dbf

input datafile fno=00004 name=/database/oracle/oradata/single/users01.dbf

channel ORA_DISK_1: starting piece 1 at 2009-08-15 06:30:15

channel ORA_DISK_1: finished piece 1 at 2009-08-15 06:31:00

piece handle=/backup/rman_bk/0_SINGLE_8_1.bak tag=TAG20090815T063014 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:46

channel ORA_DISK_1: starting incremental level 0 datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

including current control file in backupset

channel ORA_DISK_1: starting piece 1 at 2009-08-15 06:31:00

channel ORA_DISK_1: finished piece 1 at 2009-08-15 06:31:01

piece handle=/backup/rman_bk/0_SINGLE_9_1.bak tag=TAG20090815T063014 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 2009-08-15 06:31:01



Starting Control File and SPFILE Autobackup at 2009-08-15 06:31:02

piece 



handle=/database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694938662_5



8csf6hn_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 2009-08-15 06:31:03



RMAN> sql 'alter system archive log current';



sql statement: alter system archive log current



RMAN> backup incremental level 2 format='/backup/rman_bk/2_%d_%s_%p.bak'

2> database ;



Starting backup at 2009-08-15 06:37:15

using channel ORA_DISK_1

channel ORA_DISK_1: starting incremental level 2 datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00001 name=/database/oracle/oradata/single/system01.dbf

input datafile fno=00002 name=/database/oracle/oradata/single/undotbs01.dbf

input datafile fno=00003 name=/database/oracle/oradata/single/sysaux01.dbf

input datafile fno=00004 name=/database/oracle/oradata/single/users01.dbf

channel ORA_DISK_1: starting piece 1 at 2009-08-15 06:37:16

channel ORA_DISK_1: finished piece 1 at 2009-08-15 06:37:41

piece handle=/backup/rman_bk/2_SINGLE_12_1.bak tag=TAG20090815T063715 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25

Finished backup at 2009-08-15 06:37:41



Starting Control File and SPFILE Autobackup at 2009-08-15 06:37:41

piece 



handle=/database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694939061_5



8cssp0n_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 2009-08-15 06:37:44



RMAN> sql 'alter system archive log current';



sql statement: alter system archive log current



RMAN> backup incremental level 2 format='/backup/rman_bk/2_%d_%s_%p.bak'

2> database ;



Starting backup at 2009-08-15 06:38:56

using channel ORA_DISK_1

channel ORA_DISK_1: starting incremental level 2 datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00001 name=/database/oracle/oradata/single/system01.dbf

input datafile fno=00002 name=/database/oracle/oradata/single/undotbs01.dbf

input datafile fno=00003 name=/database/oracle/oradata/single/sysaux01.dbf

input datafile fno=00004 name=/database/oracle/oradata/single/users01.dbf

channel ORA_DISK_1: starting piece 1 at 2009-08-15 06:38:56

channel ORA_DISK_1: finished piece 1 at 2009-08-15 06:39:21

piece handle=/backup/rman_bk/2_SINGLE_14_1.bak tag=TAG20090815T063856 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:26

Finished backup at 2009-08-15 06:39:22



Starting Control File and SPFILE Autobackup at 2009-08-15 06:39:22

piece 



handle=/database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694939162_5



8cswv6x_.bkp comment=NONE

Finished Control File and SPFILE Autobackup at 2009-08-15 06:39:25



RMAN> sql 'alter system archive log current';



sql statement: alter system archive log current



0级备份和2级增量备份都有了

之后我用dbca把原库删掉,这个跟你的条件基本一样了

然后我重建了init文件



看下我的备份目录都有什么

-bash-3.1$ ls -l /backup/rman_bk

total 830772

-rw-r----- 1 oracle dba 405405696 Aug 15 06:30 0_SINGLE_8_1.bak

-rw-r----- 1 oracle dba   7110656 Aug 15 06:31 0_SINGLE_9_1.bak

-rw-r----- 1 oracle dba   7110656 Aug 15 06:36 2_SINGLE_11_1.bak

-rw-r----- 1 oracle dba    647168 Aug 15 06:37 2_SINGLE_12_1.bak

-rw-r----- 1 oracle dba    335872 Aug 15 06:39 2_SINGLE_14_1.bak

-rw-r----- 1 oracle dba  24004096 Jul 14 19:09 SINGLE_1_1.bak

-rw-r----- 1 oracle dba     11776 Jul 14 19:10 SINGLE_4_1.bak

-rw-r----- 1 oracle dba 405184512 Aug 15 06:24 SINGLE_6_1.bak



之后我用rman连接



Recovery Manager: Release 10.2.0.1.0 - Production on Sat Aug 15 06:48:50 2009



Copyright (c) 1982, 2005, Oracle.  All rights reserved.



connected to target database (not started)



RMAN> startup nomount



Oracle instance started



Total System Global Area     167772160 bytes



Fixed Size                     1218316 bytes

Variable Size                 83888372 bytes

Database Buffers              79691776 bytes

Redo Buffers                   2973696 bytes



RMAN> set dbid=3664176175



executing command: SET DBID



RMAN> restore controlfile from '/backup/rman_bk/0_SINGLE_9_1.bak';



Starting restore at 2009-08-15 06:55:24

using target database control file instead of recovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=159 devtype=DISK



channel ORA_DISK_1: restoring control file

channel ORA_DISK_1: restore complete, elapsed time: 00:00:04

output filename=/database/oracle/oradata/single/control01.ctl

output filename=/database/oracle/oradata/single/control02.ctl

output filename=/database/oracle/oradata/single/control03.ctl

Finished restore at 2009-08-15 06:55:29



RMAN> sql 'alter database mount';



sql statement: alter database mount

released channel: ORA_DISK_1

楼主继续望下看
唐诗三百首 2009-08-14
  • 打赏
  • 举报
 回复
我步驟如下,還是不行啊.
1.用原DB模板創建同名DB
2.SHUTDOWN IMMEDIATE;
用冷備份的所有控制文件,數據文件,LOG文件替換現有DB.
測試正常,回到冷備份時間點數據.
3. SHUTDOWN IMMEDIATE;
startup nomout;
4. RMAN target UID/PWD@DBID nocatalog;
5. set dbid=原DB的DBID
6. RESTORE CONTROLFILE FROM '0級備份集(含控制文件)' -->OK
startup mout;
7. LIST BACKUP; --> 看不到原DB的RMAN備份集
RESTORE DATABASE; 也是不OK的.
以上請高手幫忙指正,萬分感謝!!


又是违规昵称 2009-08-13
  • 打赏
  • 举报
 回复
rman备份时是不是通过catalog方式做的？
如果是，那么备份信息就保存在catalog下面了

冷备前的控制文件中是不存在之后rman增量备份的信息的
唐诗三百首 2009-08-13
  • 打赏
  • 举报
 回复
補充說明一下, 冷備份是0801版本 0級備份是0802版本 1級備份是0803,0804,0805...
恢復目錄只有EXP導出的備份,才30多MB.
我第1步是把冷備份倒回去,現在是0801版本的數據.
問題是.在新的數據庫和新的恢復目錄中,根本就找不到之前的RMAN備份,雖然物理文件存在.
zzzzzyyy 2009-08-13
  • 打赏
  • 举报
 回复
我感觉应该是恢复冷备后，用dmp文件把数据imp回去

另外就是用rman的恢复到异机的机制吧，把0级恢复回去，然后再逐级恢复

我具体也没操作过，请大家指正
zzzzzyyy 2009-08-13
  • 打赏
  • 举报
 回复
你的冷备前的0级和1级备份都没有了吧，这样当然看不到rman的备份了，以后的任何级别的备份不会被之前的冷备承认的
唐诗三百首 2009-08-13
  • 打赏
  • 举报
 回复
做冷備份及0級備份時有備過控制文件,現在的問題是, 能恢復到冷備份時的狀態, 但恢復目錄中用LIST BACKUP就看不到那些0級和1級增量備份了! 還請指教詳細步驟,萬分感謝!
IndependentDeveloper 2009-08-13
  • 打赏
  • 举报
 回复
你catalog库都挂了,你怎么还依靠它呢......
用你的备份片和autobackup
IndependentDeveloper 2009-08-13
  • 打赏
  • 举报
 回复
你先rman target 用户名/密码 nocatalog
然后恢复了,你在连 catalog
当你用rman进行备份时,如果有catalog,rman元数据会存储两份,一份在catalog一份在控制文件,默认是7天控制文件的信息
唐诗三百首 2009-08-13
  • 打赏
  • 举报
 回复
還有一個問題 我的備份信息不是放在DB本身的控制文件上的啊 而是放在恢復目錄中 我的新DB注冊進新的恢復目錄 然后怎么做呢?? 還請詳細一點說哦 接下來的這幾步很關鍵 謝謝!!!
IndependentDeveloper 2009-08-13
  • 打赏
  • 举报
 回复
如果CONFIGURE CONTROLFILE AUTOBACKUP ON的状态下你做的增量备份
那么你可以去找最近的一个autobackup,然后恢复控制文件,然后恢复数据库,如果你恢复控制文件时间点后的归档文件还在,还能完全恢复,如果没了,只能恢复到识别的增量备份状态了
IndependentDeveloper 2009-08-13
  • 打赏
  • 举报
 回复
[Quote=引用 2 楼 ap0405140 的回复:]
做冷備份及0級備份時有備過控制文件,現在的問題是, 能恢復到冷備份時的狀態, 但恢復目錄中用LIST BACKUP就看不到那些0級和1級增量備份了! 還請指教詳細步驟,萬分感謝!
[/Quote]

楼主应该能找到0级备份片中含备份控制文件的那个文件吧


RMAN>startup nomount

RMAN>set dbid=你库的id

RMAN>run {

2>allocate channel m1 type disk;

3>restore controlfile from '你知道的备份控制文件的那个备份片';

4>}

后边就简单了,你应该都会
如果你在开始备份的时候指定CONFIGURE CONTROLFILE AUTOBACKUP ON那就更容易找到控制文件了
liuyi8903 2009-08-12
  • 打赏
  • 举报
 回复
有没有备份过的控制文件?

Oracle9i灾难恢复详细步骤 pdf
Oracle9i灾难恢复详细步骤 编写本篇文档的目的是当Oracle9i 数据库出现灾难时怎样使用有效备份来进行数据库的不完全恢复。 二、本文档适合情况 1. 服务器崩溃，例如所有硬盘损坏、存储损坏，造成数据库崩溃，丢失...
生产机的OS宕机，rman灾难恢复
朋友的数据库系统出问题了，以下是他的解决过程，对我学习RMAN很有帮助：以下是一个案例：生产机的OS宕机，rman灾难恢复本人在学习rman过程中，突然碰到一个千载难逢的"好机会"来学习rman,因为是生产机，所以以下...
Oracle RMAN备份与恢复视频教程篇
本套课程讲解了Oracle RMAN备份恢复的课程,讲解了压缩备份,备份加密,数据库恢复,恢复指导,块跟踪,3种增量备份、基于增量备份的数据恢复、恢复目录catalog、手工制作坏块、坏块的屏蔽与恢复、使用dbms_backup_restore...
Oracle数据库RMAN备份与灾难恢复在寒区旱区特色数据库的应用
引言  寒区旱区特色数据库随着数据的日益增长和数据服务的全面开展，数据的安全问题日益突出，尽管数据管理采用WEB服务器与数据库管理后台的...因此数据的安全备份以及可能出现的数据库灾难的恢复已成为必须考虑和解
RMAN - 备份与恢复实践
1 RMAN备份与恢复实践 1.1 备份 1.1.1 对数据库进行全备 　使用backup database命令执行备份 RMAN> BACKUP DATABASE; 　执行上述命令后将对目标数据库中的所有数据文件进行备份，由于没有显式指定...
Oracle 高级技术

3,490

社区成员

18,714

社区内容

发帖
与我相关
我的任务
社区描述
Oracle 高级技术相关讨论专区
社区管理员
  • 高级技术社区
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章