What are the causes and solutions for unplanned downtime of oracle database service?
The main reason for unplanned downtime of oracle database is either data loss or server failure.
And some of the reasons for data loss includes, but not limited to:
- Data corruption
- Storage failure
- User error
- Data center failure
Server failure may also be caused by hardware such as network failure, physical machine component failure, and software failure. And database instance failure and OS crash are some of examples of software failure.
We can prevent data loss either by RAID configuration of hard disks or ASM disk group redundancy setting. And we can recover data from database backup.