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
Life is a journey, not a destination!
Click Here to Expand Forum to Full Width