Home » Other » Training & Certification » recovery faq (linux, oracle 9i)
recovery faq [message #313884] Tue, 15 April 2008 00:48 Go to next message
tannad
Messages: 43
Registered: January 2008
Location: mumbai
Member
Hi I have some recovery faq's
can u tell mi the solutions regarding following..

1>A database is running in ARCHIVELOG mode since last one month. A datafile is added to the database last week. Many objects are created in this datafile. After one week this datafile gets damaged before you can take any backup. Now can you recover this datafile when you don't have any backups? how?

2>Only some blocks are damaged in a datafile. Can you just recover these blocks if you are using RMAN? how?

3>You loss one datafile and DB is running in ARCHIVELOG mode. You have full database backup of 1 week old and partial backup of this datafile which is just 1 day old. From which backup should you restore this file? How?
Re: recovery faq [message #313889 is a reply to message #313884] Tue, 15 April 2008 01:14 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
User-Managed Media Recovery Scenarios
Recovery Manager User's Guide
Recovery Manager Reference

Regards
Michel
Previous Topic: Schema Compilation
Next Topic: views and corelated queries
Goto Forum:
  


Current Time: Thu Mar 28 14:09:22 CDT 2024