OraFAQ Forum: Training & Certification

Home » Other » Training & Certification » recovery faq (linux, oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

recovery faq [message #313884]

Tue, 15 April 2008 00:48

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?

Report message to a moderator