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
sarfraz_attari
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.

Thanks

Sarfraz

Report message to a moderator

Re: Archive log in Replication Server [message #204846 is a reply to message #204840] Wed, 22 November 2006 06:29 Go to previous message
JRowbottom
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.

Report message to a moderator

Previous Topic: upgrading 32 bit 10g to 64bit
Next Topic: ORA-12520: TNS:listener could not find available handler for requested type of server
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 06:25:30 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.