DB Version : 10gR2, 11GR2
OS Version: Solaris 5.10, AIX 6.1
During archiving enabling for a 2-Node RAC Production DB, I made a mistake while specifying LOG_ARCHIVE_DEST (a typo).
After i brought the DB up (open) after enabling archiving, i tested switching the log using
SQL> alter system switch logfile;
System altered
and didn't get any error.
Later i realised , the archiving isn't working. But i am wondering , why i didn't get any error for
SQL> alter system switch logfile;
Errors might have been logged in alert log. Since , I didn't get any error from sqlplus for the above command, i thought everything was fine.
But the following command raised error.
SQL> ALTER SYSTEM ARCHIVE LOG CURRENT;
ALTER SYSTEM ARCHIVE LOG CURRENT
*
ERROR at line 1:
ORA-16038: log 4 sequence# 127 cannot be archived
ORA-00254: error in archive control string ''
ORA-00312: online log 4 thread 2: '+LTMPROD_DATA/LTMPROD/redo04.log'
ORA-15173: entry 'ltmprod_arch' does not exist in directory '/'
What command should i be using to verify that the Archive enabling was successful?