DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Activating standby database question

  1. #1
    Join Date
    Mar 2001
    New York , New York
    I was testing how to implement standby databases.

    I have a primary database orcl8i on a Windows 2000 machine and I created a standby database stby on the same machine (same because its just for testing). Everything went fine and I was able to configure it in a managed recovery mode and it just works fine.

    Now my question is I want to simulate a failover or you can say simulate a crash where the primary database crashes and i activate the standby database for read write operations on the database.

    I know that I can open the standby database in read only mode by giving the command

    alter database open read only;

    but i want to make the standby primary so that i know how to do it when we actually implement it.

    Can somebody point me to the right direction


  2. #2
    Join Date
    Oct 2000
    Saskatoon, SK, Canada

    Life is a journey, not a destination!

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