ARC1: Thread not mounted lead to database not mounting
今天在啟動資料庫的時候,發現database起不來了,停在了nomount狀態,檢查alert.log
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=8
ARC0: Archival started
ARC1 started with pid=9
ARC1: Archival started
Fri Jun 25 00:07:52 2004
ARCH: STARTING ARCH PROCESSES COMPLETE
Fri Jun 25 00:07:52 2004
ARC1: Thread not mounted Fri Jun 25 00:07:52 2004
ARC0: Thread not mounted Fri Jun 25 00:07:54 2004
ARC0: Thread not mounted
不知道是什麼原因,資料庫停在了nomount狀態,後來
sql> alter database mount ;
sql> alter database open;
問題解決了。
metalink原因如下:
THE INFORMATION IN THIS ARTICLE APPLIES TO:
Oracle Server - Enterprise Edition - Version: 9.2.0.4
This problem can occur on any platform.
SYMPTOMS:
While doing the startup of the database it simply hangs at the mount stage.
CAUSE:
From the Alert.log
=============
ARCH: STARTING ARCH PROCESSES
ARC0 started with pid=8
ARC0: Archival started
ARC1 started with pid=9
ARC1: Archival started
Fri Jun 25 00:07:52 2004
ARCH: STARTING ARCH PROCESSES COMPLETE
Fri Jun 25 00:07:52 2004
ARC1: Thread not mounted Fri Jun 25 00:07:52 2004
ARC0: Thread not mounted Fri Jun 25 00:07:52 2004
NOTE: This can happen if multiple archive processes are running. A lock conflict may result. This is not considered a bug within development.
FIX:
Open another sql*plus session
Login as sysdba
Shutdown abort
Startup
Subject:
Database Not Mounting
:
277207.1
Type:
PROBLEM
Modified Date :
14-JAN-2008
Status:
MODERATED
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/9252210/viewspace-586734/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- How a Database Is Mounted (293)Database
- 3.2.1 Mounting a Database to an InstanceDatabase
- How a Standby Database Is Mounted (295)Database
- How a Clone Database Is Mounted (296)Database
- How a Database Is Mounted with Real Application Clusters (294)DatabaseAPP
- 3.1.5.2 Starting an Instance, and Mounting and Opening a DatabaseDatabase
- ORA-01679: database must be mounted EXCLUSIVE and not open to activateDatabase
- alter database disable thread 2Databasethread
- ARC0: Becoming the 'no FAL' ARCH ARC0: Thread not mountedthread
- Incorrect MEMORY_MAX_TARGET (> Available RAM) Can Lead To Database HangsAIDatabase
- Mounting ISO images on AIXAI
- lead和lag函式函式
- lag和lead函式函式
- Connections to NOMOUNT/MOUNTED or RESTRICTED Databases FailRESTDatabaseAI
- Why Archive, FRA Diskgroup Gets Mounted / DismountedHive
- oracle之函式LAG,LEADOracle函式
- 『中級篇』docker 使用bind Mounting實戰(36)Docker
- oracle函式之lag和leadOracle函式
- oracle中lead和lag函式Oracle函式
- 一天兩次,PING[ARC1]: Heartbeat failed to connect to standbyAI
- Recruitment: J2EE Technical Lead -- ShanghaiUIAI
- 使用LAG和LEAD函式統計函式
- vue中methods、mounted等的使用方法解析Vue
- Threadthread
- 【轉】vue mounted 呼叫兩次的解決辦法Vue
- 求助!vuex在mounted中拿不到物件裡的值Vue物件
- oracle lag與lead分析函式簡介Oracle函式
- Elevate Your Lead Generation Game with Maps Scraper AIGAMAI
- Hello,Threadthread
- Thread類thread
- Thread jointhread
- ORA-27054: NFS file system where the file is created or resides is not mountedNFSIDE
- Hive 分析函式lead、lag例項應用Hive函式
- [Oracle] Append hint(insert sql) will lead a TM LOCKOracleAPPSQL
- mount.ocfs2: Transport endpoint is not connected while mounting /dev/emcpowera1Whiledev
- Thread.jointhread
- Thread知識thread
- redolog threadthread