6 Replies Latest reply: Feb 1, 2007 8:04 AM by user522961 RSS

    DATABASE_STATUS

    user522961
      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
          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
            What is a suspended and what is an active databse ?
            • 3. Re: DATABASE_STATUS
              530897
              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
                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
                  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
                    Thank you.