A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.
303What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?
341If you had a tablespace, test_tablespace, which consists of three files:test01.dbf, test02.dbf, and test03.dbf, and someone accidentally used the unix command"rm" to delete the file test02.dbf, what else would you need in order to recover all the data thatwas present in test_tablespace at the time that test02.dbf was deleted?
295What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
263Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?
375Post New Oracle DBA (Database Administration) Questions
How do you set up tablespaces during an oracle installation?
How many types of dba are there?
System tablespace cant be exported from one database and imported into another why?
What is the difference between truncate and delete? Can we rollback both? How would a full table scan behave after?
What is pct free/pct used/pct increase parameter in segment?
How can you find all the processes on your system?
How much money does a dba make?
Why do we need a database?
What does database administrator do?
What happens if the constraint name is left out of a constraint clause?
What does the no logging option do? Why would we be careful of using it?
How can you tell if an index on particular table is used or not used in 9i?
What does dba stand for in technology?
What is a dba programmer?
What is the difference between truncate and delete? How would a full table scan behave after?