控制文件丢失，重建控制文件

sql>STARTUP NOMOUNT

sql>CREATE CONTROLFILE REUSE DATABASE “UNIGUARD” NORESETLOGS NOARCHIVELOG

MAXLOGFILES 16

MAXLOGMEMBERS 3

MAXDATAFILES 100

MAXINSTANCES 8

MAXLOGHISTORY 4672

LOGFILE

GROUP 1 ‘/product/app/oracle/oradata/uniguard/redo01.log’ SIZE 50M,

GROUP 2 ‘/product/app/oracle/oradata/uniguard/redo02.log’ SIZE 50M,

GROUP 3 ‘/product/app/oracle/oradata/uniguard/redo03.log’ SIZE 50M

— STANDBY LOGFILE

DATAFILE

‘/product/app/oracle/oradata/uniguard/system01.dbf’,

‘/product/app/oracle/oradata/uniguard/undotbs01.dbf’,

‘/product/app/oracle/oradata/uniguard/sysaux01.dbf’,

‘/product/app/oracle/oradata/uniguard/users01.dbf’,

‘/product/app/oracle/oradata/uniguard/info01.dbf’,

‘/index/oradata/uniguard/index01.dbf’,

‘/devdata/oradata/uniguard/index01.dbf’,

‘/devdata/oradata/uniguard/indexdata02.dbf’,

‘/devdata/oradata/uniguard/dev01.dbf’

CHARACTER SET ZHS16GBK

;

sql>RECOVER DATABASE

sql>ALTER DATABASE OPEN;