- 青島雅思—專家談雅思考試發(fā)展趨勢
- 河南2011上半年自考網(wǎng)上報名入口 點擊進入
- 2011年廣東省護士資格考試報名現(xiàn)場確認時間
- 2011上半年樂山五通橋區(qū)會計從業(yè)考試報名3月10日-4月1
- 哈爾濱香坊區(qū)2011護士資格考試報名現(xiàn)場確認時間
- 2011什邡第一次會計從業(yè)資格考試報名3月1日-4月15日
- 2011什邡第二次會計從業(yè)資格考試報名7月1日-9月16日
- 2011年中山市護士資格考試報名工作的通知
- 長安大學(xué)2011考研成績查詢?nèi)肟?點擊進入
- 西華大學(xué)2011考研成績查詢?nèi)肟?點擊進入
- 中國地質(zhì)大學(xué)(武漢)2011考研成績3月3日查詢
- 中南民族大學(xué)2011考研成績查詢3月4日開始
- 沈陽建筑大學(xué)2011考研成績查詢?nèi)肟?點擊進入
- 沈陽工業(yè)大學(xué)2011考研成績查詢?nèi)肟?點擊進入
Oracle控制件文件修復(fù)
來源:求學(xué)問校網(wǎng) 發(fā)表時間:2012-07-16 瀏覽 26 次
查看文件頭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>
當數(shù)據(jù)文件SCN號大于控制文件scn號,即會發(fā)生控制文件太久的提示,
當數(shù)據(jù)文件SCN號小于控制文件scn號時, 則提示mediea recovery提示
當數(shù)據(jù)文件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.
#
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>
當數(shù)據(jù)文件SCN號大于控制文件scn號,即會發(fā)生控制文件太久的提示,
當數(shù)據(jù)文件SCN號小于控制文件scn號時, 則提示mediea recovery提示
當數(shù)據(jù)文件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.
#
武漢企業(yè)管理培訓(xùn)培訓(xùn)相關(guān)新聞
武漢企業(yè)管理培訓(xùn)相關(guān)課程
- 武漢cad提高培訓(xùn)、武昌cad繪圖培訓(xùn)、武昌學(xué)cad短期速成班培訓(xùn)哪…
- 武漢cad施工制圖培訓(xùn)、武昌cad繪圖培訓(xùn)?武漢學(xué)cad多少錢
- 武漢CAD施工圖、工程圖培訓(xùn),武昌CAD平面圖、立面圖、剖面圖培訓(xùn)…
- 武昌洪山CAD制圖哪家培訓(xùn)好,武漢cad速成培訓(xùn)哪家好、武昌cad設(shè)…
- 武漢機械cad培訓(xùn)、武昌cad短期速成就業(yè)培訓(xùn)、武漢建筑cad培訓(xùn)
- 武昌建筑設(shè)計cad繪圖培訓(xùn)、武漢cad短期提高培訓(xùn)、武漢cad短期速…
- 武漢cad繪圖一對一培訓(xùn)、武昌賽比爾cad培訓(xùn)好、武漢cad建筑培訓(xùn)
- 武漢cad一對一就業(yè)培訓(xùn)、武漢cad培訓(xùn)、武漢cad建筑培訓(xùn)、武漢cad…
- 武昌CAD課程培訓(xùn)內(nèi)容、武漢cad短期速成培訓(xùn)好、武漢室內(nèi)設(shè)計CAD…
- 武昌專業(yè)cad培訓(xùn)小班教學(xué)一對一速成培訓(xùn)、武昌賽比爾cad工程制圖…
- 武漢建筑cad培訓(xùn)、天正cad賽比爾培訓(xùn)好、武漢cad速成班、武漢cad…
- 武漢cad培訓(xùn)哪家培訓(xùn)好、武漢賽比爾CAD培訓(xùn)好、武漢cad速成班
- 武漢cad培訓(xùn)速成全科班、cad課程賽比爾培訓(xùn)好、武昌cad模具產(chǎn)品…
- 武漢cad建筑、工業(yè)制造、工程、園林培訓(xùn)全科班、武昌cad提高班培…