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?
1688You 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 3113user 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 2388Post New Database Management Questions
Explain by listing some major advantages of dbms.
i have a web page and in this page i create 3 textbax and a "summit" button do you have any html code for add text velue in my web page like link summation(form) sites.
Why do we need database management?
Define database system.
What are the disadvantages of file processing systems?
What do you understand by cursor?
Does google have a database program?
Explain atomicity and aggregation?
Explain the terms ‘attribute’ and ‘relations’
What is the biggest advantage of rdbms?
How do I create a database in access 2010?
What is the role of database server in database management system?
How do I convert a spreadsheet to a database?
What is sorting in dbms?
What is default value database?