Oracle 10G: diskgroup FLASH was mounted

Posted on 2010-01-06
Last Modified: 2013-12-18

I am a Oracle novice so bear with me. I have noticed that our query returns from our front end
web app has been returning queries very slowly.
We run a four rac cluster and had to recover it the other day. The cluster and oradb all
look good and montoring shows that it is all up and running.
I looked at the alert logs and it says:

Foregrounds taking over
SUCCESS: diskgroup FLASH was mounted
SUCCESS: diskgroup FLASH was dismounted
SUCCESS: diskgroup FLASH was mounted

What does this mean? Thanks
Question by:Sainai
    LVL 3

    Assisted Solution


    are all your 4 RAC instances up & running, check the output of the below query to make sure all 4 instances are running.

    select instance_number, instance_name, host_name, version, status, database_status from gv$instance;

    The message you have mentioned could be a general message. If all instance are running fine then check the alert logs of all 4 instances and may be your SQL needs tuning.

    Also, run AWR report to dig into more analysis for slowness of the query.
    LVL 11

    Accepted Solution

    this was filed as abug like a year ago and then concluded as not a bug
    as per metalink [ID 603204.1]

    these messages are not errors 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.

    Sainai, the work around for this issue to
    to put a mirrored control-file, or mirrored online redo, or dummy online tablespace data file on the diskgroup. is unnecessary.

    this has nothing to do with slowness;as raju1105has mentioned do more DIAG for this issue like AWR.

    Author Closing Comment

    thanks guys. The reason behind the logs were what I was looking for and T-REX you hit it on the spot.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Suggested Solutions

    Title # Comments Views Activity
    Limit Database Table to a Single Row 6 47
    Oracle Modify Partition vs Move Compress 2 36
    oracle 10G 5 37
    SSN Format in Oracle 2 36
    Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
    Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
    This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
    This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now