topic Re: Raw data backup in Operating System - HP-UX

Raw data backup

José Enrique González — Tue, 25 Jan 2005 09:41:33 GMT

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

Re: Raw data backup

Stephen Keane — Tue, 25 Jan 2005 09:44:16 GMT

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.

Re: Raw data backup

harry d brown jr — Tue, 25 Jan 2005 09:45:22 GMT

fbackup

or

dd

live free or die
harry d brown jr

Re: Raw data backup

Peter Godron — Tue, 25 Jan 2005 09:45:34 GMT

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

Re: Raw data backup

José Enrique González — Tue, 25 Jan 2005 09:47:29 GMT

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

Re: Raw data backup

A. Clay Stephenson — Tue, 25 Jan 2005 09:54:29 GMT

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.

Re: Raw data backup

harry d brown jr — Tue, 25 Jan 2005 10:04:17 GMT

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

live free or die
harry d brown jr

Re: Raw data backup

José Enrique González — Tue, 25 Jan 2005 10:22:09 GMT

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

Re: Raw data backup

Peter Godron — Tue, 25 Jan 2005 10:25:31 GMT

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

Re: Raw data backup

José Enrique González — Tue, 25 Jan 2005 10:45:21 GMT

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.