$ Export ORACLE_SID=TEST

$ rman target /

RMAN> show all;

Using target database controlfile instead of recovery catalog RMAN configuration parameters are:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;

CONFIGURE BACKUP OPTIMIZATION OFF;

CONFIGURE DEFAULT DEVICE TYPE TO DISK;

CONFIGURE CONTROLFILE AUTOBACKUP ON;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'I:Oracle_Backups%d_%F.rman';

CONFIGURE DEVICE TYPE DISK PARALLELISM 1;

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'I:Oracle_Backups%d_%s_%p.rman';

CONFIGURE MAXSETSIZE TO UNLIMITED;

CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'E:ORACLEORA92DATABASESNCFTEST.ORA';

2. Backup the current production database to create a standby database: RMAN> backup database include current controlfile for standby plus archivelog;

3. Manually copy the backup sets from I:Oracle_Backups on the production server to I:Oracle_Backups on the DR Server (location of backups must match on both production and DR).

4. On the DR Server start up the TEST database in nomount mode:

$ set ORACLE_SID=TEST

$ sqlplus /nolog

SQL> connect / as sysdba

SQL> startup nomount

SQL> exit

5. Create the standby database using RMAN (This assumes the database file structures will be identical on both servers):

$ RMAN target ‘sys/fluffy@STTEST’ auxiliary /

RMAN> duplicate target database for standby nofilenamecheck dorecover;

6. Once the DR database is created; you will need to manually add a tempfile:

SQL> alter database open read only;

SQL> alter tablespace temp add tempfile ‘F:Oracle-DatabasesTESTTEMP01.DBF’ size 500M;

7. Put the DR database into managed standby mode:

SQL> shutdown immediate

SQL> startup nomount

SQL> alter database mount standby database;

SQL> alter database recover managed standby database disconnect;

8. On the production database switch logs to initiate replication:

SQL> alter system switch logfile;

The configuration of Dataguard is now complete.