Solved

recover database

Posted on 2010-11-30
6
459 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 76

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 76

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Why Shell Scripting? Shell scripting is a powerful method of accessing UNIX systems and it is very flexible. Shell scripts are required when we want to execute a sequence of commands in Unix flavored operating systems. “Shell” is the command line i…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

932 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now