Alter Dtabase Close
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Alter Dtabase Close

Hybrid View

  1. #1
    Join Date
    Feb 2002
    Posts
    267

    Alter Database Close

    Hi folks,
    What is the use of 'ALTER DTABASE CLOSE' command
    This command brings the instance from OPEN state to MOUNT state.

    But from mount it is not possible to go back to open......i think it is a bug...........

    Is this the only use or is there any other use?

    Regards
    sonia
    Last edited by Sonia; 10-31-2002 at 08:15 AM.

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    Re: Alter Database Close

    Originally posted by Sonia

    But from mount it is not possible to go back to open......i think it is a bug...........
    How about ALTER DATABASE OPEN ?

    Sometimes you may need to bring your database to mount mode for some maintenance. Instead of shutting it down and bringing it up in mount mode, you can use ALTER DATABASE CLOSE.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Oct 2000
    Posts
    467
    Once closed, the database is in mount state but cannot be opened from there on. You need to shut it down to open it, atleast on 817.
    Here's the detail -

    SVRMGR> startup ;
    ORACLE instance started.
    Total System Global Area 156633116 bytes
    Fixed Size 75804 bytes
    Variable Size 44003328 bytes
    Database Buffers 112476160 bytes
    Redo Buffers 77824 bytes
    Database mounted.
    Database opened.
    SVRMGR> alter database close;
    Statement processed.
    SVRMGR> select status from v$instance;
    STATUS
    -------
    MOUNTED
    1 row selected.
    SVRMGR> alter database open;
    alter database open
    *
    ORA-01531: a database already open by the instance
    SVRMGR> select status from v$instance;
    STATUS
    -------
    MOUNTED
    1 row selected.
    SVRMGR> startup open;
    ORA-01081: cannot start already-running ORACLE - shut it down first
    SVRMGR> shutdown;
    ORA-01109: database not open
    Database dismounted.
    ORACLE instance shut down.
    SVRMGR> startup;
    ORACLE instance started.


    Here's the fun part..although it says database closed, when u say "alter database open" oracle says db is already open.
    Vinit

  4. #4
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Yep, this behavior has stil not been changed in 9i, at least not in 9.0.1.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width