Standby : database open..
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Standby : database open..

  1. #1
    Join Date
    Nov 2004
    Location
    Chennai
    Posts
    38

    Standby : database open..

    physical Standby database -- 10.1.0.3.0

    The ALTER DATABASE OPEN READ ONLY; command hangs and its not giving the 'database altered' message and its not returning the prompt, when i open the another sqlplus
    window and check the open mode its read only...is there anyknow issues..This command is part of my recovery script and therefore its not performing the rest of the job in the script...any issues with this command in 10g standby ...

  2. #2
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995
    Sounds like a possible bug. Might want to open up a tar.

    Might as well open one anyway considering you're just beta testing.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  3. #3
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187

    Re: Standby : database open..

    Originally posted by Akila
    physical Standby database -- 10.1.0.3.0

    The ALTER DATABASE OPEN READ ONLY; command hangs and its not giving the 'database altered' message and its not returning the prompt, when i open the another sqlplus
    window and check the open mode its read only...is there anyknow issues..This command is part of my recovery script and therefore its not performing the rest of the job in the script...any issues with this command in 10g standby ...
    is log_archive_start=true on the standby?
    I'm stmontgo and I approve of this message

  4. #4
    Join Date
    Nov 2004
    Location
    Chennai
    Posts
    38
    As this parameter is deprecated in 10G , we didnt set anythg, its in its default value of FALSE.

  5. #5
    Join Date
    Nov 2004
    Location
    Chennai
    Posts
    38
    This is part of the alert file of my standby server....There is no errors...

    Wed Feb 02 02:12:20 2005
    Alter Database Open Read Only
    Wed Feb 02 02:12:20 2005
    SMON: enabling cache recovery
    Wed Feb 02 02:12:21 2005
    Database Characterset is WE8ISO8859P1
    replication_dependency_tracking turned off (no async multimaster replication found)
    Wed Feb 02 02:12:23 2005
    Starting background process MMON
    MMON started with pid=13, OS id=1992
    Wed Feb 02 02:12:23 2005
    Starting background process MMNL
    MMNL started with pid=14, OS id=2924
    Wed Feb 02 02:12:23 2005
    Physical standby database opened for read only

    but still the sqlplus window hangs......

    Looks like a bug....opened a TAR....

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