oracle 11.1.0.7版本也會(huì)出現(xiàn)access$表失去導(dǎo)致數(shù)據(jù)庫(kù)無法打開_Oracle圖文說明教程

　　下面我們來看看oracle 11.1.0.7版本也會(huì)出現(xiàn)access$表丟失導(dǎo)致數(shù)據(jù)庫(kù)無法啟動(dòng),有需要了解的朋友可以進(jìn)入看看吧.

　　有網(wǎng)友咨詢數(shù)據(jù)庫(kù)啟動(dòng)報(bào)ora-01092：ORACLE 實(shí)例終止。強(qiáng)制斷開連接，請(qǐng)求幫忙處理

　　數(shù)據(jù)庫(kù)版本

　　Trace file d:appadministratordiagrdbmsorclorcltraceorcl_ora_5648.trc

　　Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production

　　With the Partitioning, OLAP, Data Mining and Real Application Testing options

　　Windows NT Version V6.1 Service Pack 1

　　CPU : 1 - type 8664, 1 Physical Cores

　　Process Affinity : 0x0000000000000000

　　Memory (Avail/Total): Ph:7605M/10239M, Ph+PgF:11979M/20477M

　　Instance name: orcl

　　Redo thread mounted by this instance: 1

　　Oracle process number: 18

　　Windows thread id: 5648, image: ORACLE.EXE (SHAD)

　　open數(shù)據(jù)庫(kù)報(bào)ORA-01092: ORACLE 實(shí)例終止。強(qiáng)制斷開連接

　　SQL> alter database open;

　　alter database open

　　*

　　第 1 行出現(xiàn)錯(cuò)誤:

　　ORA-01092: ORACLE 實(shí)例終止。強(qiáng)制斷開連接

　　alert日志

　　Thread 1 opened at log sequence 1008

　　Current log# 3 seq# 1008 mem# 0: D:APPADMINISTRATORORADATAORCLREDO03.LOG

　　Successful open of redo thread 1

　　MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

　　SMON: enabling cache recovery

　　Errors in file d:appadministratordiagrdbmsorclorcltraceorcl_ora_3964.trc:

　　ORA-00704: 引導(dǎo)程序進(jìn)程失敗

　　ORA-00604: 遞歸 SQL 級(jí)別 1 出現(xiàn)錯(cuò)誤

　　ORA-00942: 表或視圖不存在

　　Error 704 happened during db open, shutting down database

　　USER (ospid: 3964): terminating the instance due to error 704

　　Instance terminated by USER, pid = 3964

　　ORA-1092 signalled during: ALTER DATABASE OPEN...

　　ORA-1092 : opiodr aborting process unknown ospid (3384_3964)

　　做10046分析日志

　　PARSE ERROR #1:len=56 dep=1 uid=0 oct=3 lid=0 tim=1796038335 err=942

　　select order#,columns,types from access$ where d_obj#=:1

　　*** 2015-01-27 21:24:50.794

　　----- Error Stack Dump -----

　　ORA-00604: 遞歸 SQL 級(jí)別 1 出現(xiàn)錯(cuò)誤

　　ORA-00942: 表或視圖不存在

　　通過這里可以知道數(shù)據(jù)庫(kù)在啟動(dòng)的過程中由于無法訪問access$表從而出現(xiàn)ORA-00942錯(cuò)誤,又是由于該sql是數(shù)據(jù)庫(kù)內(nèi)部調(diào)用因?yàn)槌霈F(xiàn)ORA-00604錯(cuò)誤.

　　出現(xiàn)該錯(cuò)誤的原因是由于:BUG:12733463 – ORA-704, ORA-604 AND ORA-942 ON TABLE ACCESS$ DURING STARTUP

　　官方提供方法

　　1. Shutdown (abort) the instance and clean up any OS structures used by the instance.

　　Eg: Ensure there is no shared memory, semaphores etc.. left lying around

　　2. Retry the startup.

　　3. If the error persists try and recover the database or recover from a backup.

　　惜分飛處理方法

　　startup upgrade

　　create table access$

　　( d_obj# number not null,

　　order# number not null,

　　columns raw(126),

　　types number not null)

　　storage (initial 10k next 100k maxextents unlimited pctincrease 0)

　　/

　　create index i_access1 on

　　access$(d_obj#, order#)

　　storage (initial 10k next 100k maxextents unlimited pctincrease 0)

　　/