登入資料庫時，出現以下訊息
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
執行步驟如下：
C:\Documents and Settings\Administrator>sqlplus "/as sysdba"
SQL*Plus: Release 9.2.0.8.0 - Production on 星期六 2月 22 02:11:32 2014
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
連線至閒置的執行處理.
SQL> select * from v$log;
select * from v$log
*
ERROR 在行 1:
ORA-01034: ORACLE not available
SQL> shutdown immedate;
SP2-0717: 不正確的 SHUTDOWN 選項
SQL> startup mount;
已啟動 ORACLE 執行處理.
Total System Global Area 1033446772 bytes
Fixed Size 456052 bytes
Variable Size 1006632960 bytes
Database Buffers 25165824 bytes
Redo Buffers 1191936 bytes
資料庫已掛載.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- ----------
1 1 4183 104857600 1 YES INACTIVE
630406267 28-1月 -14
2 1 4187 104857600 1 NO CURRENT
630770856 28-1月 -14
3 1 4182 104857600 1 YES INACTIVE
630353234 28-1月 -14
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- ----------
4 1 4184 104857600 1 YES INACTIVE
630459029 28-1月 -14
5 1 4185 104857600 1 YES INACTIVE
630511593 28-1月 -14
6 1 4186 104857600 1 YES ACTIVE
630575534 28-1月 -14
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- ----------
7 1 4181 104857600 1 YES INACTIVE
630300343 28-1月 -14
已選取 7 個資料列.
SQL> recover database until time '2014-02-01 12:12:12';
媒體恢復執行完成.
SQL> alter database open resetlogs;
已更改資料庫.
SQL> shutdown
資料庫關閉.
資料庫已卸載.
已關閉 ORACLE 執行處理.
SQL> startup
已啟動 ORACLE 執行處理.
Total System Global Area 1033446772 bytes
Fixed Size 456052 bytes
Variable Size 1006632960 bytes
Database Buffers 25165824 bytes
Redo Buffers 1191936 bytes
資料庫已掛載.
資料庫已開啟.
SQL>
恢復正常
資料來源：http://blog.sina.com.cn/s/blog_5a2405d101017qe9.html
