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.
605What are the tradeoffs between many vs few indexes? When would you want to have many, and when would it be better to have fewer?
627If 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?
567What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
631Explain the wait events in statspack report 'db scattered read', 'db sequential real', 'enqueue'?
665Post New Oracle DBA (Database Administration) Questions
What is the finger command?
How can you determine if an oracle instance is up from the operating system level?
What is the purpose of the grep command?
How can you find your id on a system?
How can you find out how many users are currently logged into the database?
What is oracle full backup?
How can you determine the number of sqlnet users logged in to the unix system?
Are database administrators in demand?
How do you prevent output from coming to the screen?
What is your favorite tool for day-to-day oracle operation?
List five most important parameter in 9i affecting performance?
What does >> do?
What is dump destination? What are bdump, cdump and udump?
Who is a database user?
How do you set up tablespaces during an oracle installation?