OraFAQ Forum: Backup & Recovery » ORA-16038: log 2 sequence# 284 cannot be archived

Home » RDBMS Server » Backup & Recovery » ORA-16038: log 2 sequence# 284 cannot be archived (Oracle 11g on linux red hat)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

ORA-16038: log 2 sequence# 284 cannot be archived [message #569885]

Fri, 02 November 2012 13:49

evoradba
Messages: 61
Registered: April 2005

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.

Report message to a moderator

Re: ORA-16038: log 2 sequence# 284 cannot be archived [message #569886 is a reply to message #569885]

Fri, 02 November 2012 13:54

Michel Cadot
Messages: 54240
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

Report message to a moderator

Re: ORA-16038: log 2 sequence# 284 cannot be archived [message #569890 is a reply to message #569886]

Fri, 02 November 2012 15:15

evoradba
Messages: 61
Registered: April 2005

Member

I cant start oracle - how can i fix the issue?

Report message to a moderator

Re: ORA-16038: log 2 sequence# 284 cannot be archived [message #569891 is a reply to message #569890]

Fri, 02 November 2012 15:17

BlackSwan
Messages: 20109
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

Report message to a moderator

Previous Topic:	Difference between 2 RMAN commands
Next Topic:	ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 25 04:42:51 CDT 2013

Total time taken to generate the page: 0.06572 seconds