在physical standby database上执行开启日志应用会报错误ORA-19527: physical standby redo log must be renamed
alter database recover managed standby database disconnect from session
Mon Jul 23 09:40:12 2012
Attempt to start background Managed Standby Recovery process (dg2)
MRP0 started with pid=24, OS id=6786
Mon Jul 23 09:40:12 2012
MRP0: Background Managed Standby Recovery process started (dg2)
Managed Standby Recovery not using Real Time Apply
Clearing online redo logfile 1 /u01/app/oracle/oradata/dg1/redo01.log
Clearing online log 1 of thread 1 sequence number 70
Mon Jul 23 09:40:18 2012
Errors in file /u01/app/oracle/admin/dg1/bdump/dg2_mrp0_6786.trc:
ORA-19527: physical standby redo log must be renamed
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/dg1/redo01.log'
Clearing online redo logfile 1 complete
Media Recovery Waiting for thread 1 sequence 70 (in transit)
Mon Jul 23 09:40:18 2012
Completed: alter database recover managed standby database disconnect from session
Mon Jul 23 09:40:32 2012
查看报错信息：
[oracle@dg3 dg1]$ oerr ora 19527
19527, 00000, "physical standby redo log must be renamed"
// *Cause:  The CLEAR LOGFILE command was used at a physical standby
//          database.  This command cannot be used at a physical standby
//          database unless the LOG_FILE_NAME_CONVERT initialization
//          parameter is set.  This is required to avoid overwriting
//          the primary database's logfiles.
// *Action  Set the LOG_FILE_NAME_CONVERT initialization parameter.
提示要设置log_file_name_convert参数，因为我的dg是在异机，并且目录结构一样，所以没有设置这个参数。
很奇怪的是有的时候备库可以应用日志有的时候不能应用日志。
添加了log_file_name_convert之后可以正常应用归档。
alter database recover managed standby database disconnect from session
Mon Jul 23 09:46:10 2012
Attempt to start background Managed Standby Recovery process (dg2)
MRP0 started with pid=23, OS id=6985
Mon Jul 23 09:46:10 2012
MRP0: Background Managed Standby Recovery process started (dg2)
Managed Standby Recovery not using Real Time Apply
Clearing online redo logfile 1 /u01/app/oracle/oradata/dg1/redo01.log
Clearing online log 1 of thread 1 sequence number 73
Mon Jul 23 09:46:16 2012
Completed: alter database recover managed standby database disconnect from session
Mon Jul 23 09:46:17 2012
Clearing online redo logfile 1 complete
Clearing online redo logfile 2 /u01/app/oracle/oradata/dg1/redo02.log
Clearing online log 2 of thread 1 sequence number 72
Clearing online redo logfile 2 complete
Media Recovery Waiting for thread 1 sequence 73
看到没有报错了。