Tue Aug 21 13:41:52 2012
Errors in file d:\oracle\product\10.2.0\admin\billing\bdump\billing_mrp0_2216.trc:
ORA-19527: 必须重命名物理备用重做日志
ORA-00312: 联机日志 1 线程 1: 'E:\CZ\BILLING\REDO01.LOG'
Clearing online redo logfile 1 complete
Media Recovery Waiting for thread 1 sequence 13364
Tue Aug 21 13:41:52 2012
Completed: alter database recover managed standby database disconnect from session
Tue Aug 21 13:55:58 2012
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
这是
10g以后,
oracle为了加快swtichover的速度,在can become a primary之前就去clear the online logfiles了,而如果没有设置log_file_name_convert,这个时候oracle可能就不认识哪怕是你copy过来的一模一样的logfile了
这个说法也在taobao dba team的blog中得到证实:
解决的办法就是设置log_file_name_convert参数,其实这个standby库建立的时候就是从primary冷备copy过来的文件,路径也完全一样。
alter system set log_file_name_convert='/u02/oradata/felixdb/','/u02/oradata/felixdb/' scope=spfile;
当设置完成,重启standby,apply日志以后,看到后台中果然可以clear了online logfiles,也就没有了问题
db_recovery_file_dest_size of 2048 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
show parameter db_recovery_file_dest,所以你要监控select * from v$flash_recovery_area_usage
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/12131609/viewspace-741487/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/12131609/viewspace-741487/