Removing the Oracle Data Guard configuration on the primary and standby servers

Log into the primary server.

On Solaris, log in as the oracle user. On Windows, log in as the AgfaService user.

In a command prompt, to run Data Guard manager, type

dgmgrl sys/stayout@MVF1

In Data Guard manager, to remove the Data Guard configuration, type

remove configuration

Remove the Data Guard configuration files from the primary server.

On Solaris, type

cd /opt/oracle/current/dbs

rm dr*.dat

On Windows, delete the dr*.dat file from C:\oracle\product\10.2.0\db_1\database.

Save all the edited Data Guard files such as initMVF.ora, spfileMVF.ora, tnsnames.ora, and listener.ora. To make a copy of these files, type

On Solaris:

cd /opt/oracle/current/dbs

cp initMVF.ora initMVF.ora.dg_save

cp spfileMVF.ora spfileMVF.ora.dg_save

cd /var/opt/oracle

cp tnsnames.ora tnsnames.ora.dg_save

cp listener.ora listener.ora.dg_save

On Windows:

cd C:\oracle\product\10.2.0\db_1\database

cp initMVF.ora initMVF.ora.dg_save

cp spfileMVF.ora spfileMVF.ora.dg_save

cd C:\oracle\product\10.2.0\db_1\network\ADMIN

cp tnsnames.ora tnsnames.ora.dg_save

cp listener.ora listener.ora.dg_save

To turn off flashback, type

sqlplus / as sysdba

alter database flashback off;

To turn off force logging, type

alter database no force logging;

Halt all the job queues.

Stop IMPAX and IIS on the core servers.

To shut down the database, type

sqlplus / as sysdba

shutdown immediate;

Revert the edited files (listener.ora, tnsnames.ora, spfile.ora) to the original files. To copy the original initMVF.ora, tnsnames.ora and listener.ora files back to their respective locations, type

On Solaris:

cd /opt/oracle/current/dbs

cp –rp initMVF.ora.pre_dg initMVF.ora

cd /var/opt/oracle

cp –rp tnsnames.ora.pre_dg tnsnames.ora

cp –rp listener.ora.pre_dg listener.ora

On Windows:

cd C:\oracle\product\10.2.0\db_1\database

cp –rp initMVF.ora.pre_dg initMVF.ora

cd C:\oracle\product\10.2.0\db_1\network\ADMIN

cp –rp tnsnames.ora.pre_dg tnsnames.ora

cp –rp listener.ora.pre_dg listener.ora

To create the spfile from the pfile, type

sqlplus / as sysdba

create spfile from pfile;

To start the database, type

startup;

Modify crontab (Solaris) or Task Scheduler (Windows) and remove references to Oracle Data Guard.

On Solaris:

Comment the 15 20 * * * /usr/mvf/bin/check_if_primary_db && /usr/mvf/bin/check_standby crontab entry out by adding a # at the beginning of the line.

On Windows:

Disable or delete the CheckStandby task in Task Scheduler.

Repeat the previous steps on the standby server.

On the core servers, restart IMPAX and IIS.

Restart all the job queues.

To ensure that IMPAX starts successfully, test the primary database server.

Test the IMPAX Client connectivity.