Skip to main content

ORA-16014

SQL> ALTER DATABASE open
*
ERROR at line 1:
ORA-16014: log 1 sequence# 10484 not archived, no available destinations
ORA-00312: online log 1 thread 1:
'C:\ORACLE\PRODUCT\10.2.0\STAR\REDO01.LOG'





You are getting this message because Oracle can not find enough space on your archive destination to write the archive.Create some space in your archive destination. Also check if the destination you specified EXISTS.



Comments

Popular posts from this blog

Setting ORACLE_SID

The  Oracle System ID  ( S ID ) is used to uniquely identify a particular database on a system How to set ORACLE_SID: Windows: set ORACLE_SID=orcl Unix/ Linux: export ORACLE_SID=orcl SID is case sensitive in Unix / Linux environments. How to check the current ORACLE_SID: Windows: Go to the commnand prompt and type as C:\> set ORACLE_SID (This will show if any ORACLE_SID is already set). C:\> set (To know all the parameters set) Unix/ Linux: echo $ORACLE_SID