很多時候
而以下修改純屬無聊:
[oracle@jumper oracle]$ sqlplus
SQL*Plus: Release
Copyright (c)
Connected to:
Oracle
With the Partitioning option
JServer Release
SQL> col a for
SQL> select CHECKPOINT_CHANGE# a from v$datafile;
A
SQL> oradebug setmypid
Statement processed
SQL> oradebug DUMPvar SGA kcsgscn_
kcslf kcsgscn_ [
SQL> oradebug poke
BEFORE: [
AFTER: [
SQL> select dbms_flashback
A
SQL> oradebug DUMPvar SGA kcsgscn_
kcslf kcsgscn_ [
SQL>
SQL> alter system checkpoint;
System altered
SQL> select CHECKPOINT_CHANGE# a from v$datafile;
A
Oracle會檢測到異常:
SQL> shutdown immediate;
ORA
重新啟動會出現錯誤
SQL> shutdown abort;
ORACLE instance shut down
SQL> startup
ORACLE instance started
Total System Global Area
Fixed Size
Variable Size
Database Buffers
Redo Buffers
Database mounted
ORA
SQL> recover database using backup controlfile until cancel;
ORA
ORA
ORA
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA
ORA
ORA
ORA
SQL> alter database open resetlogs;
Database altered
此時數據庫可以正常打開
From:http://tw.wingwit.com/Article/program/Oracle/201311/17746.html