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?
2117You 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 4314user 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 3087Post New Database Management Questions
What do database languages do?
Differentiate nested loop, hash join and merge join.
What do you mean by Checkbox ?
What is a string in database?
I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?
What do you know about DBMS?
What is the biggest advantage of rdbms?
Can files be stored in a database?
What is end users in dbms?
What are codd rules?
When we will denormalize data?
Discuss some of the techniques that can be used to tune operational performance.
What is the diff bet plan,package,dbrm?
Define truncate and delete commands?
What is the maximum line size that dbms_output can handle?