Configuring RMAN backups after the Oracle Data Guard configuration

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, change to the /usr/mvf/bin (Solaris) or the C:\mvf\bin (Windows) directory.

Run the configure_backup command.

To create a standby control file on the primary server, type

sqlplus / as sysdba

alter database create standby controlfile as '/opt/oracle/standby_control_file.ctl';

Copy the control file, standby_control_file.ctl, from the primary to the standby server.

On Solaris, you can use the following command to do so:

scp /opt/oracle/standby_control_file.ctl service@host_name_of_standby_server/usr/mvf

On Windows, use standard copy and paste functionality to copy the file over.

Log into the standby server as the oracle (Solaris) or AgfaService (Windows) user.

Run the configure_backup command on this server as well.

To shut down the standby server, type the following:

sqlplus / as sysdba

shutdown immediate;

To import the standby control files from the primary server to the standby server, first rename them with a .orig extension on the standby server; for example, change control03.ctl to control03.ctl.orig. The files to rename are:

1. /usr/mvf/data/dbase/data2/control03.ctl (Solaris) or E:\data\dbase\data2\control03.ctl (Windows)

2. /usr/mvf/data/dbase/index2/control02.ctl (Solaris) or E:\data\dbase\index2\control02.ctl (Windows)

3. /usr/mvf/data/dbase/system/control01.ctl (Solaris) or E:\data\dbase\system\control01.ctl (Windows)

Now copy the standby control files from the primary server to the standby server. The files to copy are the same as those listed in the previous step.

To start and mount the standby server, type

sqlplus / as sysdba

startup mount