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