SQL> startup mount force;
ORACLE instance started.
Total System Global Area 2097152000 bytes
Fixed Size 1268460 bytes
Variable Size 704644372 bytes
Database Buffers 1375731712 bytes
Redo Buffers 15507456 bytes
Database mounted.
SQL> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
SQL> alter database open;
Database altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 2097152000 bytes
Fixed Size 1268460 bytes
Variable Size 704644372 bytes
Database Buffers 1375731712 bytes
Redo Buffers 15507456 bytes
Database mounted.
SQL>
SQL>
SQL>
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
本文出自 “小 、西” 博客