Tell me about standby database? What are some of the configurations of it?
No Answer is Posted For this Question
Be the First to Post Answer
What is the purpose of the import option ignore? What is its default setting?
You have taken import of a table in a database. You have got the integrity constraint violation error. How you are going to resolve it.
The system has a program that always includes the word nocomp in its name, how can you determine the number of processes that are using this program?
What is a production dba?
What are the different types of database users?
You see the following on a status report: redo log space requests 23 redo log space wait time 0 is this something to worry about? What if redo log space wait time is high? How can you fix this?
Explain the term 'oracle grid architecture'?
If you see a pin hit ratio of less than 0.8 in the estat library cache report is this a problem? If so, how do you fix it?
How does one coalesce free space?
What are the steps involved in instance recovery in oracle?
What skills do you need to be a database administrator?
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.