Solved

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

Posted on 2013-01-08
3
297 Views
Last Modified: 2013-01-14
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
0
Comment
Question by:gotetioracle
  • 2
3 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38754655
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.
0
 

Author Comment

by:gotetioracle
ID: 38762628
@ slightwv : please suggest me simpler one as iam new o this field.
0
 
LVL 76

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 38762696
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.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question