This discussion is archived
6 Replies Latest reply: Feb 1, 2007 6:04 AM by user522961 RSS

DATABASE_STATUS

user522961 Newbie
Currently Being Moderated
Hi,
in v$instance what does DATABASE_STATUS colomn mean ? What are its values and their meanings ? I looked at
http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10755/dynviews_1108.htm#sthref3167
and it says : DATABASE_STATUS VARCHAR2(17) Status of the database ; which is not clear for me.
Many thanks.
  • 1. Re: DATABASE_STATUS
    Eduardo Legatti Explorer
    Currently Being Moderated
    Hi,
    SQL> alter system suspend;
    System altered.

    SQL> select database_status from v$instance;
    DATABASE_STATUS
    -----------------
    SUSPENDED


    SQL> alter system resume;
    System altered.

    SQL> select database_status from v$instance;
    DATABASE_STATUS
    -----------------
    ACTIVE
    Cheers
  • 2. Re: DATABASE_STATUS
    user522961 Newbie
    Currently Being Moderated
    What is a suspended and what is an active databse ?
  • 3. Re: DATABASE_STATUS
    530897 Explorer
    Currently Being Moderated
    The DATABASE_STATUS column, as demonstrated by Legatti, shows if the database is in a suspended state or active state.


    The ALTER SYSTEM SUSPEND statement halts all input and output (I/O) to datafiles (file header and file data) and control files. The suspended state lets you back up a database without I/O interference. When the database is suspended all preexisting I/O operations are allowed to complete and any new database accesses are placed in a queued state.

    http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14231/start.htm#i1006690
  • 4. Re: DATABASE_STATUS
    Eduardo Legatti Explorer
    Currently Being Moderated
    Hi,

    Take a look on this link below:
    http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14231/start.htm#sthref614

    Cheers
  • 5. Re: DATABASE_STATUS
    oracletune Newbie
    Currently Being Moderated
    hi:

    1. v$instance descibes Oracle INSTANCE behavior: the set of Oracle background processs and associated memory region (SGA).

    2. review V$database for database behavior, esp "open_mode" column below:

    SQL>
    1 select open_mode,
    2 protection_mode,
    3 open_resetlogs,
    4 protection_level,
    5 switchover_status,
    6 guard_status
    7* from v$database
    SQL> /

    OPEN_MODE PROTECTION_MODE OPEN_RESETL PROTECTION_LEVEL SWITCHOVER_STATUS GUARD_S
    ---------- -------------------- ----------- -------------------- -------------------- -------
    MOUNTED MAXIMUM PERFORMANCE NOT ALLOWED UNPROTECTED NOT ALLOWED NONE
  • 6. Re: DATABASE_STATUS
    user522961 Newbie
    Currently Being Moderated
    Thank you.