how to update daily data from production servr to standby server

[Former Member]

Hi

We have installed STANDBY server using "homogenious system copy"

Method. I want to update daily production data to standby server. How?

If it is though archive log files can you tell me the process?

What are the other options for update daily data of production server

to standby server?

we are using oracle 9.2.0 r/3: 4.7ee

Thanks & Regards,

Paruchuri Mahendra

[vince_laurent]

You might want to check in to Oracle Data Guard. Works great.

[Former Member]

If the SID is same , create script to copy and apply archivelogs every 2 hours or so.

regards

subbarao

[Former Member]

how to apply archive logfile in standby server

Thanks & Regards,

Paruchuri Mahendra

[Former Member]

Hi Mahendra,

Please find the link for the solution

http://docs.rinet.ru/O8/ch13/ch13.htm#MaintainingaStandbyDatabase

Regards

Sadanan D

[Former Member]

Hi Mahendra,

You have copy all the offline redo logfiles which were generated by production to the hotstandby system, using the script at os level .

After copy apply the same to hotstandy system .

Please find the same in the below link .

http://docs.rinet.ru/O8/ch13/ch13.htm#MaintainingaStandbyDatabase