- 3,708,780 Users
- 2,241,126 Discussions
- 7,840,613 Comments
Forum Stats
Discussions
Categories
- 22 Industry Applications
- 3.2K Intelligent Advisor
- 4 Insurance
- 746 On-Premises Infrastructure
- 251 Analytics Software
- 21 Application Development Software
- 1.7K Cloud Platform
- 700.4K Database Software
- 17.4K Enterprise Manager
- 4 Hardware
- 107 Infrastructure Software
- 70 Integration
- 45 Security Software
What will happen to Oracle DB, if the server gets crashed, and data in MEM is gone?
User_FMXJH
Posts: 207 Blue Ribbon
in Oracle Linux
If I the server gets crashed and assuming there is no any protection for data in the memory, data will then be lost.
What problems it will pose to Oracle DB, and is there any risk (and why) the DB may not be brought up after the server gets restored?
Thank you for your messages!
0
Answers
Ideally if you are able to restart database after a server crash then only Cache data is lost which is not a major issue.
But due to some abrupt shutdown you are not able to restart database and it is stating that it need recovery then in that case you are facing instance recovery scenario.
For recovering database you have to use latest rman backup along with archivelog files.