HIGH LEVEL STEPS TO SETUP A STANDBY DATABASE IN ORACLE

1) The database has to be archive log mode

2) Force Logging should be enabled.

3) The DBNAME will be the same in Primary and standby but DB unique name will be different.

4) Need to alter => ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(DB11G,DB11G_STBY)';

5) Need to alter log_archive_dest_2 and enable it

6) REMOTE_LOGIN_PASSWORDFILE = { shared | exclusive | none } should exclusive

7) ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO;

8) add entries in tnsnames.ora file in primary and standby side.

9) backup primary database.

10) create a standby control file => ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/tmp/db11g_stby.ctl';

11) CREATE PFILE='/tmp/initDB11G_stby.ora' FROM SPFILE;

12) Amend the PFILE making the entries relevant for the standby database

*.db_unique_name='DB11G_STBY'

*.fal_server='DB11G'

*.log_archive_dest_2='SERVICE=db11g ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=DB11G'

13) Create the necessary directories on the standby server.

14) Copy the files from the primary to the standby server.

15) Remote login password file.

16) CREATE SPFILE FROM PFILE='/tmp/initDB11G_stby.ora'

17) startup mount => restore database

18) create redo logs => we can start MRP process

 

NOTE: FOLLOW BELOW STEPS CREATE STANDBY FROM ACTIVE DATABASE:

19) Standby Server Setup (DUPLICATE)

20) Create Standby Redo Logs on Primary Server

21) Create Standby Using DUPLICATE => STARTUP NOMOUNT PFILE='/tmp/initDB11G_stby.ora';

22) rman TARGET sys/password@DB11G AUXILIARY sys/password@DB11G_STBY

23) DUPLICATE TARGET DATABASE

  FOR STANDBY

  FROM ACTIVE DATABASE

  DORECOVER

  SPFILE

    SET db_unique_name='DB11G_STBY' COMMENT 'Is standby'

    SET LOG_ARCHIVE_DEST_2='SERVICE=db11g ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=DB11G'

    SET FAL_SERVER='DB11G' COMMENT 'Is primary'

  NOFILENAMECHECK;

24) Nornal => ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

25) RTA => ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE;

26) SELECT protection_mode FROM v$database;