RE: Multithreaded ksh cold backup script needed

  • From: Stephen.Lee@xxxxxxxx
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 27 Jul 2004 11:30:28 -0500

If the list supports plain text attachments, then attached is a script I
wrote to copy rman backup sets to tape via Networker (Legato).  I think it
has most of the components on your spec and would not be too difficult to
modify for your purpose.  The script has only a few comments, so it will
require a significant knowledge of ksh scripting to understand it and modify
it appropriately.  Most of the modification will involve ripping out all the
Networker stuff and replacing it with cp, tar, cpio, etc. commands.

The command line contains the parent directory of directory structure that
looks like

                files to backup
                files to backup

So the command line looks like: tape_copy.ksh parent_dir1 parent_dir2 etc.

The script looks for files to have names that match a particular pattern.

The reason for allowing multiple parent_dirs is to allow the data file
backups to go one place and the archived log backups to go to another place
so that the archived logs can easily be copied to tape immediate after the
rman backup finishes.  On the box on which this run, it takes about 8.5
hours, using 4 tape drives, to copy the data file backups to tape.  So the
archived logs get copied immediately, then the data file backups.

The script checks to see if ORACLE_SID1 matches the name of a database on
the box; if not, it assumes the directory is some ad hoc junk directory that
should be skipped.  There is no handy progress meter, however one can get an
idea of where things are by checking the log files or by using the ps

If the list doesn't support plain text attachments, then I guess this was a
wasted post.

If you do get the file OK and like it a lot, then just remember who wrote it
if I ever need a job.

Oh yeah, and the script is not guaranteed to be bug free.

-- Binary/unsupported file stripped by Ecartis --
-- Type: application/octet-stream
-- File: tape_copy.ksh

Please see the official ORACLE-L FAQ:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts: