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?
2121You 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 4336user says the db performance is slow or yesterday the query runned 1min and today its taking 30 min. how to trouble shot or were to start with?
HCL,
1 3093Post New Database Management Questions
Explain snapshot replication.
How to activate all indexes in firebird?
Explain types of indexing in dbms?
What is the relationship?
What are the five important software components of a database management system?
Define join and enlist its types.
What do you understand by the terms entity, entity type, and entity set in dbms?
How do you performance tune a database?
What is view dbms?
Explain the concepts of a primary key and foreign key.
How can we check whether A S M instance is up or down?
What are the advantages of using Query Strings?
Do I need ccp4?
What is the best way to determine whether firebird server is running?
What is advantages of progress actional?