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?
- 2 Answers
- 3158 Views
- I also Faced
- E-Mail Answers
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 is second normal form?
How big is google's database?
Explain the advantages of rdbms?
Is a database a file?
Is this statement true or false? All databases must be in third normal form?
How to open the database in exclusive mode?
Write down the differences between nosql and rdbms?
What are procedures in dbms?
What is a degree of relation?
What is openedge workgroup rdbms?
What does clipper stand for?
What is trigger in dbms?
What do you mean by starvation in dbms?
What are the advantages of rdbms?
What are different types of joins in the sql?
