< 518:ORA-00308: cannot open archived log '/arch_log1/CDWQ/CDWQ_1_907600_574942170.dbf'
< 519:ORA-27041: unable to open fileOracle Alert Log Is Reporting Archive Log Status Is Not Available For Logs That Have Long Been Backed Up [ID 1161573.1]
Per unpublished bug 9207154: GET ORA-00308 ORA-27037 ATTEMPTING TO ACCESS VERY OLD ARCHIVE LOG.
Prior to 11g certain errors that would not normally be reported such as
"ORA-8103: object no longer exists" would result in redo from the all
the online redo logs being scanned. From 11.1 onwards Oracle now
potentially scans the past 12 hours of redo, and that can mean looking
at archived logs too.
The fact that in 11.1 the diagnostic redo
scans/dumps potentially search for the past 12 hours of redo and if the
redo dump tries to access an archived log that has been deleted then
ORA-27037 and ORA-308 are raised, and caught and handled internally, but
in the alert log, this is effectively publicizing the internally
handled exception conditions, and could be confusing to the DBA viewing
the alert log.
This process was changed via patch for Bug 8825048: 11.1 - DUMPING
DIAGNOSTIC INFO FOR ORA-8103 RESULTS IN ORA-308 which is fixed in:
* 188.8.131.52.3 (Patch Set Update)
* 184.108.40.206 (Base Release)
A workaround would be to not remove archive logs from the system unless they are older than 12 hours.
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/11976525/viewspace-703583/，如需转载，请注明出处，否则将追究法律责任。