Solved

How to restore using RMAN backup

Posted on 2007-12-01
1
3,416 Views
Last Modified: 2013-12-18
Hi,

We are planning to use RMAN as our basic backup tool to backup Oracle database.We are using ASM to store data files, control files and archivelogs. We tested various scenarios except one. Suppose we have full online RMAN backup and all archivelogs, what are the steps to restore this backup onto to a different system, in case we loose our production hardware?

Thanks,

Sreeram
0
Comment
Question by:sreeram44
[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
1 Comment
 
LVL 9

Accepted Solution

by:
joebednarz earned 250 total points
ID: 20395661
This has been outlined on many pages out in the internet... here is one:

http://www.labunix.uqam.ca/oracle/server.101/b10734/rcmasm.htm#1014927

This one assumes you have lost your ASM as well... if you still have your ASM, the restore process is similar though.
0

Featured Post

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

696 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