Troubleshooting ORA-16038 & ORA-19809

 

ORA-16038: log 2 sequence# 816 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1:
‘/u01/app/oracle/oradata/eliteaaa/redo02.log’

SQL>shut abort

SQL>alter system set db_recovery_file_dest_size=4G scope=both

SQL>alter system archive log all to ‘/u01/app/oracle/flash_recovery_area/ORCL/archivelog’;

SQL>startup nomount

SQL>alter database mount

SQL>alter database open

SQL>alter system set log_archive_dest_1=’location=/u01/app/oracle/flash_recovery_area/ORCL/archivelog’ SCOPE=BOTH;

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.