ORA-00600: internal error code, arguments: [4819], [], [], [], [], [], [], [] ORA-00308: cannot open archived log '/home/oracle/archive/arc_ARJU_001.arc' ORA-27037: unable to obtain file status This problem started to happen because recently database has been switched into NOARCHIVELOG mode from ARCHIVELOG mode. Cause of the Problem The problem arises because the LOG_ARCHIVE_DEST_n parameter is still set to point to an archive log destination and the default value for the LOG_ARCHIVE_DEST_STATE_n parameter is 'ENABLE'. Based on these two settings database still attempts to open the required archive log file during transaction recovery. Solution of the Problem To resolve this problem, mark the destination as deferred and null out the archive destination, That is 1) Login as sysdba. SQL> connect / as sysdba 2) Set the archive_dest_state_1 to defer. SQL> alter system set log_archive_dest_state_1 = defer scope=both; |
DBA's Home Page - A website for Oracle, Greenplum and PostgreSQL DBA's > Database Monitoring and Troubleshooting >