Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

activate production database from standby

SOLVED
Go to solution
Pradeep_7
Occasional Advisor

activate production database from standby

Hi,

I am using oracle 8.1.6. I have in the process of creating a standby database. I couldn't find anything that says, whether I can come back to the production database after I have used the standby database due to any disaster and fixed the production database.

Is there any way? Thanks.
3 REPLIES
Aashish Raj
Valued Contributor
Solution

Re: activate production database from standby

You can do graceful switchover when u have to do planned maintenance on production server.This can be done only when redo log files are availble from the priamry.
After doing graceful switchover to standby and fixing the problem on production server, u can start database on production server as standby .After this u can again do graceful switchover to make it the production server as primary database.
refer to metalink document on graceful switchover.

Thanks
AR

Re: activate production database from standby

You may want to look at downloading an Oracle8i product called Data Guard. This is a complete package that allows you to perform grace full switchover as well as performing fail over in the case of an emergency.

You can download the software from OTN http://otn.oracle.com/software/deploy/availability/content.html

and the documentation can be downloaded from http://otn.oracle.com/docs/deploy/availability/content.html
Jeanine Kone
Trusted Contributor

Re: activate production database from standby

You could always export from the standby and them import it back into the production. This would give you the added benefit of defragmenting your database while you were at it.