我刚在oracle 10.2.0.1上完全按楼主的条件测试了一下:(9i的库暂时没有)SINGLE (DBID=3664176175) 原库的IDRMAN> 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:01Starting 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_58csf6hn_.bkp comment=NONE Finished Control File and SPFILE Autobackup at 2009-08-15 06:31:03RMAN> sql 'alter system archive log current';sql statement: alter system archive log currentRMAN> 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:41Starting 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_58cssp0n_.bkp comment=NONE Finished Control File and SPFILE Autobackup at 2009-08-15 06:37:44RMAN> sql 'alter system archive log current';sql statement: alter system archive log currentRMAN> 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:22Starting 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_58cswv6x_.bkp comment=NONE Finished Control File and SPFILE Autobackup at 2009-08-15 06:39:25RMAN> sql 'alter system archive log current';sql statement: alter system archive log current0级备份和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 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.connected to target database (not started)RMAN> startup nomountOracle instance startedTotal System Global Area 167772160 bytesFixed Size 1218316 bytes Variable Size 83888372 bytes Database Buffers 79691776 bytes Redo Buffers 2973696 bytesRMAN> set dbid=3664176175executing command: SET DBIDRMAN> 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=DISKchannel 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:29RMAN> sql 'alter database mount';sql statement: alter database mount released channel: ORA_DISK_1楼主继续望下看
先看一下备份集都有什么 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:23BS 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_TAG20090714T190930_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.dbfBS 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_TAG20090714T190930_55rsws06_.bkp Control File Included: Ckp SCN: 180141 Ckp time: 2009-07-14 19:10:16BS 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:18BS 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:08BS 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.dbfBS 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:15BS 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:15Starting 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:16searching for all files in the recovery area cataloging files... cataloging doneList 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_.bkpsearching for all files that match the pattern /backup/rman_bkList 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.bakDo you really want to catalog the above files (enter YES or NO)? yes cataloging files... cataloging doneList 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 继续
再看一下备份集 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:23BS 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_TAG20090714T190930_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.dbfBS 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_TAG20090714T190930_55rsws06_.bkp Control File Included: Ckp SCN: 180141 Ckp time: 2009-07-14 19:10:16BS 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:18BS 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:08BS 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.dbfBS 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:15BS 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.dbfBS 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:15BS 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:15BS 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:15BS 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.dbfBS 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:00BS 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:27BS 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了
恢復目錄只有EXP導出的備份,才30多MB.
我第1步是把冷備份倒回去,現在是0801版本的數據.
問題是.在新的數據庫和新的恢復目錄中,根本就找不到之前的RMAN備份,雖然物理文件存在.
如果是,那么备份信息就保存在catalog下面了冷备前的控制文件中是不存在之后rman增量备份的信息的
楼主应该能找到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那就更容易找到控制文件了
那么你可以去找最近的一个autobackup,然后恢复控制文件,然后恢复数据库,如果你恢复控制文件时间点后的归档文件还在,还能完全恢复,如果没了,只能恢复到识别的增量备份状态了
然后恢复了,你在连 catalog
当你用rman进行备份时,如果有catalog,rman元数据会存储两份,一份在catalog一份在控制文件,默认是7天控制文件的信息
用你的备份片和autobackup
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的.
以上請高手幫忙指正,萬分感謝!!
原库的IDRMAN> 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:01Starting 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_58csf6hn_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2009-08-15 06:31:03RMAN> sql 'alter system archive log current';sql statement: alter system archive log currentRMAN> 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:41Starting 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_58cssp0n_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2009-08-15 06:37:44RMAN> sql 'alter system archive log current';sql statement: alter system archive log currentRMAN> 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:22Starting 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_58cswv6x_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2009-08-15 06:39:25RMAN> sql 'alter system archive log current';sql statement: alter system archive log current0级备份和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 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.connected to target database (not started)RMAN> startup nomountOracle instance startedTotal System Global Area 167772160 bytesFixed Size 1218316 bytes
Variable Size 83888372 bytes
Database Buffers 79691776 bytes
Redo Buffers 2973696 bytesRMAN> set dbid=3664176175executing command: SET DBIDRMAN> 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=DISKchannel 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:29RMAN> sql 'alter database mount';sql statement: alter database mount
released channel: ORA_DISK_1楼主继续望下看
先看一下备份集都有什么
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:23BS 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_TAG20090714T190930_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.dbfBS 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_TAG20090714T190930_55rsws06_.bkp
Control File Included: Ckp SCN: 180141 Ckp time: 2009-07-14 19:10:16BS 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:18BS 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:08BS 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.dbfBS 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:15BS 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:15Starting 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:16searching for all files in the recovery area
cataloging files...
cataloging doneList 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_.bkpsearching for all files that match the pattern /backup/rman_bkList 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.bakDo you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging doneList 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
继续
再看一下备份集
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:23BS 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_TAG20090714T190930_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.dbfBS 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_TAG20090714T190930_55rsws06_.bkp
Control File Included: Ckp SCN: 180141 Ckp time: 2009-07-14 19:10:16BS 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:18BS 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:08BS 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.dbfBS 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:15BS 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.dbfBS 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:15BS 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:15BS 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:15BS 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.dbfBS 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:00BS 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:27BS 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了