如何恢复一个只有完好数据文件的数据库？[2]

文章作者 100test 发表时间 2007:03:14 13:59:16
来源 100Test.Com百考试题网

5、开始重建控制文件

　　1）在类似的数据库(比如数据库名称"rman")上执行：
　　alter database backup controlfile to trace.
　　然后在D:oracleadminrmanudump下找到最新的trace文件，以文本方式打开，找到类似下面的一段话:

Code highlighting produced by Actipro CodeHighlighter (freeware)

http://www.CodeHighlighter.com/

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE DATABASE "rman" NORESETLOGS ARCHIVELOG

-- SET STANDBY TO MAXIMIZE PERFORMANCE

MAXLOGFILES 50

MAXLOGMEMBERS 5

MAXDATAFILES 100

MAXINSTANCES 1

MAXLOGHISTORY 226

LOGFILE

GROUP 1 D:ORACLEORADATARMANREDO01.LOG SIZE 100M,

GROUP 2 D:ORACLEORADATARMANREDO02.LOG SIZE 100M,

GROUP 3 D:ORACLEORADATARMANREDO03.LOG SIZE 100M

-- STANDBY LOGFILE

DATAFILE

D:ORACLEORADATARMANSYSTEM01.DBF,

D:ORACLEORADATARMANUNDOTBS01.DBF,

D:ORACLEORADATARMANCWMLITE01.DBF,

D:ORACLEORADATARMANDRSYS01.DBF,

D:ORACLEORADATARMANEXAMPLE01.DBF,

D:ORACLEORADATARMANINDX01.DBF,

D:ORACLEORADATARMANODM01.DBF,

D:ORACLEORADATARMANTOOLS01.DBF,

D:ORACLEORADATARMANUSERS01.DBF,

D:ORACLEORADATARMANXDB01.DBF,

D:ORACLEORADATARMANTEST.ORA

CHARACTER SET WE8MSWIN1252

　　2）将上面这段话修改为如下：

Code highlighting produced by Actipro CodeHighlighter (freeware)

http://www.CodeHighlighter.com/

STARTUP NOMOUNT

CREATE CONTROLFILE set DATABASE "tti" RESETLOGS --注意这里要"set"

-- SET STANDBY TO MAXIMIZE PERFORMANCE

MAXLOGFILES 50

MAXLOGMEMBERS 5

MAXDATAFILES 100

MAXINSTANCES 1

MAXLOGHISTORY 226

LOGFILE

GROUP 1 D:ORACLEORADATAttiREDO01.LOG SIZE 100M,

GROUP 2 D:ORACLEORADATAttiREDO02.LOG SIZE 100M,

GROUP 3 D:ORACLEORADATAttiREDO03.LOG SIZE 100M

-- STANDBY LOGFILE

DATAFILE

D:ORACLEORADATAttiSYSTEM01.DBF,

D:ORACLEORADATAttiUNDOTBS01.DBF,

D:ORACLEORADATAttiCWMLITE01.DBF,

D:ORACLEORADATAttiDRSYS01.DBF,

D:ORACLEORADATAttiEXAMPLE01.DBF,

D:ORACLEORADATAttiINDX01.DBF,

D:ORACLEORADATAttiODM01.DBF,

D:ORACLEORADATAttiTOOLS01.DBF,

D:ORACLEORADATAttiUSERS01.DBF,

D:ORACLEORADATAttiXDB01.DBF,

D:ORACLEORADATAttiTEST.ORA

CHARACTER SET WE8MSWIN1252