jueves, 6 de febrero de 2014

Convert Primary Database To Standby Database

PRIMARY DATABASE TO STANDBY DATABASE

database version: 11.2.0.1

First of all, you should remember that a standby database cannot be activated and then returned to standby recovery mode.

*Always the first step is to make a backup of database.

1) verify database role:











2) Make a standby controlfile backup:
















3) Open database in "NOMOUNT" state:













4) restore standby controlfile









5) mount database in standby ("alter database mount standby database;") and verify that we have a physical standby database.













DONE!! Good Job :)