Home » RDBMS Server » Backup & Recovery » ORA-16038: log 2 sequence# 284 cannot be archived (Oracle 11g on linux red hat)
ORA-16038: log 2 sequence# 284 cannot be archived [message #569885] Fri, 02 November 2012 13:49 Go to next message
evoradba
Messages: 75
Registered: April 2005
Location: Canada
Member
ORA-16038: log 2 sequence# 284 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1: /redo02.log'
USER (ospid: 792): terminating the instance due to error 16038
Fri Nov 02 13:14:19 2012
System state dump requested by (instance=1, osid=792), summary=[abnormal instance termination].

Fri Nov 02 13:14:19 2012
ARC3 started with pid=23, OS id=822
Errors in file _ora_792.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 10240 bytes is 100.00% used, and has 0 remaining bytes available.
Re: ORA-16038: log 2 sequence# 284 cannot be archived [message #569886 is a reply to message #569885] Fri, 02 November 2012 13:54 Go to previous messageGo to next message
Michel Cadot
Messages: 58925
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-19815: WARNING: %s of %s bytes is %s%% used, and has %s remaining bytes available.
 *Cause: DB_RECOVERY_FILE_DEST is running out of disk space.
 *Action: One of the following:
          1. Add disk space and increase DB_RECOVERY_FILE_DEST_SIZE.
          2. Backup files to tertiary device using RMAN.
          3. Consider changing RMAN retention policy.
          4. Consider changing RMAN archived log deletion policy.
          5. Delete files from recovery area using RMAN.

Regards
Michel
Re: ORA-16038: log 2 sequence# 284 cannot be archived [message #569890 is a reply to message #569886] Fri, 02 November 2012 15:15 Go to previous messageGo to next message
evoradba
Messages: 75
Registered: April 2005
Location: Canada
Member
I cant start oracle - how can i fix the issue?
Re: ORA-16038: log 2 sequence# 284 cannot be archived [message #569891 is a reply to message #569890] Fri, 02 November 2012 15:17 Go to previous message
BlackSwan
Messages: 22712
Registered: January 2009
Senior Member
ORA-19815: WARNING: %s of %s bytes is %s%% used, and has %s remaining bytes available.
 *Cause: DB_RECOVERY_FILE_DEST is running out of disk space.
 *Action: One of the following:
          1. Add disk space and increase DB_RECOVERY_FILE_DEST_SIZE.
          2. Backup files to tertiary device using RMAN.
          3. Consider changing RMAN retention policy.
          4. Consider changing RMAN archived log deletion policy.
          5. Delete files from recovery area using RMAN.

pick one of 1 - 5 above
Previous Topic: Difference between 2 RMAN commands
Next Topic: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
Goto Forum:
  


Current Time: Thu Aug 28 06:52:59 CDT 2014

Total time taken to generate the page: 0.11209 seconds