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
- 4345 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 types of database?
Explain vdl (view definition language)?
Explain the use of assign statement in progress database?
5) Which acid property will effect when we use commit in trigger?
What is data management process?
What are the various kinds of interactions catered by dbms?
What is a system concept?
What is bcnf in the dbms?
What do you understand by the view and mention the steps to create, update and drop a view?
What is a distributed database system?
What is a Data Warehouse and How is it Different from a Traditional Database?
Is it possible to modify a Datatype of a column when column contains values?
-
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)
