cancel
Showing results for 
Search instead for 
Did you mean: 

BMR backup best practice

vinods
Level 5
Partner

Hi

I have winodws server on that having SQL , ORACLE databses.

My question is when i taking those server BMR backup that time oracle or SQL services need to be shutdown

Or If i am taking Database service online BMR  backup there any problem happen when restoration .

Pls suggest advice.

1 ACCEPTED SOLUTION

Accepted Solutions

mandar_khanolka
Level 6
Employee

You dont need to stop the DB service while taking BMR backup. Actually backup happens as NBU regular file based backup. What that means is it does not take care of database integrity.

After restore you may or may not find the database in integrity state. For example, while NB is taking backup any transaction not committed to database file might not be recorded leaving the db state in inconsistent state. In that case you might need to recover database state manually after doring BMR restore.

Many customers do use two policies to protect their database server from disaster. One is BMR enabled policy to backup whole machine and another one specific to db application (e.g. here oracle agent) to recover DB to correct state.

They first restore whole machine using BMR followed by application agent recovery to recover database.

Hope this helps.

Thanks.

-Mandar

View solution in original post

2 REPLIES 2

mandar_khanolka
Level 6
Employee

You dont need to stop the DB service while taking BMR backup. Actually backup happens as NBU regular file based backup. What that means is it does not take care of database integrity.

After restore you may or may not find the database in integrity state. For example, while NB is taking backup any transaction not committed to database file might not be recorded leaving the db state in inconsistent state. In that case you might need to recover database state manually after doring BMR restore.

Many customers do use two policies to protect their database server from disaster. One is BMR enabled policy to backup whole machine and another one specific to db application (e.g. here oracle agent) to recover DB to correct state.

They first restore whole machine using BMR followed by application agent recovery to recover database.

Hope this helps.

Thanks.

-Mandar

vinods
Level 5
Partner

Hi 

Thanks for your help.