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 :)