Raw data backup

[José Enrique González]

Hi:

I need to perform a full backup of logical volumes used as Oracle raw partitions, in order to migrate the database to another mass storage. Unfortunately, I don´t have the same backup tools available on BOTH origin and destination (Omniback, NetBackup). Could any HP tool could help to do this job safely? Thanks in advance for your comments.

Jose Enriqu

[Stephen Keane]

If Oracle is completely shut down, you could dd the raw partitions. I'd start the server in single user mode to be sure. Test the new configuration before irreversibly changing the old configuration if at all possible.

[harry d brown jr]

fbackup

or

dd

live free or die
harry d brown jr

[Peter Godron]

Jose,
whenever raw partitions are involved I use dd for moving data.
Others may have more user-friendly solutions ....?
Regards

[José Enrique González]

Does dd perform volume control, i.e. in the case I need more than one tape to hold the backup?

[A. Clay Stephenson]

dd has no concept of volume control however by specifying blocksize (bs or ibs) and using the "skip" option in combination with the "count" option, you can split the input file into chunks. Similarly there is a "seek" option which can be used for output.

[harry d brown jr]

You are migrating this from one HP-ux system to another HP-ux system, correct??

live free or die
harry d brown jr

[José Enrique González]

In fact, I have to move the same servers to another datacenter and migrate data to a different mass storage in destination.

[Peter Godron]

Jose,
if you are going to move the data to another machine, can't you just export/import the tablespaces?
Regards

[José Enrique González]

Yes, in normal condition this should be the way. But, for any reason, export form the database can not be completed due to a huge table with many LOB fields. Because of that, I am trying to avoid this method.