Re: (REPOST) Backup Script

In article <1994Feb3.101047.68783_at_ucl.ac.uk>, andrew_at_dcs.bbk.ac.uk (Andrew Watkins) writes:
> Reposting this since, I forgot the OS (Thanks grant_at_ca.triumf.erich).
>
> I want to start doing backups of a oracle database , since
> there are many people who have already done scripts using
> the oracle export command. I thought I try here, before
> doing anything!!!
>
> We are running Oracle Version 6.0.36 on SunOS 4.1.3.
>
> Thanks in advance
>
> Andrew

I just got done developing some c-shell and SQL scripts for a Solaris 2.3 machine running ORACLE7 that:

	Uses the oratab file to drive which instances to prepare for backup
	If the instance is archiving, sets begin backup for all tablespaces
	If the instance is not archiving, shuts it down.
	Backs up all volumes using ufsdump
	For the archiving instances,
		sets end backup
		switches the logfile
		backs up the control file
	Starts up the instances that we shut down
	Uses ufsdump to back the archived log files

There are a number of c shell and SQL scripts involved. If you are interested in them, send me a mail note and I'll mail them to you. I would think that you should be able to use them under Sun OS and ORACLE 6.

-- 
Bob Swisshelm                | swisshelm_at_Lilly.com     | 317 276 5472
Eli Lilly and Company        | Lilly Corporate Center  | Indianapolis, IN 46285