« Why Oracle Is So Important | Main | Oracle Backup: Which Snapshot is best? (Part 2) »

July 23, 2007


Peter Gram

Hi Jeff

To my best knowledge the Oracle database will only write the full data block to the redo log on the first change after it is brought into the SGA and thereafter it will just write the normal redo changes.
I think you are making a simplification on how Oracle treats blocks in hot backup mode, the simplification might not have impact on your quest but I still think the prerequisites are important


Rama Nouduri

If I take a Snapshot of my database 1TB ...whcih took 10 mon Database Down tme ...

Can I restore a table/ an database object from this snap after the database is up and running ...

if so can you explan me the logic ..

HOW a Database object can be restored / replaced from a snapshot ( netapps) to an oracle 10gR2




I would like to take backup of my production oracle database (500 GB.

Can you provide me a script for the same which could be tested for Windows Server ?




Unfortunately, I don't do Windows. :-) However. scripts to do backup on Oracle on Linux can be found here:


Powerlink access is required for this, though. If you are not an EMC customer, you will not be able to see this page unfortunately. You can adapt these scripts to Windows easily by installing cygwin. I always run cygwin on any Windows box I use, including my laptop. cygwin can be found here:


It provides a bash shell environment and other UNIX tools on Windows.


Is it possible for NetApp to just take a snapshot of a part of your database (read only tablespaces on a designated filesystem) while RMAN does the backup of all the read write tablespaces?



Not sure what you are thinking here. I rarely if ever deal with read only tablespaces, though. You would tend to back them up once, then forget about them. They are after all read only. That is, they are not going to change. Thus, you would not need any snaps of them.



Sound like you dont know much about other databases.

Read Quiesce feature on Sybase.


Response by TOSG:

Not sure where you are coming from here. I spent years working with Sybase up in Alaska building things like the Alaska Group Economic Model. I am intimately familiar with the quiesce feature in Sybase in other words.

The comments to this entry are closed.

Powered by TypePad
View Jeff Browning's profile on LinkedIn

disclaimer: The opinions expressed here are my personal opinions. I am a blogger who works at EMC, not an EMC blogger. This is my blog, and not EMC's. Content published here is not read or approved in advance by EMC and does not necessarily reflect the views and opinions of EMC.