Recover database

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
hussainkhan22Asked:
Who is Participating?
 
arnoldConnect With a Mentor Commented:
http://www.orafaq.com/wiki/Oracle_database_Backup_and_Recovery_FAQ
There are backup agents/client i.e. TSM, bacula, etc.
0
 
Aaron ShiloConnect With a Mentor Chief Database ArchitectCommented:
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
 
gopiseraConnect With a Mentor Commented:
Please find  [the check list]   below attachment for some backup and recover list.

BackupAndRecoveryChecklist.pdf
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Geert GOracle dbaCommented:
that all depends on what backup you took
0
 
hussainkhan22Author Commented:
We have hot backup and cold backup
0
 
slightwv (䄆 Netminder) Commented:
>> 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
 
hussainkhan22Author Commented:
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
 
slightwv (䄆 Netminder) Commented:
If none of the links above help you I suggest you refer to the backup and recovery guide in the online docs.
0
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.