如何恢复一个只有完好数据文件的数据库?
欢迎进入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]
上一篇: php源码装配时的参数
下一篇: 纯PHP实现定时器任务(Timer)