Backup Script

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 16 Jul 2002 13:31:44 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7025FA285@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 - 07:31:44 CDT