重建oracle的conrfile,重建CONTROLFILE

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE DATABASE "DEMO1" RESETLOGS FORCE LOGGING ARCHIVELOG

--  SET STANDBY TO MAXIMIZE PERFORMANCE

MAXLOGFILES 50

MAXLOGMEMBERS 5

MAXDATAFILES 100

MAXINSTANCES 1

MAXLOGHISTORY 113

LOGFILE

GROUP 1 '/u01/app/oracle/oradata/demo1/redo01.log'  SIZE 100M,

GROUP 2 '/u01/app/oracle/oradata/demo1/redo02.log'  SIZE 100M,

GROUP 3 '/u01/app/oracle/oradata/demo1/redo03.log'  SIZE 100M

-- STANDBY LOGFILE

DATAFILE

'/u01/app/oracle/oradata/demo1/system01.dbf',

'/u01/app/oracle/oradata/demo1/undotbs01.dbf',

'/u01/app/oracle/oradata/demo1/drsys01.dbf',

'/u01/app/oracle/oradata/demo1/example01.dbf',

'/u01/app/oracle/oradata/demo1/indx01.dbf',

'/u01/app/oracle/oradata/demo1/odm01.dbf',

'/u01/app/oracle/oradata/demo1/tools01.dbf',

'/u01/app/oracle/oradata/demo1/users01.dbf',

'/u01/app/oracle/oradata/demo1/xdb01.dbf'

CHARACTER SET ZHS16GBK

;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/8102208/viewspace-490531/，如需转载，请注明出处，否则将追究法律责任。