Status: Solved
Priority: Medium
Security: Public
Views: 320
Last Modified: 2013-01-14

Restoring a secondary database using archive logs of primary database (11 G R2)

hi,

I have two fresh server which we are planning to have one as primary database and other secondary database .We want to restore the secondary database by using primary DB archive logs and keep the secondary db in read only mode and switch over manually when primary is down.As i am new to this field my terminologies are like layman .

I am using RHEL 5.5 as OS and Oracle version is 11G R2

Regards,
GSK

gotetioracle

Asked: 2013-01-08

Advertise Here

Oracle Database

1 Solution

LVL 79

slightwv (䄆 Netminder) Commented: 2013-01-08

I believe what you are after is called Oracle Data Guard.

http://www.oracle.com/technetwork/database/features/availability/dataguardoverview-083155.html

The online docs for it are at:
http://docs.oracle.com/cd/E11882_01/server.112/e25608/toc.htm

There is a ton of information out there once you start searching around for it.

gotetioracleAuthor Commented: 2013-01-10

@ slightwv : please suggest me simpler one as iam new o this field.

LVL 79

slightwv (䄆 Netminder) Commented: 2013-01-10

A simpler what?
If you are looking for a step-by-step guide, I'm sure you can find one but I discourage you from using them. You really need to understand the product/technology before you just jump in and start setting it up.

Once you understand what something is doing and why it is doing it, then setting it up is pretty straight forward.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Restoring a secondary database using archive logs of primary database (11 G R2)

Join & Write a Comment Already a member? Login.

Featured Post