ORA-19527与ORA-00312和db_recovery_file_dest_size of 2048 MB is 0.00% used
ORA-19527与ORA-00312和db_recovery_file_dest_size of 2048 MB is 0.00% used
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了
而如果没有设置log_file_name_convert，这个时候oracle可能就不认识哪怕是你copy过来的一模一样的logfile了
这个说法也在taobao dba team的blog中得到证实:
http://www.taobaodba.com/html/80_oracle10g_standby_ora_00367_ora_19527.html
解决的办法就是设置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
目录 返回
首页