What will happen to Oracle DB, if the server gets crashed, and data in MEM is gone? — oracle-tech

    Forum Stats

  • 3,708,780 Users
  • 2,241,126 Discussions
  • 7,840,613 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

What will happen to Oracle DB, if the server gets crashed, and data in MEM is gone?

User_FMXJHUser_FMXJH Posts: 207 Blue Ribbon

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!

Answers

  • Sunny kichlooSunny kichloo Posts: 2,412 Gold Trophy

    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.

Sign In or Register to comment.