| Setting Up Std By Database [message #63697] |
Thu, 28 October 2004 16:23  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
