This content has been marked as final. Show 11 replies
recover managed standby database cancel;
alter database mount standby database;
recover standby database until cancel;
alter database activate standby database;
If you do activate standby that means your standby will become primary and you would need to reinstate it to be back to standby database. It will effecting the original primary if you set up the dataguard back to it. Depends on your testing you can open standby as read only.
thanks for ur help.
If you do activate standby that means your standby will become primary and you would need to reinstate it to be back to standby database.
It will effecting the original primary if you set up the dataguard back to it. Depends on your testing you can open standby as read only.
agree. basically what i need to open the database in read-write. Can i later database open resetlogs rather than activate it?
--> do u mean it will affect and shutdown my original production primary db?
In 10g version, you can open database database with READ ONLY mode. In that case standby database
recieve primary generated changes but not apply .
I see you steps you using ALTER DATABASE ACTIVATE STANDBY DATABASE statement for activating database
Activate the standby database using the SQL ALTER DATABASE ACTIVATE STANDBY DATABASE statement. This converts the standby database to a primary database, creates a new reset logs branch, and opens the database.*
If you are not need convert standby database to primary database then , you must use only
ALTER DATABASE OPEN READ ONLY;
Mahir M. Quluzade
Just to clarify.
I need the standby database to be on read-write mode. (i'm aware that i need to re-instate it back later probably by restoring the production d\b only and enable replication).
But I also need my primary database <production> to be up and running.
How can i do this without impact to my primary database <production>?
The most impt is my production have to be up.
I think no, if you open standby with Read Only mode, on primary not any effect, Primary is continue sending changes to standby, but standby database is not apply on real time.
Because you version is 10g, if you upgrade or install 11g you can open standby database with READ ONLY WITH APPLY. this is ACTIVE DATA GUARD.
thanks for ur reply.
I'm actually on 10g.
Basically I need to open the standby database to be on read-write mode. I understand that i will break the replication by doing it.
In short i want to convert the standby database into a actual database where user can read/write.
At the same time, i need the production db to be running.
My question is, will it bring down my production db if i activate the standby database?