oracle重建controlfile脚本

SQL> startup nomount;
ORACLE 例程已经启动。
Total System Global Area 1073741824 bytes
Fixed Size                  1253072 bytes
Variable Size             524288304 bytes
Database Buffers          541065216 bytes
Redo Buffers                7135232 bytes
SQL>CREATE CONTROLFILE REUSE DATABASE "TEST" RESETLOGS  ARCHIVELOG
        MAXLOGFILES 16
        MAXLOGMEMBERS 3
        MAXDATAFILES 100
        MAXINSTANCES 8
        MAXLOGHISTORY 292
    LOGFILE
      GROUP 1 'E:\APP\ADMINISTRATOR\ORADATA\TEST\REDO01.LOG'  SIZE 50M,
      GROUP 2 'E:\APP\ADMINISTRATOR\ORADATA\TEST\REDO02.LOG'  SIZE 50M,
      GROUP 3 'E:\APP\ADMINISTRATOR\ORADATA\TEST\REDO03.LOG'  SIZE 50M
  -- STANDBY LOGFILE
  DATAFILE
    'E:\APP\ADMINISTRATOR\ORADATA\TEST\SYSTEM01.DBF',
    'E:\APP\ADMINISTRATOR\ORADATA\TEST\UNDOTBS01.DBF',
    'E:\APP\ADMINISTRATOR\ORADATA\TEST\SYSAUX01.DBF',
    'E:\APP\ADMINISTRATOR\ORADATA\TEST\USERS01.DBF'
  CHARACTER SET ZHS16GBK

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

转载于:http://blog.itpub.net/29119536/viewspace-1270879/