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
how to restore particular schema from rman full backup?
What are the applications of database management system?
What do you mean by conflict serializability in dbms?
Explain Enterprise Resource Planning (ERP), and what sort of a database is utilised in an ERP application?
What is computer end?
Define identity and uniqueidentifier property of column?
What is the purpose of reports in a database?
1.If we have a Salary coloumn in Staff entity with this description the salary must be monetary and >=$35450.00, how we can write it in into schemain SQL? 2. If we have Weight and Marks in Assessment entity and the Weight has the description of this it must be Non-zero percentage. And also the Marks attribute stores the maximum possible raw mark for assessment (e.g., 30), while Weight stores of the weight of this assessment for the paper as a whole (e.g., 10%). If Marks is not specified, then Weight is used for both. How we can convert this into schema in SQL????
how to generate an auto incremental number in a ssis package?
What is a checkpoint in dbms and when does it occur?
How many types of database languages are?
What is second normal form?
If I use netlib, will I find many other users to network with?
Is dynamodb a document database?
What is the data in a database?