Why Archive, FRA Diskgroup Gets Mounted / Dismounted
Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7 - Release: 10.1 to 11.1
From Bug:4465015 [ASM DISKGROUP FOR FLASH RECOVERY AREA DISPLAY MOUNT AND DISMOUNT IN DB ALERT LOG] (Status: 92,Closed, Not a Bug )
This is expected behavior. The messages you see are not errors (that is why they are prefixed with "SUCCESS"). The database instance is creating and then closing archive logs one at a time in the FLASHDG_NEW disk group. Whenever a database closes its last file in a disk group, it dismounts the disk group. Whenever a database accesses a disk group when it does not have any other files open in the disk group, it mounts the disk group.
If you do not want to see the log messages frequently, you can put a mirrored control-file, or mirrored online redo, or dummy online tablespace data file on the diskgroup. This message will not be output frequently in this case. Because CKPT keeps opening a control-file, LGWR keeps opening an online redo, DBW keeps opening an online tablespace data file. So, the diskgroup is not dismounted until the database shutdown.
Example:
In order to keep the +FRA diskgroup mounted permanently, please create a dummy tablespace on the +FRA diskgroup, which holds the archivelogs, in that way dbw keeps opening an online tablespace data file, so, the diskgroup is not dismounted until the database shutdowns:
SQL> create tablespace dummy_flash datafile '+FRA' size 10M;
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/7199859/viewspace-760944/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-15055 ASM Diskgroup Status Showing Dismounted From RDBMS InstanceASM
- 【RAC】Diskgroup shows offline after restart even it is mounted in ASM instanceRESTASM
- 【RMAN】什麼是Fast Recovery Area(FRA),如何配置FRAAST
- oracle buffer gets=db block gets+consistent getsOracleBloC
- WhyASMLIBandwhynot?ASM
- DB Bocks gets & Consistent gets 區別
- How a Database Is Mounted (293)Database
- db block gets 與 consistent read getsBloC
- DB Block Gets、Consistent Gets、Physical ReadsBloC
- How a Standby Database Is Mounted (295)Database
- How a Clone Database Is Mounted (296)Database
- consistent gets
- recursive calls, db block gets,consistent gets,physical ReadsBloC
- recursive calls ,db block gets , consistent gets的含義BloC
- DB Bocks gets,Consistent gets And Physical reads 轉載
- Why TypeScript?TypeScript
- Why NoSQL?SQL
- C'est certainement fra?ches sur le dessusAI
- 對'Consistent Gets',''Physical Reads'和'DB Block Gets'的理解BloC
- consistent gets、db block gets的簡單精闢的理解BloC
- Why React HooksReactHook
- WHY review code?View
- Why Redis 4.0?Redis
- Consistent Gets,Physical Reads和DB Block Gets的解釋(轉)BloC
- (轉)關於 db block gets,consistent gets,physical reads的概念BloC
- Connections to NOMOUNT/MOUNTED or RESTRICTED Databases FailRESTDatabaseAI
- Oracle啟用FRA和archivelog步驟OracleHive
- 解決FRA空間滿的問題
- gets函式的漏洞函式
- 對'Consistent Gets',''Physical Reads'和'DB Block Gets'的理解和解釋BloC
- 【Oracle-記憶體管理】-DB Blocks gets,Consistent gets And Physical readsOracle記憶體BloC
- Asm diskgroup 的修復ASM
- script of check repair ASM DISKGROUPAIASM
- How a Database Is Mounted with Real Application Clusters (294)DatabaseAPP
- C語言關於指標,gets()和gets_s()函式的理解C語言指標函式
- [譯] WebAssembly: How and whyWeb
- WhyRedis4.0?Redis
- why use dynamic SQL?SQL