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?
No Answer is Posted For this Question
Be the First to Post Answer
What are the Different Types of Joins and How do They Work?
Enlist some commands of dml?
How to debug stored procedures?
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?
What is data independence and also explain its types?
What is dbms and its functions?
How is data stored in a relational database?
What do you understand by fragmentation?
What is meant by a database?
Are databases stored on servers?
What do you mean by deadlock dbms?
What is rank in database?
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)