1,在主库配置备库log_archive_dest_state_2=defer；再还原enable时，备库出现不应用日志；
  测试主库添删数据文件及表空间提示报错，在alert中



2,处理以上方法

在主库生成备份控制文件,根据alert进行修改，把在备库上少的几个主库数据文件，全部scp到备库

 备库如下
Thu Jan 28 05:58:33 2010
Errors in file /oracle/admin/centos/bdump/rhel_mrp0_2544.trc:
ORA-01111: name for data file 5 is unknown - rename to correct file
ORA-01110: data file 5: '/oracle/product/10.2.0/db_1/dbs/UNNAMED00005'
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01111: name for data file 5 is unknown - rename to correct file
ORA-01110: data file 5: '/oracle/product/10.2.0/db_1/dbs/UNNAMED00005'
Thu Jan 28 05:58:33 2010
Errors in file /oracle/admin/centos/bdump/rhel_mrp0_2544.trc:
ORA-01111: name for data file 5 is unknown - rename to correct file
ORA-01110: data file 5: '/oracle/product/10.2.0/db_1/dbs/UNNAMED00005'
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01111: name for data file 5 is unknown - rename to correct file
ORA-01110: data file 5: '/oracle/product/10.2.0/db_1/dbs/UNNAMED00005'
Thu Jan 28 05:58:33 2010
MRP0: Background Media Recovery process shutdown (rhel)
Thu Jan 28 05:58:34 2010
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION


mount打开备库，备库物理恢复就可以了


---以上问题解决了，但备库不能open,一open就提示恢复，这如何处理哟

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE cancel immediate;

Database altered.

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-16004: backup database requires recovery
ORA-01194: file 6 needs more recovery to be consistent
ORA-01110: data file 6: '/oracle/oradata/centos/centos/hard01.dbf'


SQL> host oerr ora 16004
16004, 00000, "backup database requires recovery"
// *Cause:  The control file is for a backup database which requires recovery,
//          and cannot be opened for read-only access by this instance.
// *Action: Perform. the necessary recovery and re-open for read-only access.
//          

SQL>



3,想在备库上利用flashback功能，必须先在创建备库前打开主库的flashback on功能
主库 --请注意，添加db_recovery_file_dest相关
  startup mount
  alter database flashback on;
创建备库
  开启备库flashback功能，同主库操作

具体flashback操作如下
  在备库上记录一个当前的scn
   select current_scn from v$database
  在主库进行相关变更，同时同步到备库
  在备库关闭重作应用
   
  在备库利用flashback
    flashback database to scn 上面查到的scn号
  可以在备库alert看到相关操作变化了

  此之后，你可以打开备库重作应用，主备库又可以进行同步了