Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4204 Views
- I also Faced
- E-Mail Answers
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 |
What are indexes ? What are the advantages ? (Phone Screen)
What is database url?
What are the main characteristics of database approach?
What is normalization? What are different type of normalization?
What are the components of rdbms?
Compare non-clustered and clustered index
What is meant by system analysis?
What is the best database for big data?
What is query in rdbms?
what are the different integrity rules present in the dbms?
Explain the term entity in dbms?
Why do we need database normalization?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
