topic Re: Copy the Database Filesystem in Operating System - HP-UX

Copy the Database Filesystem

vinay_26 — Fri, 27 Mar 2009 12:16:34 GMT

Hi,

We have a SAN migration and need to copy a 300 GB Database file system that needs to be copied to a new filesystem on a different disk.

Fbackup would be more reliable i beleive. Please suggest.

Re: Copy the Database Filesystem

Steven E. Protter — Fri, 27 Mar 2009 12:23:58 GMT

Shalom,

fbackup would definitely be reliable if the database was shut down.

Also scp -p

dd

cp (if its on the same system or the target is available via NFS)

If the file system is on SAN based storage SAN utilities might be the quickest way to get the job done.

SEP

Re: Copy the Database Filesystem

Ganesan R — Fri, 27 Mar 2009 12:25:28 GMT

Hi Vinay,

DD will be fast.

# dd if=/dev/vgold/lv of=/dev/vgnew/lv bs=1024 conv=sync

Re: Copy the Database Filesystem

James R. Ferguson — Fri, 27 Mar 2009 12:28:06 GMT

Hi:

While 'fbackup' and 'frecover' are certainly one way, I like 'pax'. See my responses in this thead (both the first and second ones):

http://forums.itrc.hp.com/service/forums/questionanswer.do?threadId=1307541

Regards!

...JRF...

Re: Copy the Database Filesystem

vinay_26 — Fri, 27 Mar 2009 14:08:54 GMT

Hello James,

pax does look like a useful tool but saw some warnings as well.

WARNINGS
Because of industry standards and interoperability goals, pax does not
support the archival of files larger than 2GB or files that have
user/group IDs greater than 60K. Files with user/group IDs greater
than 60K are archived and restored under the user/group ID of the
current process.

Re: Copy the Database Filesystem

James R. Ferguson — Fri, 27 Mar 2009 14:15:12 GMT

Hi (again):

If you are on 11.23 or 11.31 the old limitations of 'pax' have been lifted:

http://h20392.www2.hp.com/portal/swdepot/displayProductInfo.do?productNumber=PAX-ENH

Regards!

...JRF...