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/';
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/'
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>
修改備份文件使用第一個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/' SIZE 100M,
GROUP 2 '/u01/Oracle/oradata/ora9i/' SIZE 100M,
GROUP 3 '/u01/Oracle/oradata/ora9i/' SIZE 100M
DATAFILE
'/u01/Oracle/oradata/ora9i/',
'/u01/Oracle/oradata/ora9i/',
'/u01/Oracle/oradata/ora9i/',
'/u01/Oracle/oradata/ora9i/',
'/u01/Oracle/oradata/ora9i/',
'/u01/Oracle/oradata/ora9i/',
'/u01/Oracle/oradata/ora9i/',
'/u01/Oracle/oradata/ora9i/',
'/u01/Oracle/oradata/ora9i/',
'/u01/Oracle/oradata/ora9i/',
'/u01/Oracle/oradata/ora9i/',
'/u01/Oracle/oradata/ora9i/app1_'
CHARACTER SET ZHS16GBK
;
# Configure RMAN configuration record 1
VARIABLE RECNO NUMBER;
EXECUTE :RECNO := _BACKUP_ONFIG('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/' REUSE;
# End of tempfile additions.
#
相關文章
-
Oracle認證:OracleTRUNC函數詳解
C 函數Oracle TRUNC函數可以截取數字和日期類型: C截取數字TRUNC(number)函數返回n1截取到n2位小數。如果省略n2時,則n1截取到0位置(即截取所有小數位)。如果n2爲負數時,表示截取小數點左邊的n2位,被截取部分記爲0 -
Oracle認證:Oracle內存結構研究-PGA篇
一、概述SGA,PGA,UGA都是Oracle管理的內存區。SGA(System Global Area),即系統全局區,Oracle中最重要的內存區。PGA(Process Global Area),即程序全局區,一個進程的專用的內存區。UGA(User Global Area),即用戶全局區,與 -
Oracle認證:Oracle避免全表掃描方式
不知道各位同學提起Oracle認證考試來還頭疼嗎?還覺得沒有什麼複習頭緒嗎?下面小編就爲大家整理了一些Oracle認證複習備考資料。希望大家可以從中學習答題方法,讓自己的得到進步!1.對返回的行無任何限定條件,即沒有where -
Oracle認證:Win7下Oracle11g完全刪除
在不斷注重大學聯考能力提高的同時,尤其是Oracle認證備考的後階段,我們選擇的是求準求穩求規範。此複習輔導不等於題海戰術,而是要積累實戰經驗,解決掉一些考場失誤等問題。 1.關閉oracle所有的服務windows的.服務管理器(W -
Oracle認證:ORACLE綁定變量BINDPEEKING
ORACLE 在9i之後引入了bind peeking,通過bind peeking,oracle可以在硬解析的時候窺探綁定變量的值,並根據當前綁定變量的值生成執行計劃。在oracle 9i之前的版本中,oracle僅僅通過統計信息來生成執行計劃。下面看一下不 -
Oracle認證:Freebufferwaits等待事件總結
Free buffer waits1.簡述:當數據庫要在buffer cache中尋找空閒空間來放置數據,但發現空間不足時,就會產生這個等待;2.詳述:a)在用戶請求塊的DBA上應用HASH函數,獲得適當的hash bucket;b)檢索bucket對應的chain,確認塊頭是 -
Oracle認證:oracle中小寫轉換成大寫方法
一表堂堂【意思解釋】1.形容儀表堂皇。 -
高中生優秀英語作文:Have a break away from electronics
回顧在中醫科的實習工作,感觸很深,收穫頗豐。談談一些心得體會。本文是中醫科的實習心得體會,歡迎閱讀。中醫科的實習心得體會一:在中醫科的實習即將結束,在這一個多月的實習期間,我遵紀守法,遵守醫院及醫院各科室的各項規章 -
英語作文:大學生村官 College Graduates Work as Village Offic
Inrecent years, being a village official has become the first choice of manycollege graduates. To this phenomenon, different people have different opinionson it.近年來,村官已成爲許多大學畢業生就業的首 -
Choice of large enterprises or small英語四級作文
just as there are distinct differences between being a small fish is a big pond and a big fish in a small pond, so it is with working as a subordinate in a large enterprise and presiding in a small fi