- 相關推薦
Oracle認證：Oracle控制件文件修復
查看文件頭SCN號：
SQL> select file#, checkpoint_change# from v;
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;
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控制件文件修復】相關文章：
Oracle認證：ORACLE綁定變量BINDPEEKING03-08
Oracle認證作用03-19
Oracle認證簡介11-30
Oracle最新認證03-09
Oracle認證途徑03-20
Oracle認證：Oracle內存結構研究-PGA篇03-08
Oracle認證職業前景03-19
Oracle認證考試技巧03-19