ORA-16038,ORA-19809,ORA-00312

SQL> alter database open;
alter database open
*
第 1 行出现错误:
ORA-16038: 日志 1 序列号 74 无法归档
ORA-19809: 超出了恢复文件数的限制
ORA-00312: 联机日志 1 线程 1:
'C:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/REDO01.LOG'

解决办法;

$rman
RMAN>connect target /
RMAN> crosscheck archivelog all;
RMAN> delete expired archivelog all;

RMAN>exit

 

There are a couple of possible options.
1) Increase the parameter db_recovery_file_dest_size
2) Stop using the db_recovery_file_dest by unsetting the parameter. (This assumes you never really wanted to use this option)
3) Remove the Entries from the rman repository/Controlfile

 The removal is desribed in the RMAN documentation but this is a quick and dirty way if you don't have an rman repository - but could endanger your ability to recover - so be careful.

a) delete unwanted archive log files from disk (rm, del commands)
b) connect to rman ( RMAN> connect target / )
c) RMAN> crosscheck archivelog all; - marks the controlfile that the archives have been deleted d) RMAN> delete expired archivelog all; - deletes the log entries identified above