• Create an init.ora containing just DB_NAME...

echo DB_NAME=${ORACLE_SID} >$ORACLE_HOME/dbs/init${ORACLE_SID}.ora

• Create a Password File - password should match the Primary DB (an alternate approach is to copy the password file from the Primary and rename it). For the command below you will be prompted for the password...

orapwd file=$ORACLE_HOME/dbs/orapw${ORACLE_SID}

• Startup the database but don't Mount it...

sqlplus / as sysdba

startup nomount

exit

• Create target directories...

mkdir -p /u01/dba/rman

mkdir -p /u02/oradata/ORCL2

mkdir -p /controlfile1/ORCL2

mkdir -p /controlfile2/ORCL2

mkdir -p /fra/ORCL2

STANDBY

STANDBY

• Set Initialisation Parameters

ALTER SYSTEM SET FAL_CLIENT=ORCL2 SCOPE=BOTH;

ALTER SYSTEM SET FAL_SERVER=ORCL1 SCOPE=BOTH;

ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO SCOPE=BOTH;

ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(ORCL1,ORCL2)' SCOPE=BOTH;

ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST' SCOPE=BOTH;

ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=ORCL1 ASYNC NOAFFIRM REOPEN=300 DB_UNIQUE_NAME=ORCL1 VALID_FOR=(PRIMARY_ROLE,ONLINE_LOGFILE)' SCOPE=BOTH;

ALTER SYSTEM SET LOG_ARCHIVE_MAX_PROCESSES=4 SCOPE=BOTH;

• if not using OMF then:

ALTER SYSTEM SET LOG_FILE_NAME_CONVERT='ORCL1','ORCL2' SCOPE=SFILE;

• Start Managed recovery

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

• Check in alert.log to be sure the databases are communicating. You should see things like this...

• Use this query to confirm that the Transport Lag and Apply Lag is 0...

SELECT NAME, VALUE, UNIT

FROM V$DATAGUARD_STATS;