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
- 3371 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 is the use of PARFILE option in EXP command ?
What are the four components of a database system?
What do database languages do?
How rdbms is different from dbms?
What is the use of OWNER option in EXP command ?
IF Statements BLOCK 1 . IF a >= b THEN do_this …..; ELSE do_that….; END IF BLOCK 2 . IF a < b THEN do_that …..; ELSE do_this….; END IF; • Given any pair of non-NULL values for “a” and”b”, will Block 1 and Block 2 do the same thing? • What if either “a” or”b” (or both) is NULL?
What is etl process in data warehousing? What are the different stages in 'data warehousing'?
Explain the importance of database partitioning.
What is alternate key?
What's the difference between 'union' and 'union all' ?
Why is normalisation used?
What is system r? How many of its two major subsystems?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
