ORA-38856: cannot mark instance UNNAMED_INSTANCE_2 (redo thread 2) as enabled
從rac asm恢復到filesystem的時候,出現如上錯誤。
baidu結果 http://blog.itpub.net/23135684/viewspace-626372/
***************************************************************************************
加上thread 2的日誌檔案:
SQL> ALTER DATABASE ADD LOGFILE THREAD 2
2 GROUP 5 '/u01/app/oradata/rac/redo_t2_log3.log' SIZE 10M REUSE,
3 GROUP 6 '/u01/app/oradata/rac/redo_t2_log4.log' SIZE 10M REUSE;
Database altered.
SQL> alter database open resetlogs;
Database altered.
SQL>alter database disable thread 2;
Database altered.
SQL> select * from v$log;
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
1 1 0 10485760 1 YES UNUSED
2 1 0 10485760 1 YES UNUSED
3 1 0 10485760 1 YES UNUSED
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS
---------- ---------- ---------- ---------- ---------- --- ----------------
4 1 1 10485760 1 NO CURRENT
5 2 1 10485760 1 NO INACTIVE
6 2 0 10485760 1 YES UNUSED
6 rows selected.
SQL> alter database drop logfile group 5;
alter database drop logfile group 5
*
ERROR at line 1:
ORA-00350: log 5 of instance UNNAMED_INSTANCE_2 (thread 2) needs to be archived
ORA-00312: online log 5 thread 2: '/u01/app/oradata/rac/redo_t2_log3.log'
SQL> alter system archive log current;
System altered.
SQL> /
System altered.
SQL> alter database drop logfile group 5;
Database altered.
SQL> alter database drop logfile group 6;
Database altered.
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
/u01/app/oradata/rac/redo_log4.log
/u01/app/oradata/rac/redo_log3.log
/u01/app/oradata/rac/redo_log2.log
/u01/app/oradata/rac/redo_log1.log
處理方法來源:ITPUB論壇
***************************************************************************************
或者使用如下方法:
http://blog.csdn.net/xuefuhe/article/details/6533128
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/24237320/viewspace-1798210/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-01618: redo thread 2 is not enabled - cannot mountthread
- ORA-01618: redo thread 2 is not enabled - cannot mount 問題處理thread
- 建立四節點 RAC 啟動時報錯 ORA-01618: redo thread 4 is not enabled - cannot mountthread
- 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
- Login Oracle Instance Even When sysdba Cannot Do SoOracle
- Bug 4872999 - RAC instance cannot get global enqueueENQ
- Thread 1 cannot allocate new log,Checkpoint not completethread
- Thread 1 cannot allocate new log, sequence NNN 錯誤thread
- ORA-00265: instance recovery required, cannot set ARCHIVELOGUIHive
- Thread 1 cannot allocate new log 的處理辦法thread
- Java訪問SSL enabled DB2 DatabaseJavaDB2Database
- 日誌執行緒 redo thread(專業術語解析)執行緒thread
- ORA-00265: instance recovery required, cannot set ARCHIVELOG modeUIHive
- Thread 1 cannot allocate new log Private strand flush not complete 警告thread
- ORA-01623: log is current log for thread - cannot dropthread
- jQuery :enabledjQuery
- Oracle DG 出現 RFS[6]: No standby redo logfiles created for thread 1Oraclethread
- RAC環境中SID(instance_name),instance_number,thread#,undotbs之間的關聯關係thread
- alter database disable thread 2Databasethread
- Thread2(C#)threadC#
- 2021-2-28 Mark-Java Interview SimpleJavaView
- mark語法
- oracle redo internal (2) --- dump內容理解Oracle Redo
- oracle redo internal (2) --- dump內容理解Oracle
- mark mybatis 返回booleanMyBatisBoolean
- mark mybatis annotation drivenMyBatis
- 標記類 mark
- Oracle redo解析之-2、BBED & DUMP工具使用Oracle Redo
- ORACLE 11gr2 ASM redo log 增加OracleASM
- Ejabberd Cluster Based on EC2 Ubuntu Instance & LoadBalancerUbuntu
- CSS E:enabled 選擇器CSS
- REST is not enabled. use -rest to turn onREST
- dba_enabled_traces 資料
- Add Node/Instance Remove Node/Instance in 10gR2 11g Clusterware RAC_1332451.1REM
- DB2 的事務日誌(redo log)DB2