Operating System - HP-UX
1748069 Members
4997 Online
108758 Solutions
New Discussion юеВ

Re: Copy the Database Filesystem

 
vinay_26
Advisor

Copy the Database Filesystem

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.
5 REPLIES 5
Steven E. Protter
Exalted Contributor

Re: Copy the Database Filesystem

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Ganesan R
Honored Contributor

Re: Copy the Database Filesystem

Hi Vinay,

DD will be fast.

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

Best wishes,

Ganesh.
James R. Ferguson
Acclaimed Contributor

Re: Copy the Database Filesystem

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...
vinay_26
Advisor

Re: Copy the Database Filesystem

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.

James R. Ferguson
Acclaimed Contributor

Re: Copy the Database Filesystem

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...