Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2002
    Posts
    9

    Unanswered: Standby database question! plz help!!!

    Hey all,

    We setup a standby database, and we are kicked off the recover managed standby database command.

    Does this command just sit there at the prompt? Do we have to keep it running? (Ie, it doesn't run in the background?) If so, what happens when the machine that it is running on goes down?

    Thanks!!

  2. #2
    Join Date
    Mar 2002
    Posts
    4
    The standby database will need to stay in managed recovery mode to keep in sync w/the prod database (shipping logs ...etc). I accomplished this by writing two basic scripts one to put the standby into managed recovery and one to cancel the managed recovery mode. The 1st script I run the back ground until I wish to cancel

    ex

    > cat recover_stby
    ORACLE_SID=Test
    export ORACLE_SID
    svrmgrl <<EOF
    connect internal;
    alter database recover managed standby database;
    EOF

    > cat recovery_cancel_stby
    ORACLE_SID=Test
    export ORACLE_SID
    svrmgrl <<EOF
    connect internal;
    alter database recover managed standby database cancel;
    EOF


    Check the alert logs on both prod and standby to make sure things are going smooth with the log transfreres..



    A couple good Docs:

    Standby Database Concepts and Administration
    Release 2 (8.1.6)

    Graceful Switchover and Switchback
    Oracle Standby Database
    Versions 7.3, 8.0, 8.1
    Revised November 11, 1999

    Oracle8 i Standby Database
    Technical Report

Posting Permissions

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