Oracle 控制件文件修复

查看文件头SCN号：
SQL> select file#, checkpoint_change# from v$datafile_header;

     FILE# CHECKPOINT_CHANGE#
---------- ------------------
 1     18120070
 2     18120070
 3     18120070
 4     18120070
 5     18120070
 6     18120070
 7     18120070
 8     18120070
 9     18120070
 10     18120070
 11     18121207

     FILE# CHECKPOINT_CHANGE#
---------- ------------------
 12     18121196

12 rows selected.

查看控制文件SCN号：
SQL> select file#, checkpoint_change# from v$datafile;

     FILE# CHECKPOINT_CHANGE#
---------- ------------------
 1     18120070
 2     18120070
 3     18120070
 4     18120070
 5     18120070
 6     18120070
 7     18120070
 8     18120070
 9     18120070
 10     18120070
 11     18121207

     FILE# CHECKPOINT_CHANGE#
---------- ------------------
 12     18121196

12 rows selected.

SQL>

当数据文件SCN号大于控制文件scn号，即会发生控制文件太久的提示，

当数据文件SCN号小于控制文件scn号时， 则提示mediea recovery提示

当数据文件sCN号等于控制文件scn号，正常启动实例

 

SQL> alter database backup controlfile to trace as '/u01/Oracle/admin/ora9i/udump/c.trc';

Database altered.

SQL>

/u01/Oracle/oradata/ora9i
[oracle@test ora9i]$ rm control0*
[oracle@test ora9i]$

SQL> shutdown immediate;
ORA-00210: cannot open the specified controlfile
ORA-00202: controlfile: '/u01/Oracle/oradata/ora9i/control01.ctl'
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
SQL> shutdown abort;
ORACLE instance shut down.
SQL>

修改备份c.trc文件使用第一个sql
STARTUP NOMOUNT
CREATE CONTROLFILE REUSE DATABASE "ORA9I" NORESETLOGS  ARCHIVELOG
    MAXLOGFILES 50
    MAXLOGMEMBERS 5
    MAXDATAFILES 100
    MAXINSTANCES 1
    MAXLOGHISTORY 226
LOGFILE
  GROUP 1 '/u01/Oracle/oradata/ora9i/redo01.log'  SIZE 100M,
  GROUP 2 '/u01/Oracle/oradata/ora9i/redo02.log'  SIZE 100M,
  GROUP 3 '/u01/Oracle/oradata/ora9i/redo03.log'  SIZE 100M

 

DATAFILE
  '/u01/Oracle/oradata/ora9i/system01.dbf',
  '/u01/Oracle/oradata/ora9i/undotbs01.dbf',
  '/u01/Oracle/oradata/ora9i/cwmlite01.dbf',
  '/u01/Oracle/oradata/ora9i/drsys01.dbf',
  '/u01/Oracle/oradata/ora9i/example01.dbf',
  '/u01/Oracle/oradata/ora9i/indx01.dbf',
  '/u01/Oracle/oradata/ora9i/odm01.dbf',
  '/u01/Oracle/oradata/ora9i/tools01.dbf',
  '/u01/Oracle/oradata/ora9i/users01.dbf',
  '/u01/Oracle/oradata/ora9i/xdb01.dbf',
  '/u01/Oracle/oradata/ora9i/app2.dbf',
  '/u01/Oracle/oradata/ora9i/app1_01.dbf'
CHARACTER SET ZHS16GBK
;

# Configure RMAN configuration record 1
VARIABLE RECNO NUMBER;
EXECUTE :RECNO := SYS.DBMS_BACKUP_RESTORE.SETCONFIG('CONTROLFILE AUTOBACKUP','ON');
# Recovery is required if any of the datafiles are restored backups,
# or if the last shutdown was not normal or immediate.
RECOVER DATABASE

# All logs need archiving and a log switch is needed.
ALTER SYSTEM ARCHIVE LOG ALL;

# Database can now be opened normally.
ALTER DATABASE OPEN;

# Commands to add tempfiles to temporary tablespaces.
# Online tempfiles have complete space information.
# Other tempfiles may require adjustment.
ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/Oracle/oradata/ora9i/temp01.dbf' REUSE;
# End of tempfile additions.