Re: Hot backup to multiple tape strategy????

From: Oliver Felix Fox <off_at_Copenhagen.NCR.COM>
Date: 1997/02/24
Message-ID: <01bc226f$d36c0fc0$ba2b4699@l174>#1/1

If the question is how to hold a tablespace in backupmode as short time as possible, then you could (provided you have the tools and the space):

1. Create a mirror of the tablespaces files
2. Mark the tablespace for 'begin backup'.
3. Break the mirror
4. Mark the tablespace as 'end backup'.
5. Copy the broken mirror to tape.
--------------------------------------------------------

Oliver Felix Fox, International Oracle CoE NCR SE - Copenhagen
E-mail: Oliver.Fox_at_Copenhagen.ncr.com

Sean.Kubovcik_at_worldnet.att.net wrote in article <5eeup2$srg_at_mtinsc04.worldnet.att.net>...
> I going to perform hot backups of a database that will span multiple
> tapes. The size of the db is about 5 gig and I don't have alot of
> available space to copy to a temp directory before copying to tape. I
> was going to cpio to tape while the tablespace was in BEGIN BACKUP
> mode. I would like to know what kind of strategies are successful to
> accomplish this. I would like to have this backup complete as quick
> as possible. Any input would be appreciated.
> Thanks,
> Sean
>
>
Received on Mon Feb 24 1997 - 00:00:00 CST