Re: Backup Script

That can sometimes be a l-o-n-g wait Norman!!!!

But thanks for that precis of it, too.

And yes, he's worked out that TEMP and Rollback tablespaces aren't the same thing, and so has put the latter back in!

Regards
HJR "Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA7025FA285_at_lnewton.leeds.lfs.co.uk...
> Guys,
>
> my shell scripting isn't great either, but I've had a read. It basically
> goes like this :
>
> for each datafile
> if not readonly
> put the tablespace into backup mode
> copy the file
> take the tablespace out of backup mode
> end if
> end for
>
> So the tablespace goes in and out of backup mode for each and every
> datafile making it up.
>
> Someone else already mentioned the rollback (Niall ?) files not being
> backed up.
>
> But it's not a bad script for something that was knocked up on the fly
> while waiting for Howard to get to an interesting bit :o)
>
> Regards,
> Norman.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>
Received on Tue Jul 16 2002 - 15:18:25 CDT