| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Multithreaded ksh cold backup script needed
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
/parent_dir
/ORACLE_SID1 files to backup /ORACLE_SID2 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 command.
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.
 |
 |