You loss one datafile and DB is running in ARCHIVELOG mode. You have full databa

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?

Question Posted / anuroop

2 Answers
4472 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

You loss one datafile and DB is running in ARCHIVELOG mode. You have full database backup of 1 week ..

Answer / itnowtraining@hotmail.com

Restore the datafile from full backup and then apply media recovery to make it current. You will need the partial backup plus all archive log's.

Is This Answer Correct ?

3 Yes

0 No

You loss one datafile and DB is running in ARCHIVELOG mode. You have full database backup of 1 week ..

Answer / krishna

before take the backup you need to spicy the which backup is preferred and rman backup is preferred why bcoz the data base is in running stage ....

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Database Management Interview Questions

What does clipper stand for?

0 Answers

Hi all...How are you doing...? I hope all are doing fine.Now i am working as a Technical Support Admin in Australian based marketing company.I am a MCA degree holder.Now i want to do OCA & OCP course.After finishing this course sucessfully i have an opportunity in Dubai.So please tell me the best books for the above course and what's the procedure for write the exam and receive a certificate....plzzzzzzzzzzzzzzzzzzzz

1 Answers

What are the functions of database management system?

0 Answers

Can we update table which is created from view?

2 Answers IBM, Punjab National Bank,

Enlist the types of cursor?

0 Answers

Which database is used by google?

0 Answers

What are the features of openedge features?

0 Answers

What are the partitions types available in Oracle10g. How it will do? Simple example?