You get a call from you backup dba while you are on vacation. He has corrupted all of the control files while playing with the alter database backup controlfile command. What do you do?
- 1 Answers
- 685 Views
- I also Faced
- E-Mail Answers
Answer / Nizam Miyan
If the control files are corrupted, the database becomes unusable. To recover, you can restore a good copy of the control file from a backup using the 'Recovery Manager' (RMAN) or manually by performing a 'CRS Control Recovery'. It's crucial to ensure regular backups and test your recovery procedures.
| Is This Answer Correct ? | 0 Yes | 0 No |
How many control files should you have? Where should they be located?
What is the use of the drop option in the alter table command?
What skills do you need to be a database administrator?
What os user should be used for the first part of an oracle installation (on unix)?
What skills should a dba have?
Is oracle dba in demand?
What happens if the constraint name is left out of a constraint clause?
The system administrator tells you that the system has not been rebooted in 6 months, should he be proud of this?
How to uncatalog backup?
How do you prevent oracle from giving you informational messages during and after a sql statement execution?
What database block size should I use?
Are database administrators in demand?
Oracle General 
