Oracle实战：备份和恢复游戏

核心提示： SQL> startupORACLE instance started.Total System Global Area289406976 bytesFixed Size1290184 bytesVariable Size 104857656 bytesDatabase Buffer

SQL> startup

ORACLE instance started.

Total System Global Area　289406976 bytes

Fixed Size　　　　　　　　　1290184 bytes

Variable Size　　　　　　 104857656 bytes

Database Buffers　　　　　176160768 bytes

Redo Buffers　　　　　　　　7098368 bytes

Database mounted.

Database opened.

SQL> col name for a52

SQL> select name from v$controlfile;

NAME

----------------------------------------------------

D:ORACLEPRODUCT10.2.0ORADATADB10CONTROL01.CTL

D:ORACLEPRODUCT10.2.0ORADATADB10CONTROL02.CTL

F:ORACLECONTROL03.CTL

现在已经准备好断开闪存盘的连接，没有直接的警告（用户界面没有任何提示信息，直到尝试一个操作时），实例崩溃了。

SQL> select name from v$controlfile;

select name from v$controlfile

*

ERROR at line 1:

ORA-03113: end-of-file on communication channel

下面显示了警告日志（这只是其中一部分）：

ThuMar0612:41:152008
Errorsinfiled:oracleproduct10.2.0admindb10bdumpdb10_ckpt_2756.trc:
ORA-00206:errorinwriting(block3,#blocks1)ofcontrolfile
ORA-00202:controlfile:’F:ORACLECONTROL03.CTL’
ORA-27072:FileI/Oerror
OSD-04008:WriteFile()failure,unabletowritetofile
O/S-Error:(OS1006)Thevolumeforafilehasbeenexternallyalteredsothattheopenedfileisnolongervalid.
…somemoremessages…
ThuMar0612:41:292008
InstanceterminatedbyCKPT,pid=2756