Restoring the database on the standby server

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

Change to the /opt/oracle/current/dbs (Solaris) or C:\oracle\product\10.2.0\db_1\database (Windows) directory

On Solaris, type

mv orapw orapw.pre_dg

orapwd file=orapw password=stayout entries=40

On Windows, type

mv PWDMVF.ora PWDMVF.ora.pre_dg

orapwd file=PWDMVF.ora password=stayout entries=40

This creates an Oracle password file.

To ensure that the scripts can log into SQLPlus as the sys or dbadmin user, type

sqlplus / as sysdba

alter user sys identified by stayout;

grant sysdba to dbadmin;

On Solaris, to mount the partition locally, log in as the root user and type

mount primary_server_name:path_to_flashback_recovery_area_on_primary_server /mnt1

Note: If the database volumes are mounted using NFS, complete this procedure from the NAS hosting the NFS share to the primary server.

Copy all flashback recovery files from the primary server to the standby server.

On Solaris, change to the mnt1 directory and use the cp -rp * /complete_path_to_standby_database_flashback_area/ command.

On Windows, use standard file copy and paste functionality.

Change to the /usr/mvf/bin (Solaris) or C:\mvf\bin (Windows) directory.

To start the Oracle Data Guard configuration:

On Solaris, type ./setup_dg.

On Windows Server 2008, either 32-bit or 64-bit, open an elevated command prompt. To open an elevated command prompt, select Start, right-click Command Prompt, then select Run as administrator.

On Windows, type bash setup_dg.

Enter the Flashback and host name information as prompted.

When asked if you want to do the RMAN restore, type "y".