BMR backup best practice
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.
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
