how to re-create controlfile

In  SQL command line:

 

CREATE CONTROLFILE SET DATABASE "KONG" RESETLOGS NOARCHIVELOG

MAXLOGFILES 32

MACLOGMEMBERS 4

MAXDATAFILES 1024

MAXINSTANCES 10

MAXLOGHISTORY 100

 

LOGFILE GROUP 1  '/u01/oracle/oradata/kong/logfile/redo01.log' SIZE 100M,

                  GROUP 2 '/u01/oracle/oradata/kong/logfile/redo02.log'  SIZE 100M,

                  GROUP 3 '/u01/oracle/oradata/kong/logfile/redo03.log'  SIZE 100M

 

DATAFILE

                 '/u01/oracle/oradata/kong/datafile/system01.dbf' size 200M,

                '/u01/oracle/oradata/kong/datafile/sysaux01.dbf' size 250M,

                 .........

 

CHARACTER SET ZHS16GBK;

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

转载于:http://blog.itpub.net/11417069/viewspace-684588/