Re: [foxboro] ufsdump, tar or cpio?

That depends, ufsdump understands ufs filesystems only and is really good for 
interactive restores of user files. This is not really applicable for Oracle 
files as there are a small number of large files. Does the job nicely though.

Tar & cpio are certainly reliable enough, so any of the three are Ok.

Of course this assumes that you are not using Oracle with raw devices. You need 
something like dd in this case.

There is another alternative to minimise your outage time during a cold backup.

Disk space is very cheap these days. A set of backup disks, either attached to 
the Oracle server or attached to another server) could keep a set of cold files 
with the files synchronised with rsync.

Rsync would only copy the bytes inside the Oracle files that have changed and 
so 
can be very quick to take an image of your Oracle files (seconds instead of 
hours) then restart your database. These offline images can then be backed up 
at 
your leisure.

I would suggest a linux backup box with a 60-100GB ide disk as performance of 
the box or disks is not an issue. The linux box can be used to backup many 
filesystems as rsync is designed to mirror filesystems.

Rsync is GPL and freely available.


Regards
Darryl Bond



Varsha Savyasachi wrote:
> Hi, 
> Which of the three - cpio, tar or ufsdump/ufsrestore is the most reliable
> Solaris backup command for Oracle cold backups? Any other commands available
> ? What are the advantages & disadvantages in terms of time, resources,
> simplicity, reliability ?
> thanx 
> Varsha 
> 
> 
> 
> 
> 
> 
>  
>  
> _______________________________________________________________________
> This mailing list is neither sponsored nor endorsed by Invensys Process
> Systems (formerly The Foxboro Company). Use the info you obtain here at
> your own risks. Read http://www.thecassandraproject.org/disclaimer.html
>  
> foxboro mailing list:             http://www.freelists.org/list/foxboro
> to subscribe:         mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
> to unsubscribe:      mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave
>  


 
 
_______________________________________________________________________
This mailing list is neither sponsored nor endorsed by Invensys Process
Systems (formerly The Foxboro Company). Use the info you obtain here at
your own risks. Read http://www.thecassandraproject.org/disclaimer.html
 
foxboro mailing list:             http://www.freelists.org/list/foxboro
to subscribe:         mailto:foxboro-request@xxxxxxxxxxxxx?subject=join
to unsubscribe:      mailto:foxboro-request@xxxxxxxxxxxxx?subject=leave

Other related posts: