Converting 11g Standby to a Primary test database
edited Jan 30, 2013 3:49PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 7 commentsAnswered
Hi
We have a 11g (11.2.0.2) physical standby database
As part of the project, we are now required to use that database to serve as Q/A database
So, basically the standby database will NOT be a standby database anymore and instead used as a primary database for Q/A purpose
In order to do that, on the PRIMARY database, we will first DISABLE the log_archive_dest_2 of PRIMARY database where log_archive_dest_2 points to the SERVICE of the standby database. Our question is that what exact steps we need to perform on the STANDBY server to make it work as a stand alone primary server
1