Featured Posts

Friday, October 15, 2010

Cold Backup–DB Quiesce State…

 

Oracle Documentation says


Note:

You cannot perform a cold backup when the database is in the quiesced state, because Oracle Database background processes may still perform updates for internal purposes even while the database is quiesced. In addition, the file headers of online datafiles continue to appear to be accessible. They do not look the same as if a clean shutdown had been performed. However, you can still take online backups while the database is in a quiesced state.

 


I was thinking what would be link between the Cold Backup and Database quiesced state of database. Since, as ever one knows that  “A cold backup, that is, one done with the database in a shutdown state”.

My question was why Oracle was stated across that statement (or)  does the any background process still persists if I keep my DataBase in Quiesce state and it’s shutdown with NORMAL mode.

Any guesses..??

Since, oracle suggesting to go for ONLINE Backups, instead of COLD Backups.

I am still debugging this.. !!


Digg Google Bookmarks reddit Mixx StumbleUpon Technorati Yahoo! Buzz DesignFloat Delicious BlinkList Furl

0 comments: on "Cold Backup–DB Quiesce State…"