Hi Allessandro There is nothing wrong with backing up directly to tape like you are doing as long as you understand your tape management and can recover all the datafiles for a tablespace when you need them I am guessing your backup script does something like Login to the database Checkpoint the database Take the tablespace offline and place it into backup mode Then backup each datafile to tape (standard VMS tools ) Take the tablespace out of backup mode and put the tablespace back on line Complete steps again for each tablespace. If this is so then the procedure is generally sound but I would say you really need to test your recovery abilities by restoring to a different location or server to determine that you can restore, because when it breaks and you cant restore then I hope your resume is up to date. I would also be pressuring your management to spend some money on the VMS server or alternatively planning your migration off to some other platform. You need more space and you could always be using an NFS mount to right your backups to albeit it may be slow depending on other circumstances. Mind you I would rather have slow and recoverable over fast and finding a new job because I cant restore my database. Cheers Peter > -----Original Message----- > From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] > On Behalf Of Alessandro Vercelli > Sent: Friday, November 17, 2006 6:38 AM > To: Oracle Freelists.org > Subject: Hot backup directly on tape? > > Hi everybody, > I wrote an SQL script to perform hot backup of db on a VMS platform. > > This is a well-known technique, but on system there isn't space available > neither expandable for backup on disk before putting it on tape, so I > thought to backup each datafile directly to tape; is this correct or my > backup sets will be unusable? > > Apart from Legato, I've no previous practice of db backup directly to tape, > particularly on VMS; I believe that this platform is not much different > from Unix for this specific topic, but I could be wrong. > > Has anybody some suggestion and/or experience to tell about? > > Thanks for you help, > > Alessandro > > > > > > ------------------------------------------------------ > Scopri MOTOROLA K1, la nuova icona di design Motorola.Clicca e vinci ! > http://click.libero.it/motorola16nov > > > -- > //www.freelists.org/webpage/oracle-l > -- //www.freelists.org/webpage/oracle-l