其實就是停止數據據時，千萬別用 shutdown abort; 這樣的命令。
啥也不多說了，看日志：
SQL> startup mount
ORACLE instance started.
Total System Global Area 608174080 bytes
Fixed Size 1220820 bytes
Variable Size 176164652 bytes
Database Buffers 423624704 bytes
Redo Buffers 7163904 bytes
Database mounted.
SQL> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 608174080 bytes
Fixed Size 1220820 bytes
Variable Size 176164652 bytes
Database Buffers 423624704 bytes
Redo Buffers 7163904 bytes
Database mounted.
Database opened.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 608174080 bytes
Fixed Size 1220820 bytes
Variable Size 176164652 bytes
Database Buffers 423624704 bytes
Redo Buffers 7163904 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 14103
Next log sequence to archive 14105
Current log sequence 14105
SQL> alter database open;
Database altered.
SQL>
posted on 2009-08-06 00:09
Robin's Programming World 閱讀(1648)
評論(0) 編輯 收藏 所屬分類:
DB