find primary for this secondary database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: find primary for this secondary database

  1. #1
    Join Date
    Jan 2001
    Posts
    2,828

    find primary for this secondary database

    Hi Folks

    I am into a new environment and there are over 5000+ databases..i have a database log which says unable to ship logs to secondary server.However this is a standby database.Database is called xxstdby .However i do not know whats the primary database for which xxstdby is the standby.How do i find it out ?

    regards
    Hrishy

  2. #2
    Join Date
    Jan 2003
    Location
    Delhi
    Posts
    63
    connect to the standby db using dgmgrl
    and then show configuraiton will say the both primary and standby db

  3. #3
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    same sid? did u check that?
    I'm stmontgo and I approve of this message

  4. #4
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    Hi,
    You can check for parameter STANDBY_ARCHIVE_DEST, this is used only in managed recovery standby db.

    This parameter will tell you the location of the primary database.

    Also TARGET column of v$ARCHIVE_DEST table will give you standby and primary database information.

    regards
    anandkl
    anandkl

  5. #5
    Join Date
    Jan 2001
    Posts
    2,828
    Hi anandkl,mdash


    Thank you very much for your suggestions :-)

    regards
    Hrishy

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