Activating standby database question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Activating standby database question

  1. #1
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Hi,
    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

    Thanks
    Ronnie

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Thanx
    Sam



    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