Solved

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

Posted on 2013-01-08
3
307 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 77

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 77

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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

Suggested Solutions

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

751 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