Solved

Recover database

Posted on 2011-03-05
10
387 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 76

Accepted Solution

by:
arnold earned 125 total points
Comment Utility
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
Comment Utility
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
Comment Utility
Please find  [the check list]   below attachment for some backup and recover list.

BackupAndRecoveryChecklist.pdf
0
 
LVL 36

Expert Comment

by:Geert Gruwez
Comment Utility
that all depends on what backup you took
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 

Author Comment

by:hussainkhan22
Comment Utility
We have hot backup and cold backup
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
>> 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
Comment Utility
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)
Comment Utility
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
Comment Utility
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 Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

SSH (Secure Shell) - Tips and Tricks As you all know SSH(Secure Shell) is a network protocol, which we use to access/transfer files securely between two networked devices. SSH was actually designed as a replacement for insecure protocols that sen…
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 video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
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.

763 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