LOG SHIPPING ORACLE 11G

LOG-SHIPPING IN ORACLE 11G USING BASIC STEPS :



Hi All,

When you are using standard edition in oracle than log shipping is used for the DR. Because we all know that Data guard is better than Log Shipping but  Data guard is only used in Enterprise edition.

step 1 : 
Production ip : 192.168.1.81
Standby ip : 192.168.1.82



step 2 : 
Make database using dbca in primary database
[orcl]



step 3 : 
make below directory in standby server

- /u01/arc/orcl
- /u01/oracle/oradata/orcl
- /u01/oracle/admin/orcl
- /u01/oracle/admin/orcl/adump
- /u01/oracle/admin/orcl/dpdump
- /u01/oracle/admin/orcl/pfile

example :[mkdir -p /u01/arc/orcl]



step 4 :
shut immediate in primary database



step 5 :
copy oradata from primary to Standby
[rsync -azvh --progress /u01/oracle/oradata/orcl/*.*  192.168.1.82:/u01/oracle/oradata/orcl/]

step 6 :copy spfile from primary to standby
[using above rsync command]

step 7 :
 startup normal in primary database
startup mount in standby database[for checking database]

step 8 :
- shut immediate in standby database
- create backup controlfile in primary database
[ ALTER DATABASE BACKUP CONTROLFILE TO '/u01/control01.ctl']

- rename both control file in standby database
example : [mv control01.ctl control01.ctl.ddd]

- copy backup control file from primary database to standby server
[ rsync -azvh --progress /u01/control01.ctl 192.168.1.82:/u01/oracle/oradata/orcl/]

- [cp control01.ctl control02.ctl] in standby serverstep 9 :
- startup mount in standby database
 
step 10 :
- ALTER SYSTEM SWITCH LOGFILE (ATLEAST 4 TO 5 TIMES IN PRIMARY DATABASE
)



step 11 :
- Recover database using backup controlfile until cancel (standby database)

Thanks,