Re: backup large blob file

• post for FREE via your newsreader at post.newsfeed.com ***

Thomas wrote:
> My oracle 8i's blob is already too big for cold tar backup. Is there any
> other good solution in dealing with large blob file backup?
>
> Thanks,
>
> Thomas
>
>

Thomas,
You may split your tar backup in smaller chunks using split utility:

   tar cvf - /your_source/* | split -b 1024m - your_backup_name.tar.

If your backup will be bigger then 1GB, it will create multiple files your_backup_name.tar.aa, your_backup_name.tar.ab, etc.

for restore use:

   cat your_backup_name.tar.* | tar xvf -

Before you start, check man pages about split on your system, about definition -b some systems may accept only size in bytes.

-AST  -----= Posted via Newsfeed.Com, Uncensored Usenet News =----- http://www.newsfeed.com - The #1 Newsgroup Service in the World! -----== 100,000 Groups! - 19 Servers! - Unlimited Download! =-----                    Received on Mon Aug 23 2004 - 21:31:39 CDT