Oracle RMAN Recover中使用BBED跳过缺失的归档继续Recover的测试(二)
661033
channel ORA_DISK_1: restoring datafile00004 to /u01/app/oracle/oradata/dave/users.259.816661039
channel ORA_DISK_1: restoring datafile00006 to /u01/app/oracle/oradata/dave/dave01.dbf
channel ORA_DISK_1: restoring datafile00007 to /u01/app/oracle/oradata/dave/dave02.dbf
channel ORA_DISK_1: reading from backuppiece /u01/backup/dave_lev0_05oe3kdv_1_1_20130706
channel ORA_DISK_1: piece handle=/u01/backup/dave_lev0_05oe3kdv_1_1_20130706tag=DAVE_LEV0
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete,elapsed time: 00:00:25
Finished restore at 06-JUL-13
RMAN>
RMAN> recoverdatabase;
Starting recover at 06-JUL-13
using channel ORA_DISK_1
starting media recovery
archived log for thread 1 with sequence 152is already on disk as file /u01/arch/1_152_816661296.dbf
archived log for thread 1 with sequence 154is already on disk as file /u01/arch/1_154_816661296.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGESTACK FOLLOWS ===============
RMAN-00571:===========================================================
RMAN-03002: failure of recover command at07/06/2013 23:23:48
RMAN-06053: unable to perform mediarecovery because of missing log
RMAN-06025: no backup ofarchived log for thread 1 with sequence 153 and starting SCN of 3836001 foundto restore
RMAN>
这个153 是我们刚才手工删掉的归档。如果这个不搞定，后面没办法恢复。
2.6 BBED 推荐SCN
2.6.1 修改原理说明
-- System Checkpoint SCN：
SQL> select checkpoint_change# fromv$database;
CHECKPOINT_CHANGE#
------------------
3836654
--- Datafile CheckpointSCN：
SQL> select name,checkpoint_change# fromv$datafile;
NAME CHECKPOINT_CHANGE#
-------------------------------------------------------------------------
/u01/app/oracle/oradata/dave/system.256.816661027 3836654
/u01/app/oracle/oradata/dave/sysaux.257.816661033 3836654
/u01/app/oracle/oradata/dave/undotbs1.258.816661037 3836654
/u01/app/oracle/oradata/dave/users.259.816661039 3836654
/u01/app/oracle/oradata/dave/undotbs2.265.816661787 3836654
/u01/app/oracle/oradata/dave/dave01.dbf 3836654
/u01/app/oracle/oradata/dave/dave02.dbf 3836654
7 rows selected.
---START SCN:
SQL> select name,checkpoint_change# fromv$datafile_header;
NAME CHECKPOINT_CHANGE#
-------------------------------------------------------------------------
/u01/app/oracle/oradata/dave/system.256.816661027 3835435
/u01/app/oracle/oradata/dave/sysaux.257.816661033 3835434
/u01/app/oracle/oradata/dave/undotbs1.258.816661037 3835435
/u01/app/oracle/oradata/dave/users.259.816661039 3835434
/u01/app/oracle/oradata/dave/undotbs2.265.816661787 3835435
/u01/app/oracle/oradata/dave/dave01.dbf 3835434
/u01/app/oracle/oradata/dave/dave02.dbf 3835434
7 rows selected.
+++++SCN号与数据库启动：
在数据库启动过程中，当SystemCheckpoint SCN、Dat