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博客

oracle重建controlfile脚本

最新文章