ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-19527: physical standby redo log must be rename

ORA-19527: physical standby redo log must be rename

原创 Linux操作系统 作者:haha牛 时间:2012-07-23 12:12:39 0 删除 编辑
在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
看到没有报错了。

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/23655288/viewspace-736370/,如需转载,请注明出处,否则将追究法律责任。

下一篇: RAC管理常用命令
请登录后发表评论 登录
全部评论

注册时间:2010-04-04

  • 博文量
    102
  • 访问量
    298539