Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    4

    Unanswered: standby connection restoration

    I have a standby database on separate server. There was a network breakup on weekend.
    On Monday when I check status of standby connection there was a connection error on primary database.

    I want to know is there any possibility to restore standby connection without restarting primary database.

    Remember this is oracle 8i scenario..... Thanks in advance

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    look into your init<ORA> for log_archive_dest_2 where standby is mentioned

    these commands can be submitted as

    alter system set log_archive_dest_2 = 'service <stdby> mandatory retention ...;

    alter system set log_archive_des_2 = enable ;

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by osy45
    alter system set log_archive_dest_2 = 'service <stdby> mandatory retention ...;
    I wouldn't do that - if you specify standby database as a mandatory log destination then it would halt the primary database in case of a network problem. I think just specifying "REOPEN=..." to set retry interval will do the trick.

Posting Permissions

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