?
Solved

recover database

Posted on 2010-11-30
6
Medium Priority
?
464 Views
Last Modified: 2012-05-10
To recover an Oracle Database in a non-RMAN environment.
One way to do this would be to physically recover the database to an identical server as you would do for DR, but we don't want to go down that route.

The question is " do you have a proven procedure to demonstrate that a backup is recoverable for non-RMAN managed databases". The account needs to show that it is using a tried and tested backup/recovery procedure.
0
Comment
Question by:hussainkhan22
[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
6 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34239383
To recover, first you need to back up.  If you didn't use RMAN to back up, how did you back up the database?  We cannot help you with recovery unless we know how you backed it up.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34239399
also: The backup method depends on your recovery requirements.  For example: How much potential data loss is acceptable?
0
 
LVL 35

Expert Comment

by:johnsone
ID: 34241543
If your question is simply how do I verify my backup then I would say restore it.  Even if you are using RMAN, the only way you can be comfortable with your backup and restore procedures is if you go through the whole process beginning to end.

One thing you can do is to run dbv (aka dbverify) on each of the data files if they are stored on disk some where.  Or, you could restore a group, verify them, then restore another group.  That could give you a comfort level that they are valid as far as Oracle is concerned.  HOWEVER, that does not mean that you can recover your database.  In my opinion, the only way to truly prove if you backup is working is to restore it and bring it up.  Then point the application at it and see if everything is working.
0
 
LVL 1

Expert Comment

by:fhsyed
ID: 34247499
If u are saying for crash recovery and other scenarios where backup does not include RMAN but logfiles, datafiles and control files which are to be used for recovery. I follow a proceedure/ test case study step-by-step guide which i will be glad to email you.
If this is the case, Kindly leave me a mail at my address and i will send u the file .
<email address removed by slightwv 12/1/2010>.
0
 
LVL 5

Accepted Solution

by:
anand_20703 earned 2000 total points
ID: 34282782
Question : do you have a proven procedure to demonstrate that a backup is recoverable for non-RMAN managed databases". The account needs to show that it is using a tried and tested backup/recovery procedure.
Answer : Yes.
Method 1 : Online database backup other than RMAN. ( Before RMAN was introduced in Oracle Database Engine, Online backups were used.
Method 2 : Offline database backup other than RMAN.
.
Both these methods proven,tested,working methods excluding the RMAN feature.
Lot of doumentation is available . check it out
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

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.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses
Course of the Month14 days, 22 hours left to enroll

770 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