Home » Other » Training & Certification » recovery faq (linux, oracle 9i)
recovery faq [message #313884] Tue, 15 April 2008 00:48 Go to next message
Messages: 43
Registered: January 2008
Location: mumbai
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: 64944
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
User-Managed Media Recovery Scenarios
Recovery Manager User's Guide
Recovery Manager Reference

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

Current Time: Thu Jun 22 17:25:41 CDT 2017

Total time taken to generate the page: 0.10542 seconds