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
- 4179 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 the advantages of database?
What is a candidate key in dbms?
Explain the different types of languages that are available in the dbms?
What is Database testing and What are ways of writing test cases for database testing?
What is a system concept?
What is maintaining database?
What is procedure in database?
What exactly is a database?
What is the main purpose of normalization?
What is SQL FORMS ?
What is rdbms architecture?
Explain the Difference Between a Primary Key and a Foreign Key.
-
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)
