恢复控制文件(无備份、無歸檔、全損壞)試驗

1、shutdown immediate
2. 删除控制文件（模擬）
3.创建控制文件
CREATE CONTROLFILE REUSE DATABASE "orcl" NORESETLOGS NOARCHIVELOG
MAXLOGFILES 32
MAXLOGMEMBERS 2
MAXDATAFILES 254
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 1 'D:oracleproduct10.2.0oradataorclREDO01.LOG' SIZE 50M,
GROUP 2 'D:oracleproduct10.2.0oradataorclREDO02.LOG' SIZE 50M,
GROUP 3 'D:oracleproduct10.2.0oradataorclREDO03.LOG' SIZE 50M
DATAFILE
'D:oracleproduct10.2.0oradataorclBLOCK_TEST.DBF',
'D:oracleproduct10.2.0oradataorclSYSAUX01.DBF',
'D:ORACLEPRODUCT10.2.0ORADATAORCLSYSTEM01.DBF',
'D:oracleproduct10.2.0oradataorclUNDOTBS01.DBF',
'D:oracleproduct10.2.0oradataorclUSERS01.DBF',
'D:oracleproduct10.2.0oradataorclCH1.ORA.ORA',
'D:oracleproduct10.2.0oradataorclCH.ORA',
'D:oracleproduct10.2.0oradataorclCONFIG.ORA',
'D:oracleproduct10.2.0oradataorclGDSUPFLEX.ORA',
'D:oracleproduct10.2.0oradataorclRMAN_SPACE01.ORA',
'D:oracleproduct10.2.0oradataorclTEST_INDEX.ORA'
CHARACTER SET ZHS16GBK;

4、recover database using backup controlfile until cancel;
输入重做日志路徑，進行介質恢復。不然會報systemp.bdf 需要介質恢復

5、 alter database open resetlogs;

注：REDO01.LOG 大小要和實際大小一樣。

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/12591949/viewspace-1033027/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12591949/viewspace-1033027/