Home » RDBMS Server » Server Administration » Archive log in Replication Server
Archive log in Replication Server [message #204840] Wed, 22 November 2006 06:04 Go to next message
Messages: 123
Registered: July 2005
Senior Member
Dear all

We are having two Oracle 10g Databases running on two physically seperate Linux based Servers.
One is Primary database for Online transactions and other is for data replication/backup.
We are replicating data on replication server every evening. Right now our Primary database is in Archivelog mode and Replicate in Non Archivelog Mode.
My question is , If I make Replicate server too in Archive log enabled and copy the Archive log of Primary server to replicate on hourly basis then can it be posible to recover one hour old data on replicate server in case of primary server hardware failure and use it as primary server.


Re: Archive log in Replication Server [message #204846 is a reply to message #204840] Wed, 22 November 2006 06:29 Go to previous message
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You need to read up about DataGuard, and, in particular Physical Standby Databases
These are identical copies of your main database that are in a state of permenant recovery, so you can apply the archive logs from your main db to it.
Previous Topic: What was the Problem Listener not functing Porperly
Next Topic: Identifying and extracting an old data over three years
Goto Forum:

Current Time: Thu Aug 24 04:00:32 CDT 2017

Total time taken to generate the page: 0.01735 seconds