Oracle控制件文件修复

来源：Oracle认证发布时间：2012-11-12 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.

相关推荐：

Oracle会话数量查询及结束会话

oracle中的Schema简析

Oracle的MERGE未能添加数据

视频学习

我考网版权与免责声明

① 凡本网注明稿件来源为"原创"的所有文字、图片和音视频稿件，版权均属本网所有。任何媒体、网站或个人转载、链接转贴或以其他方式复制发表时必须注明"稿件来源：我考网"，违者本网将依法追究责任；

② 本网部分稿件来源于网络，任何单位或个人认为我考网发布的内容可能涉嫌侵犯其合法权益，应该及时向我考网书面反馈，并提供身份证明、权属证明及详细侵权情况证明，我考网在收到上述法律文件后，将会尽快移除被控侵权内容。