control 文件重建

重建controlfile:

alter database backup controlfile to trace;

oradebug setmypid
oradebug tracefile_name 可以得到trace 的name

打开trace 文件：

修改： reuse ---> set,   nosetlogs ---> setlogs

CREATE CONTROLFILE set DATABASE "SHENG" RESETLOGS  ARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 '/u02/sheng/REDO01.LOG'  SIZE 50M,
  GROUP 2 '/u02/sheng/REDO02.LOG'  SIZE 50M,
  GROUP 3 '/u02/sheng/REDO03.LOG'  SIZE 50M
-- STANDBY LOGFILE
DATAFILE
  '/u02/sheng/SYSTEM01.DBF',
  '/u02/sheng/undotbs02.dbf',
  '/u02/sheng/SYSAUX01.DBF',
  '/u02/sheng/USERS01.DBF',
  '/u02/sheng/tbsdbs01.dbf'
CHARACTER SET ZHS16GBK
;

如果原来的路径下有control 文件，remove 就ok.