小弟在测试重建控制文件后,重新启动后出现
ORA-01991: ???????'D
racleora92DATABASEPWDoracledb1.ORA'
用orapwd可以搞定,但是为什么重建控制文件,就出现这个问题,有什么方法可以避免么?
CREATE CONTROLFILE REUSE DATABASE "TOS1" NORESETLOGSARCHIVELOG
--SET STANDBY TO MAXIMIZE PERFORMANCE
MAXLOGFILES 50
MAXLOGMEMBERS 5
MAXDATAFILES 100
MAXINSTANCES 1
MAXLOGHISTORY 226
LOGFILE
GROUP 1 'D:ORACLEORADATATOS1REDO01.LOG'SIZE 100M,
GROUP 2 'D:ORACLEORADATATOS1REDO02.LOG'SIZE 100M,
GROUP 3 'D:ORACLEORADATATOS1REDO03.LOG'SIZE 100M
-- STANDBY LOGFILE
DATAFILE
'D:ORACLEORADATATOS1SYSTEM01.DBF',
'D:ORACLEORADATATOS1UNDOTBS01.DBF',
'D:ORACLEORADATATOS1CWMLITE01.DBF',
'D:ORACLEORADATATOS1DRSYS01.DBF',
'D:ORACLEORADATATOS1EXAMPLE01.DBF',
'D:ORACLEORADATATOS1INDX01.DBF',
'D:ORACLEORADATATOS1ODM01.DBF',
'D:ORACLEORADATATOS1TOOLS01.DBF',
'D:ORACLEORADATATOS1USERS01.DBF',
'D:ORACLEORADATATOS1XDB01.DBF',
'D:ORACLEORADATATOS1TEST1.DBF'
CHARACTER SET ZHS16GBK;
|