Oracle\故障排查\ORA 查抄 alert_log 日志原来是归档日志占满了 FLASH_RECOVERY_AREA 的 2G 空间
1、ORA-00304$oerr ora 00304
00304, 00000, "requested INSTANCE_NUMBER is busy"
// *Cause:An instance tried to start by using a value of the
// initialization parameter INSTANCE_NUMBER that is already in use.
// *Action: Either
// a) specify another INSTANCE_NUMBER,
// b) shut down the running instance with this number
// c) wait for instance recovery to complete on the instance with
// this number.
$
报错分析：
oracle 11g rac 3节点情况修改三个节点public IP 之前没有关闭has服务，重启后有个记得的实例启动不起来
#集群状态
# crsctl status resource -t
--------------------------------------------------------------------------------
NAME TARGETSTATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.DATA02.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.GRID.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.LISTENER.lsnr
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.RECOVERY.dg
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.asm
ONLINEONLINE testosa Started
ONLINEONLINE testosb Started
ONLINEONLINE testosc Started
ora.gsd
OFFLINE OFFLINE testosa
OFFLINE OFFLINE testosb
OFFLINE OFFLINE testosc
ora.net1.network
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
ora.ons
ONLINEONLINE testosa
ONLINEONLINE testosb
ONLINEONLINE testosc
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINEONLINE testosc
ora.cvu
1 ONLINEONLINE testosa
ora.oc4j
1 ONLINEONLINE testosb
ora.rac_db.db
1 OFFLINE OFFLINE Instance Shutdown
2 ONLINEONLINE testosa Open #a节点本身实例id为1，此时变为了2
3 ONLINEONLINE testosb Open
ora.scan1.vip
1 ONLINEONLINE testosc
ora.testosa.vip
1 ONLINEONLINE testosa
ora.testosb.vip
1 ONLINEONLINE testosb
ora.testosc.vip
1 ONLINEONLINE testosc
#
#查看实例状态
# srvctl status database -d rac_db -v
Instance racdb_2 is running on node testosa. Instance status: Open. #从这里看出
Instance racdb_3 is running on node testosb. Instance status: Open.
Database rac_db is not running on node testosc
#
#命令查询各个实例的INSTANCE_NUMBER
$env|grep ORACLE
ORACLE_UNQNAME=rac_db
ORACLE_SID=racdb_1
ORACLE_BASE=/oracle/app/oracle
ORACLE_TERM=xterm
ORACLE_HOME=/oracle/app/oracle/product/11.2.0/db_1
$
SQL> select HOST_NAME,INSTANCE_NUMBER,INSTANCE_NAME,STATUS from gv$instance;
HOST_NAME INSTANCE_NUMBER INSTANC STATUS
---------- ----------------- ------- ------------------------
testosa 2 racdb_2 OPEN
testosb 3 racdb_3 OPEN
SQL>
#尝试从c节点本地启动实例
$sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sat Dec 9 13:18:09 2023
Copyright (c) 1982, 2013, Oracle.All rights reserved.
Connected to an idle instance.
SQL>
SQL> startup
ORA-00304: requested INSTANCE_NUMBER is busy
#此时就需要重新设置sid
$export ORACLE_SID=racdb_1
$sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sat Dec 9 13:49:03 2023
Copyright (c) 1982, 2013, Oracle.All rights reserved.
Connected to an idle instance.
SQL<
页:
[1]