CREATING A PHYSICAL STANDBY

1. connect to primary database using rman

>rman target /
RMAN>COPY CURRENT CONTROLFILE FOR STANDBY TO '/dbscratch/bkup/sby_control01.ctl';

2. copy control file to DR and Restore it There.

RMAN>restore controlfile from 'c:\temp\SBY_CONTROL01.CTL';

3. backup the data files from primary:

run {
allocate channel d1 type disk format 'c:\temp\hr_%U' ;
allocate channel d2 type disk format 'c:\temp\hr_%U' ;
BACKUP DATAFILE 1,2,3,4,5;
}

4. DR side catalog it and restore.

RMAN> catalog start with 'c:\temp\';
RMAN> run {
allocate channel d1 type disk;
allocate channel d2 type disk;
setlimit channel d1 kbytes 2097150;
setlimit channel d2 kbytes 2097150;
RESTORE DATAFILE 1,2,3,4,5;
}

5. at primary side keep the tns name of the dr database as the  log_archive_dest_2
>alter system set log_archive_dest_2='SERVICE=HR_DR' scope=both sid='*'

6. make sure that you are able to connect to DR side from primary like:
>sqlplus "/@hr_dr as sysdba"
i
Note :- f this is not working archive log shipping will not work.
you may have to copy the password file from primary to DR to make it work.
enable the dest_state_2 to enable the archive shipping to DR.

7. Just start the manged recovery in the DR side.
alter database recover managed standby database disconnect;

===========================================================$$$$$$$$$$$$$$$$$$$$$$$$$=======================================


DR SIDE FILE CORRUPT

1. Backup file from the primary

run {
allocate channel d1 type disk format '/u01/app/oracle/canbeDeleted/usmbp_%U' ;
allocate channel d2 type disk format '/u01/app/oracle/canbeDeleted/usmbp_%U' ;
setlimit channel d1 kbytes 2097150;
setlimit channel d2 kbytes 2097150;
BACKUP DATAFILE 4;
}

2.  DR side catalog it and restore

catalog start with '/u01/app/oracle/canbeDeleted/';

run {
allocate channel d1 type disk;
allocate channel d2 type disk;
setlimit channel d1 kbytes 2097150;
setlimit channel d2 kbytes 2097150;
RESTORE DATAFILE 4;
}