There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?
- 1 Answers
- 2205 Views
- I also Faced
- E-Mail Answers
Answer / Jagesh Kumar
In a database recovery scenario where a datafile is deleted and archive logs are corrupted, it's essential to first recover the missing datafile from backup. Once the datafile is restored, you can apply the archive logs up to the point where corruption occurred (log 50 in this case), then restore from a backup taken after log 50, or use a standby database if available. The recovery process should be able to proceed beyond the corrupted logs as long as a clean backup exists after the last good log.
| Is This Answer Correct ? | 0 Yes | 0 No |
How do you rename a database?
What are five main functions of a database administrator?
What is hot backup and how it can be taken ?
Define join types.
What is ims software environment?
What is the use case where we can use stretch database?
Have you written applications to retrieve stored images in a table?
what is the difference between unique and primary key
What is second normal form?
How many rows can a database hold?
Mention the types of join?
Can we attach the same List of Values to different fields in Design time ?
-
Oracle (3253) - 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)
