ORA-19527与ORA-00312和db_recovery_file_dest_size of 2048 MB is 0.00% used

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中得到证实:

    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.

就是警告而已，不过如果你用archivelog mode，又没有指定归档路径，就会自动归档到
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/