Re: Logical log backups to non-rewind tape device

Theoretically, I don't see anything wrong about using no-rewind devices. But consider this. Assuming that your system has restarted 3-4 times since you inserted the tape, this means that your logical logs will now be written to segment 3 or 4 of your tape. Assume also that you have done a level 0 archive on your database while your logs were backed up on tape segment 3. Now if your system crashes so badly at this point that you need to restore this recent archive, you would now require the logs from segment 3 onwards. This means that you would have to rewind the tape, and use dd to forward the tape the segment 3. This could be very time-consuming, not to mention that you would have to know which segments your logical logs are on at any time. You might want to test this scenario out before you make your decision. Alvin In article <865975364.30251@dejanews.com>, stiglich@promarkone.com wrote: >I am thinking about using a no rewind tape device name for >backing up our logical logs because whenever we have to bounce >the instance a new tape needs to be put in. Does anyone do this >sort of thing? Any possible pitfalls? > >Thanks > >Pete > >-------------------==== Posted via Deja News ====----------------------- > http://www.dejanews.com/ Search, Read, Post to Usenet -- *-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-*-* Alvin Koh <AlvinKoh@WriteMe.COM> ...Today's dreamers are tomorrow's achievers....ZZZZZZZZZZZ.... ($$$)-($$$)-($$$)-($$$)-($$$)-($$$)-($$$)-($$$)-($$$)-($$$)-($$$)