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

欢迎进入Oracle社区论坛，与200万技术人员互动交流 >>进入 5、开始重建控制文件 1）在类似的数据库(比如数据库名称"rman")上执行： alter database backup controlfile to trace; 然后在D:oracleadminrmanudump下找到最新的trace文件，以文本方式打开，找到

欢迎进入Oracle社区论坛，与200万技术人员互动交流 >>进入

　　5、开始重建控制文件

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

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）将上面这段话修改为如下：

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

[1] [2] [3]