Re: ORACLE Hot Backups and Recovery

"G.K.Subramanian" <gks_at_mailbag.com> wrote:

>As a result of this, the restore process takes a very long time.
>The tape device has to rewind everytime, since it uses a
>separate 'cpio' command for each file that is backed up.
>This is against the process where you would have all the
>files in a single directory and back it up.
 

>GK Subrahmanian
>Foremost Farms USA
>gks_at_mailbag.com

You are most likely using the 'rewind' device when making the backup. You need to use the no rewind device.

ie:

say the rewind device is /dev/rmt/2
then, the no-rewind device is /dev/rmt/2n

rewind your tape

        mt -f /dev/rmt/2 rewind

backup your file(s)

        cpio <options here> /dev/rmt/2n

rewind tape

        mt -f /dev/rmt/2 rewind

do the same when restoring. that is, use the no-rewind device.

Jared Still, Oracle DBA
RxNet, Division of Value Health
"All opinions are mine, not my employers" jared_at_valleynet.com Received on Thu Jun 27 1996 - 00:00:00 CEST