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