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 :: 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: 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.

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: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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: 144
Registered: April 2005
Location: Canada

Senior 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: 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

Report message to a moderator

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

Tue, 12 May 2015 06:30

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

Report message to a moderator

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

Tue, 12 May 2015 07:04

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 20:41:29 CST 2025