SQL> startup mount
ORACLE instance started.
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
SQL> alter database open
2 ;
alter database open
*
ERROR at line 1:
ORA-16038: log 3 sequence# 46 cannot be archived
ORA-19504: failed to create file “”
ORA-00312: online log 3 thread 1: ‘F:\ORACLE\ORA92DATA\ORA92\REDO03.LOG’
Cause
~~~~~~~
Free space problem at archive destination.
Fix
~~~~
Check the free space at the archive destination and after making sufficient space at archive destination, re-try to open the database and it will open and no need to issue any other command like clear log, switch log.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7351078/viewspace-667422/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/7351078/viewspace-667422/