欢迎进入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 nomountcreate controlfile reuse database rman noresetlogs archivelog-- set standby to maximize performancemaxlogfiles 50maxlogmembers 5maxdatafiles 100maxinstances 1maxloghistory 226logfilegroup 1 'd:oracleoradatarmanredo01.log' size 100m,group 2 'd:oracleoradatarmanredo02.log' size 100m,group 3 'd:oracleoradatarmanredo03.log' size 100m-- standby logfiledatafile'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 nomountcreate controlfile set database tti resetlogs --注意这里要set-- set standby to maximize performancemaxlogfiles 50maxlogmembers 5maxdatafiles 100maxinstances 1maxloghistory 226logfilegroup 1 'd:oracleoradatattiredo01.log' size 100m,group 2 'd:oracleoradatattiredo02.log' size 100m,group 3 'd:oracleoradatattiredo03.log' size 100m-- standby logfiledatafile'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]