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: 144
Registered: April 2005
Location: Canada
Senior 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: 68625
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: 144
Registered: April 2005
Location: Canada
Senior 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 messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
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
Re: ORA-16038: log 2 sequence# 284 cannot be archived [message #637183 is a reply to message #569891] Tue, 12 May 2015 06:30 Go to previous messageGo to next message
Snyder
Messages: 1
Registered: May 2015
Junior Member
If I try to add disk space whith this this commend
alter system set db_recovery_file_dest_size 5G scope = both;

I received this error:
ORA-03114: no connected to ORACLE
Re: ORA-16038: log 2 sequence# 284 cannot be archived [message #637184 is a reply to message #637183] Tue, 12 May 2015 07:04 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You have to post the complete SQL*Plus session.
You have to check
1/ You are connected to the database
2/ You are connected to the correct database

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Also always post your Oracle version, with 4 decimals.

Previous Topic: Restore of Fresh Backup giving 06026 RMAN error
Next Topic: backup and restore tablespace
Goto Forum:
  


Current Time: Fri Mar 29 10:42:28 CDT 2024