Solved

Recover database

Posted on 2011-03-05
10
390 Views
Last Modified: 2013-12-19
Hey I was requested to test all the recovery senarios for hotbackup and cold backup. I would appreciate if anyone could provide the nice and easy documentation for it
0
Comment
Question by:hussainkhan22
10 Comments
 
LVL 77

Accepted Solution

by:
arnold earned 125 total points
ID: 35044822
http://www.orafaq.com/wiki/Oracle_database_Backup_and_Recovery_FAQ
There are backup agents/client i.e. TSM, bacula, etc.
0
 
LVL 15

Assisted Solution

by:Aaron Shilo
Aaron Shilo earned 125 total points
ID: 35045135
i would recomend you to use ORACLE BY EAMPLE and then implement on your system.

check this : http://st-curriculum.oracle.com/obe/db/10g/r1/2day_dba/backup/backup.htm
0
 
LVL 3

Assisted Solution

by:gopisera
gopisera earned 125 total points
ID: 35045778
Please find  [the check list]   below attachment for some backup and recover list.

BackupAndRecoveryChecklist.pdf
0
 
LVL 37

Expert Comment

by:Geert Gruwez
ID: 35046005
that all depends on what backup you took
0
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 

Author Comment

by:hussainkhan22
ID: 35046776
We have hot backup and cold backup
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35048207
>> test all the recovery senarios

There is really no way to test 'all' scenarios.  Typically disaster recovery plans have documented test plans.

I would check with your employer to see what tests they want to cover.
0
 

Author Comment

by:hussainkhan22
ID: 35048777
I mean recover if datafile (system datafile and regular datafile), redo logfile, archive logfile, controlfile missing and if full database crashed from cold backup and hot backup. I really appreciate your help. Thanks for your time and help in advance
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
ID: 35048877
If none of the links above help you I suggest you refer to the backup and recovery guide in the online docs.
0
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 125 total points
ID: 35056460
Here's the Backup and Recovery online documentation from Oracle.  It should be able to walk your through what you need:

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/toc.htm
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Linux tcp ports listening for testing 4 47
AWS CLI - Issue with name display 2 51
php ssh2_scp_send 1 49
Oracle 10g standard edition server with 4 processors 3 38
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
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…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

867 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

20 Experts available now in Live!

Get 1:1 Help Now