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 is data modelling concepts?
Differentiate table scan from index scan.
What is the example of rdbms?
What are the advantages and disadvantages of views in the database?
What is database schema in dbms?
What is index hunting?
What is the difference between star flake and snow flake schema?
What is variable dbms?
What are the functions of a database?
What is an image database?
What is rdbms and also explain its components?
Give the cobol definition of a varchar field 177 when can an insert of a new primary key value threaten referential integrity?
Explain types of indexing in dbms?
What are different types of joins in the sql?
What are the integrity rules in dbms?