Physical standby as standalone Read/Write

Hi All,

I'll be converting the physical standby database as standalone database in READ/WRITE mode for a week's time,

version : 11.2.0.3

O/s : Red Hat Enterprise Linux Server release 5.8

On primary:

• alter system switch logfile;

• alter system set log_archive_dest_state_2='defer';

On standby:

• alter database recover managed standby database cancel;

• alter system set log_archive_dest_state_2='defer';

• ALTER DATABASE ACTIVATE STANDBY DATABASE;

• SELECT database_role FROM V$DATABASE;

Remove the DG specific parameters from new primary(standby database)

• Take a spfile/pfile backup before making changes.

• alter system set log_archive_config='';

• alter system set log_archive_dest_state_2='defer';