Hi Experts,
Please help me in determining the above error.
Recently I was told to take one of our EBS environment in archivelog mode. While doing this activity I faced "ORA-16014".
The steps which I followed are listed below:
SQL> alter system set log_archive_dest_1='location=/mnt/DEVarchive/trcdev' scope=spfile;
System altered.
SQL > alter system set log_archive_format='TRCDEV_%s_%t_%r.arc' scope=spfile;
System altered.
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 4275781632 bytes
Fixed Size 2235208 bytes
Variable Size 989856952 bytes
Database Buffers 3271557120 bytes
Redo Buffers 12132352 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /mnt/DEVarchive/trcdev
Oldest online log sequence 9
Next log sequence to archive 11
Current log sequence 11
SQL> alter database open;
Database altered.
SQL> alter system switch logfile;
System altered.
SQL> /
System altered.
SQL> /
Now, the session hangs so I checked my alert log file and found the below details
ARCH: Archival stopped, error occurred. Will continue retrying
ORACLE Instance TRCDEV - Archival Error
ORA-16014: log 2 sequence# 11 not archived, no available destinations
ORA-00312: online log 2 thread 1: '/mnt/DEVdata/trcdev/redo02a.log'
ORA-00312: online log 2 thread 1: '/mnt/DEVdata/trcdev/redo02b.log'
After reading alert log carefully it is evident that it is not able to archive the logs and the archival is hung.
The possible reason could be my Archive destination got filled up, but in my case my archive destination has a free space of around 24G.
Please tell me how to troubleshoot further, a quick response will be highly appreciated.
-Thanks