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?
Answers were Sorted based on User's Feedback
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 |
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 |
How do you create a report in a database?
What is join? Mention its types.
Explain what is meant by asymmetrical protocols?
Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?
write a query to retrieve the last day of next month in oracle.
Define a relation schema and a relation.
Define b-trees.
Can you copy the PROGRAM UNIT into an Object group ?
What is a table called in database?
What is a RADIO GROUP ?
What are the differences between a dbms and rdbms?
What do you understand by proactive, retroactive and simultaneous update?