Solved

recover database

Posted on 2010-11-30
6
461 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
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 34

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 500 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Fine Tune your automatic Updates for Ubuntu / Debian
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…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

829 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