Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Restoring a secondary database using archive logs of primary database (11 G R2)
Posted on 2013-01-08
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
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
[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
Active today
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.
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.
Active today
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.
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.
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This post first appeared at Oracleinaction (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself).
I will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month7 days, 9 hours left to enroll
Earn Certification
Certified Information Systems Auditor (CISA)
$99.00$89.10
632 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.