client_id='' type='UNKNOWN' level='16'
host_id='TEST' host_addr='127.0.0.1' module='sqlplus@TEST (TNS V1-V3)'
pid='30717'>
Errors in file /home/oracle/ora11gR2/diag/rdbms/yjstest/yjstest/trace/yjstest_ora_30717.trc:
ORA-16038: log 2 sequence# 587 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1: '/home/oracle/ora11gR2/oradata/yjstest/redo02.log'
这个说明.db_recovery_file_dest_size闪回恢复区域空间已经满了。
解决办法:把参数文件db_recovery_file_dest_size参数值扩大
1.SQL>create pfile='/tmp/inityjstest.ora' from spfle
修改inityjstest.ora中db_recovery_file_dest_size,增大值。
2.SQL>create spfile from pfile='/tmp/inityjstest.ora'
3.启动数据库
SQL> startup;
ORACLE instance started.
Total System Global Area 1703624704 bytes
Fixed Size 2214016 bytes
Variable Size 1325401984 bytes
Database Buffers 369098752 bytes
Redo Buffers 6909952 bytes
Database mounted.
Database opened.
成功了!
注意:启动成功之后别忘了删除闪回恢复区过期的备份文件!不然一会儿又满了!
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/26775086/viewspace-730142/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26775086/viewspace-730142/