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?
Answer Posted / 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 |
Post New Answer View All Answers
What's the difference between file and database? Can files qualify as a database?
What is the purpose of a database middleware other than translating the jdbc api calls to multiple vendor specific dbms calls?
What are the different types of data tables?
Differentiate nested loop, hash join and merge join.
Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?
How do queries work in a database?
What are five advantages of a database?
what is storage manager?
What are the different types of DBMS architecture?
What is dbms and types of dbms?
Define entity.
What is 'cross join'? Or what is cartesian product?
Which database is best for large data?
Which parameters are optional in init.ora parameter file?
What is database management system explain?