嘗試無引數啟動資料庫時報錯ORA-304錯誤

yangtingkun發表於2008-09-15

在一個已經配置了RAC + ASM環境的資料庫中,嘗試利用RMAN的無引數啟動,出現了ORA-304錯誤。

 

 

錯誤資訊如下:

bash-3.00$ rman target /

Recovery Manager: Release 11.1.0.6.0 - Production on Mon Sep 8 14:57:11 2008

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database (not started)

RMAN> startup nomount

startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/data/oracle/product/11.1/database/dbs/initrac11g1.ora'

starting Oracle instance without parameter file for retrieval of spfile
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 09/08/2008 14:57:52
RMAN-04014: startup failed: ORA-00304: requested INSTANCE_NUMBER is busy

RMAN> exit;


Recovery Manager complete.

懷疑是當前執行的另外一個資料庫的RAC例項導致了Oracle的啟動錯誤,於是嘗試關閉另外一個資料庫的例項:

bash-3.00$ sqlplus "sys/test@ractest1 as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on Mon Sep 8 15:04:37 2008

Copyright (c) 1982, 2007, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
bash-3.00$ rman target /

Recovery Manager: Release 11.1.0.6.0 - Production on Mon Sep 8 15:07:51 2008

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database (not started)

RMAN> startup nomount

startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/data/oracle/product/11.1/database/dbs/initrac11g1.ora'

starting Oracle instance without parameter file for retrieval of spfile
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 09/08/2008 15:08:13
RMAN-04014: startup failed: ORA-00304: requested INSTANCE_NUMBER is busy

RMAN> exit


Recovery Manager complete.

關閉資料庫例項後,問題依舊。莫非ASM例項對當前的啟動也有影響。不過由於下面的操作會嘗試使用ASM例項上的內容,因此不能關閉ASM

嘗試編輯一個最簡單的引數問題,看能否啟動例項:

bash-3.00$ vi initrac11g1.ora
"initrac11g1.ora" [New file]
db_name=rac11gs

下面把剛才關閉的例項重新啟動,看這個例項是否會產生影響:

bash-3.00$ bash
bash-3.00$ export ORACLE_SID=ractest1
bash-3.00$ sqlplus "/ as sysdba"

SQL*Plus: Release 11.1.0.6.0 - Production on Mon Sep 8 15:16:07 2008

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1603887104 bytes
Fixed Size                  2095208 bytes
Variable Size             523618200 bytes
Database Buffers         1073741824 bytes
Redo Buffers                4431872 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
bash-3.00$ exit
exit
bash-3.00$ rman target/

Recovery Manager: Release 11.1.0.6.0 - Production on Mon Sep 8 15:16:50 2008

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database (not started)

RMAN> startup nomount pfile=initrac11g1.ora

Oracle instance started

Total System Global Area     217219072 bytes

Fixed Size                     2093360 bytes
Variable Size                160362192 bytes
Database Buffers              50331648 bytes
Redo Buffers                   4431872 bytes

檢查了一下metalink,也沒有發現和當前問題比較吻合的情況,不過懷疑問題和Bug No. 5557910比較類似,可能是Oraclebug造成的。

 

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/4227/viewspace-448455/,如需轉載,請註明出處,否則將追究法律責任。

相關文章