What is the most important action a dba must perform after changing the database from noarchivelog to archivelog?
Answer / Aakash Bajpai
The most important action is to immediately take a backup of the control file and archive logs. This ensures that you have a recoverable copy of the database in case of any failures.
| Is This Answer Correct ? | 0 Yes | 0 No |
What os user should be used for the first part of an oracle installation (on unix)?
What is the difference between cold backup and hot backup?
When configuring sqlnet on the client what files need to be set up?
What is dump destination? What are bdump, cdump and udump?
How can you find out how many users are currently logged into the database?
What do you mean by oracle dba?
What does the no logging option do? Why would we use it? Why would we be careful of using it?
Explain procedure to change characterset of a database.
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.
When should the default values for oracle initialization parameters be used as is?
What skills does a dba need?
Explain the various modes of normalization?