Home » Server Options » Data Guard » Setting Up Std By Database
Setting Up Std By Database [message #63697] Thu, 28 October 2004 16:23 Go to next message
IA
Messages: 91
Registered: March 2004
Member
Hi Everyone,

 

I understand that from a primary database, we can send archived redo logs to stand by database. This is achieved by specifying the TNS entry for the remote database.

 

Two questions:

 

1. How is the redo log transmitted over the network? Oracle outlines that an RFS process takes care of it. But, is there any special setup required other than network connectivity between two unix boxes?

 

2. In specifying the location for archive logs to a standby database, where do the archived redo logs arrive on the target/remote std by machine?

 

I would appreciate your answers to the above questions.

 

Thanks in advance ... IA
Re: Setting Up Std By Database [message #63702 is a reply to message #63697] Fri, 29 October 2004 06:35 Go to previous message
croK
Messages: 170
Registered: April 2002
Senior Member
Yes..it is as simple as you described.
On target/remote database archived redo log files will be saved according the init parameter
standby_archive_dest='/disk1/oracle/oradata/payroll/standby'
above parameter mus be defined on PRIMARY DB.
and you also must setup the following parameters on your PRIMARY DB:
log_archive_dest_1=('LOCATION=/disk1/oracle/oradata/payroll/standby/')
standby_file_management=AUTO
remote_archive_enable=TRUE

that way oracle will transfer archived redo log to the other server....

Best luck.
Previous Topic: Stabdby Database
Next Topic: Help! Client tnsnames.ora - Oracle 9i Data Guard Standby Configuration
Goto Forum:
  


Current Time: Thu Mar 28 10:36:59 CDT 2024