环境:Linux Redhat4 ,Oracle 10g,file system
通过reset database to incarnation 3;回到上一次resetlog所在的incarnation.
目前只有3月24号的备份和所有的归档,准备恢复数据库到3月25号13:20到16:50之间,也就是跨过
incarnation 4的resetlogs.
RMAN> list incarnation;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 ORCL 1090770270 PARENT 1 2005-06-30 19:09:40
2 2 ORCL 1090770270 PARENT 446075 2005-07-07 01:58:57
3 3 ORCL 1090770270 CURRENT 1010774 2008-03-25 13:20:57
4 4 ORCL 1090770270 ORPHAN 1012317 2008-03-25 16:52:20
RMAN> run
2> {
3> set until time= '2008-03-25 13:40:00';
4> restore database;
5> recover database;
6> alter database open resetlogs;
7> }
executing command: SET until clause
Starting restore at 2008-03-25 18:05:57
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=157 devtype=DISK
skipping datafile 1; already restored to file /u01/app/oracle/oradata/orcl/system01.dbf
skipping datafile 2; already restored to file /u01/app/oracle/oradata/orcl/undotbs01.dbf
skipping datafile 3; already restored to file /u01/app/oracle/oradata/orcl/sysaux01.dbf
skipping datafile 4; already restored to file /u01/app/oracle/oradata/orcl/users01.dbf
skipping datafile 5; already restored to file /u01/app/oracle/oradata/orcl/example01.dbf
skipping datafile 6; already restored to file /u01/app/oracle/oradata/orcl/staging01.dbf
restore not done; all files readonly, offline, or already restored
Finished restore at 2008-03-25 18:05:57
Starting recover at 2008-03-25 18:05:57
using channel ORA_DISK_1
starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 03/25/2008 18:05:58
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
start until time 'MAR 25 2008 13:40:00'
ORA-00283: recovery session canceled due to errors
ORA-38727: FLASHBACK DATABASE requires a current control file.
这个datafile已经是24号restore过来的,由于只切换了incarnation,controlfile还是incarnation 4的.
RMAN> restore controlfile from autobackup;
Starting restore at 2008-03-25 18:06:26
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/25/2008 18:06:26
RMAN-06496: must use the TO clause when the database is mounted or open
RMAN> list backup of controlfile;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
4 Full 6.80M DISK 00:00:00 2008-03-24 17:05:29
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20080324T170529
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2008_03_24/o1_mf_s_650221529_3ygvps8h_.bkp
Control File Included: Ckp SCN: 934330 Ckp time: 2008-03-24 17:05:29
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
5 Full 6.80M DISK 00:00:00 2008-03-24 17:08:40
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20080324T170840
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2008_03_24/o1_mf_s_650221720_3ygvwrll_.bkp
Control File Included: Ckp SCN: 934500 Ckp time: 2008-03-24 17:08:40
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
6 Full 6.80M DISK 00:00:00 2008-03-24 17:12:50
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20080324T171250
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2008_03_24/o1_mf_s_650221970_3ygw4l9q_.bkp
Control File Included: Ckp SCN: 934659 Ckp time: 2008-03-24 17:12:50
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
10 Full 6.80M DISK 00:00:00 2008-03-24 17:18:20
BP Key: 10 Status: AVAILABLE Compressed: NO Tag: TAG20080324T171820
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2008_03_24/o1_mf_s_650222300_3ygwgw8v_.bkp
Control File Included: Ckp SCN: 935569 Ckp time: 2008-03-24 17:18:20
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
12 Full 6.80M DISK 00:00:00 2008-03-25 13:10:47
BP Key: 11 Status: AVAILABLE Compressed: NO Tag: TAG20080325T131047
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2008_03_25/o1_mf_s_650293847_3yk2bqr2_.bkp
Control File Included: Ckp SCN: 1010240 Ckp time: 2008-03-25 13:10:47
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
13 Full 6.80M DISK 00:00:01 2008-03-25 13:21:09
BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20080325T132107
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2008_03_25/o1_mf_s_650294467_3yk2y4nk_.bkp
Control File Included: Ckp SCN: 1011647 Ckp time: 2008-03-25 13:21:07
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
14 Full 6.80M DISK 00:00:00 2008-03-25 14:37:30
BP Key: 13 Status: AVAILABLE Compressed: NO Tag: TAG20080325T143730
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2008_03_25/o1_mf_s_650298991_3yk7fbd0_.bkp
Control File Included: Ckp SCN: 1016697 Ckp time: 2008-03-25 14:36:31
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
15 Full 6.80M DISK 00:00:00 2008-03-25 15:52:18
BP Key: 14 Status: AVAILABLE Compressed: NO Tag: TAG20080325T155218
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2008_03_25/o1_mf_s_650303538_3ykcslo0_.bkp
Control File Included: Ckp SCN: 1022568 Ckp time: 2008-03-25 15:52:18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
16 Full 6.80M DISK 00:00:00 2008-03-25 15:52:20
BP Key: 15 Status: AVAILABLE Compressed: NO Tag: TAG20080325T155220
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2008_03_25/o1_mf_s_650303540_3ykcsnfd_.bkp
Control File Included: Ckp SCN: 1022575 Ckp time: 2008-03-25 15:52:20
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
17 Full 6.80M DISK 00:00:01 2008-03-25 15:52:22
BP Key: 16 Status: AVAILABLE Compressed: NO Tag: TAG20080325T155221
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2008_03_25/o1_mf_s_650303541_3ykcsp61_.bkp
Control File Included: Ckp SCN: 1022580 Ckp time: 2008-03-25 15:52:21
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
18 Full 6.80M DISK 00:00:01 2008-03-25 15:57:01
BP Key: 17 Status: AVAILABLE Compressed: NO Tag: TAG20080325T155700
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2008_03_25/o1_mf_s_650303820_3ykd2f5k_.bkp
Control File Included: Ckp SCN: 1022902 Ckp time: 2008-03-25 15:57:00
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
19 Full 6.80M DISK 00:00:00 2008-03-25 15:57:36
BP Key: 18 Status: AVAILABLE Compressed: NO Tag: TAG20080325T155736
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2008_03_25/o1_mf_s_650303856_3ykd3jov_.bkp
Control File Included: Ckp SCN: 1022929 Ckp time: 2008-03-25 15:57:36
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
20 Full 6.80M DISK 00:00:01 2008-03-25 16:52:31
BP Key: 19 Status: AVAILABLE Compressed: NO Tag: TAG20080325T165230
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2008_03_25/o1_mf_s_650307150_3ykhbgx3_.bkp
Control File Included: Ckp SCN: 1012597 Ckp time: 2008-03-25 16:52:30
RMAN>
查看备份,发现没有controlfile在incarnation 3时的备份.
通过reset database to incarnation 3;回到上一次resetlog所在的incarnation.
目前只有3月24号的备份和所有的归档,准备恢复数据库到3月25号13:20到16:50之间,也就是跨过
incarnation 4的resetlogs.
RMAN> list incarnation;
List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1 1 ORCL 1090770270 PARENT 1 2005-06-30 19:09:40
2 2 ORCL 1090770270 PARENT 446075 2005-07-07 01:58:57
3 3 ORCL 1090770270 CURRENT 1010774 2008-03-25 13:20:57
4 4 ORCL 1090770270 ORPHAN 1012317 2008-03-25 16:52:20
RMAN> run
2> {
3> set until time= '2008-03-25 13:40:00';
4> restore database;
5> recover database;
6> alter database open resetlogs;
7> }
executing command: SET until clause
Starting restore at 2008-03-25 18:05:57
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=157 devtype=DISK
skipping datafile 1; already restored to file /u01/app/oracle/oradata/orcl/system01.dbf
skipping datafile 2; already restored to file /u01/app/oracle/oradata/orcl/undotbs01.dbf
skipping datafile 3; already restored to file /u01/app/oracle/oradata/orcl/sysaux01.dbf
skipping datafile 4; already restored to file /u01/app/oracle/oradata/orcl/users01.dbf
skipping datafile 5; already restored to file /u01/app/oracle/oradata/orcl/example01.dbf
skipping datafile 6; already restored to file /u01/app/oracle/oradata/orcl/staging01.dbf
restore not done; all files readonly, offline, or already restored
Finished restore at 2008-03-25 18:05:57
Starting recover at 2008-03-25 18:05:57
using channel ORA_DISK_1
starting media recovery
media recovery failed
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 03/25/2008 18:05:58
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover if needed
start until time 'MAR 25 2008 13:40:00'
ORA-00283: recovery session canceled due to errors
ORA-38727: FLASHBACK DATABASE requires a current control file.
这个datafile已经是24号restore过来的,由于只切换了incarnation,controlfile还是incarnation 4的.
RMAN> restore controlfile from autobackup;
Starting restore at 2008-03-25 18:06:26
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 03/25/2008 18:06:26
RMAN-06496: must use the TO clause when the database is mounted or open
RMAN> list backup of controlfile;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
4 Full 6.80M DISK 00:00:00 2008-03-24 17:05:29
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20080324T170529
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2008_03_24/o1_mf_s_650221529_3ygvps8h_.bkp
Control File Included: Ckp SCN: 934330 Ckp time: 2008-03-24 17:05:29
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
5 Full 6.80M DISK 00:00:00 2008-03-24 17:08:40
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20080324T170840
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2008_03_24/o1_mf_s_650221720_3ygvwrll_.bkp
Control File Included: Ckp SCN: 934500 Ckp time: 2008-03-24 17:08:40
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
6 Full 6.80M DISK 00:00:00 2008-03-24 17:12:50
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20080324T171250
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2008_03_24/o1_mf_s_650221970_3ygw4l9q_.bkp
Control File Included: Ckp SCN: 934659 Ckp time: 2008-03-24 17:12:50
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
10 Full 6.80M DISK 00:00:00 2008-03-24 17:18:20
BP Key: 10 Status: AVAILABLE Compressed: NO Tag: TAG20080324T171820
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2008_03_24/o1_mf_s_650222300_3ygwgw8v_.bkp
Control File Included: Ckp SCN: 935569 Ckp time: 2008-03-24 17:18:20
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
12 Full 6.80M DISK 00:00:00 2008-03-25 13:10:47
BP Key: 11 Status: AVAILABLE Compressed: NO Tag: TAG20080325T131047
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2008_03_25/o1_mf_s_650293847_3yk2bqr2_.bkp
Control File Included: Ckp SCN: 1010240 Ckp time: 2008-03-25 13:10:47
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
13 Full 6.80M DISK 00:00:01 2008-03-25 13:21:09
BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20080325T132107
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2008_03_25/o1_mf_s_650294467_3yk2y4nk_.bkp
Control File Included: Ckp SCN: 1011647 Ckp time: 2008-03-25 13:21:07
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
14 Full 6.80M DISK 00:00:00 2008-03-25 14:37:30
BP Key: 13 Status: AVAILABLE Compressed: NO Tag: TAG20080325T143730
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2008_03_25/o1_mf_s_650298991_3yk7fbd0_.bkp
Control File Included: Ckp SCN: 1016697 Ckp time: 2008-03-25 14:36:31
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
15 Full 6.80M DISK 00:00:00 2008-03-25 15:52:18
BP Key: 14 Status: AVAILABLE Compressed: NO Tag: TAG20080325T155218
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2008_03_25/o1_mf_s_650303538_3ykcslo0_.bkp
Control File Included: Ckp SCN: 1022568 Ckp time: 2008-03-25 15:52:18
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
16 Full 6.80M DISK 00:00:00 2008-03-25 15:52:20
BP Key: 15 Status: AVAILABLE Compressed: NO Tag: TAG20080325T155220
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2008_03_25/o1_mf_s_650303540_3ykcsnfd_.bkp
Control File Included: Ckp SCN: 1022575 Ckp time: 2008-03-25 15:52:20
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
17 Full 6.80M DISK 00:00:01 2008-03-25 15:52:22
BP Key: 16 Status: AVAILABLE Compressed: NO Tag: TAG20080325T155221
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2008_03_25/o1_mf_s_650303541_3ykcsp61_.bkp
Control File Included: Ckp SCN: 1022580 Ckp time: 2008-03-25 15:52:21
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
18 Full 6.80M DISK 00:00:01 2008-03-25 15:57:01
BP Key: 17 Status: AVAILABLE Compressed: NO Tag: TAG20080325T155700
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2008_03_25/o1_mf_s_650303820_3ykd2f5k_.bkp
Control File Included: Ckp SCN: 1022902 Ckp time: 2008-03-25 15:57:00
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
19 Full 6.80M DISK 00:00:00 2008-03-25 15:57:36
BP Key: 18 Status: AVAILABLE Compressed: NO Tag: TAG20080325T155736
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2008_03_25/o1_mf_s_650303856_3ykd3jov_.bkp
Control File Included: Ckp SCN: 1022929 Ckp time: 2008-03-25 15:57:36
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
20 Full 6.80M DISK 00:00:01 2008-03-25 16:52:31
BP Key: 19 Status: AVAILABLE Compressed: NO Tag: TAG20080325T165230
Piece Name: /u01/app/oracle/flash_recovery_area/ORCL/autobackup/2008_03_25/o1_mf_s_650307150_3ykhbgx3_.bkp
Control File Included: Ckp SCN: 1012597 Ckp time: 2008-03-25 16:52:30
RMAN>
查看备份,发现没有controlfile在incarnation 3时的备份.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/175005/viewspace-231106/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/175005/viewspace-231106/