ORA-16038 ORA-19809 ORA-00312

ORA-16038 ORA-19809 ORA-00312

Got below error during open database:

ORA-16038: log 4 sequence# 1 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 4 thread 1: '/u01/oradata/cobra/redo01.log'

got below error in alert log at same time during troubleshooting problem:

Errors in file /export/home/oracle/admin/cobra/udump/cobra_ora_9485.trc:
ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 100.00% used, and has 0 remaining bytes available.


************************************************************************
You have following choices to free up space from flash recovery area:
1. Consider changing RMAN RETENTION POLICY. If you are using Data Guard,
   then consider changing RMAN ARCHIVELOG DELETION POLICY.
2. Back up files to tertiary device such as tape using RMAN
   BACKUP RECOVERY AREA command.
3. Add disk space and increase db_recovery_file_dest_size parameter to
   reflect the new space.
4. Delete unnecessary files using RMAN DELETE command. If an operating
   system command was used to delete files, then use RMAN CROSSCHECK and
   DELETE EXPIRED commands.
************************************************************************

ORA-16038 signalled during: alter database open…

Cause:

 

it happens when
 
When the retention policy is changed from default retention policy 1 to recovery window or to a redundancy > 1,
RMAN cannot satisfy the retention policy if there is only one copy of database
and it is recovered to the latest point in time.  In order to satisfy the
retention policy, it keeps all the incrementals and archivelogs since database creation
.

Solution:

1) First check  parameter db_recovery_file_dest_size  and then increase it as per your need:

 

SQL> sho parameter db_recovery_file_dest_size;

SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=3g SCOPE=BOTH;

 

2) unset the parameter .db_recovery_file_dest_size .


SQL> alter system set db_recovery_file_dest=' ' scope=both sid="*";

 

3. Backup and delete archivelogs   

 

RMAN> backup archivelog all delete input;

 

I did following steps to get rid of this error:

 

export ORACLE_SID=cobra

sqlplus / as sysdba

SQL> startup mount
ORACLE instance started.

Total System Global Area 1577058304 bytes
Fixed Size                  2182536 bytes
Variable Size             477868664 bytes
Database Buffers         1090519040 bytes
Redo Buffers                6488064 bytes
Database mounted.

SQL> sho parameter db_recovery_file_dest_size

NAME                                 TYPE        VALUE
———————————— ———– ——————————
db_recovery_file_dest_size           big integer 2G

 

SQL>alter system set db_recovery_file_dest_size=3G scope=both;
System altered.

 

SQL> Recover database until cancel;
Media recovery complete.

 

SQL> Alter database Open Resetlogs;
Database altered.

You can skip to the end and leave a response. Pinging is currently not allowed.

2 Responses to “ORA-16038 ORA-19809 ORA-00312”

  1. Hey just wanted to give you a quick heads up and let you know a few of the images aren’t loading correctly. I’m not sure why but I think its a linking issue. I’ve tried it in two different browsers and both show the same outcome.

  2. Great website. A lot of useful information here. I am sending it to many friends ans also sharing in delicious. And obviously, thanks for your sweat! Thanks!

Leave a Reply