ORA-01618: redo thread 2 is not enabled - cannot mount 問題處理
今天在公司做oracle 10g rac 增加節點實驗,到最後一步新增例項到database中時,只分配一組redo給新加的例項2,導致例項不能啟動成功
[oracle@p650:/oracle/app/oracle]$sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Mon May 24 17:01:06 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1258291200 bytes
Fixed Size 2083728 bytes
Variable Size 419431536 bytes
Database Buffers 822083584 bytes
Redo Buffers 14692352 bytes
ORA-01618: redo thread 2 is not enabled - cannot mount
檢查節點1正常例項
[oracle@p520:/crs/app/oracle/product/crs_1/opmn/conf]$sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.4.0 - Production on Mon May 24 17:01:21 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
FIRST_CHANGE# FIRST_TIME
------------- ------------
1 1 51 52428800 1 NO CURRENT
1251966 24-MAY-10
2 1 50 52428800 1 NO INACTIVE
1194389 20-MAY-10
3 2 0 52428800 1 YES UNUSED
0
發現thread 2 例項只有一組日誌
oracle 資料庫例項日誌組最少兩組,
在節點1對新增加的例項擴充套件日誌檔案
SQL> alter database add logfile thread 2 '/dev/rredo22_lv' size 50m;
Database altered.
SQL> alter database enable thread 2;
Database altered.
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/dev/rredo11_lv
/dev/rredo12_lv
/dev/rredo21_lv
/dev/rredo22_lv
新增後節點2例項就能正常mount和open了
[oracle@p650:/oracle/app/oracle/admin/orcl/bdump]$sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Mon May 24 17:04:48 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> alter database mount;
Database altered.
SQL> alter database open;
Database altered.
SQL>
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-663572/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-01618: redo thread 2 is not enabled - cannot mountthread
- 建立四節點 RAC 啟動時報錯 ORA-01618: redo thread 4 is not enabled - cannot mountthread
- ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabledthread
- Thread 1 cannot allocate new log 的處理辦法thread
- 【問題處理】啟動OUI丟擲libXp.so.6: cannot open shared object file問題處理UIObject
- mysql的處理能力問題(2)MySql
- oracle SP2-問題處理Oracle
- cannot mount database in EXCLUSIVE modeDatabase
- 【問題處理】ORA-00376 file xx cannot be read at this time
- -bash: ulimit: max user processes: cannot modify limit: Operation not permitted問題的處理MIT
- CRS-0184: Cannot communicate with the CRS daemon. 問題處理
- Redo Gap 處理與優化優化
- Java訪問SSL enabled DB2 DatabaseJavaDB2Database
- android處理2個ScrollView聯動問題AndroidView
- 處理問題的方法
- perl中文處理問題
- 漢字處理問題?
- xml處理的問題XML
- 貨品問題處理
- [git] git問題處理Git
- Thread是如何處理Runnable的thread
- oracle系統預設臨時表空間以及redo日誌檔案問題處理Oracle
- SP2-0618: Cannot find the Session Identifier.Check PLUSTRACE role is enabledSessionIDE
- SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabledSessionIDE
- SP2-0618: Cannot find the Session Identifier. Check PLUSTRACE role is enabledSessionIDE
- Thread 1 cannot allocate new logthread
- golang json處理問題GolangJSON
- 併發問題處理方式
- ASMCMD處理問題一則ASM
- mysql的處理能力問題MySql
- RMAN處理split block問題BloC
- mysql問題處理兩則MySql
- Oracle啟動問題處理Oracle
- mysql 問題處理二則MySql
- Oracle壞塊問題處理Oracle
- 資料處理--pandas問題
- redo log檔案丟失處理措施
- os thread startup等待事件HANG處理thread事件