Oracle Advanced Performance Tuning Scripts

Backup Scripts

exp_split_ftp.sh

This script is Unix specific. It uses the standard method of exporting to a named pipe which is read by compress. However, instead of writing to a file, compress pipes its output to split which splits the export file into 10M chunks. Then to ensure that we do not run out of space in the local export file system, we ftp the files to the destination system as they become available.

Download script for: all versions

backup_controlfile.sql

This script uses the BACKUP CONTROLFILE TO TRACE command to save a CREATE CONTROLFILE statement, and then moves the trace file into the database creation directory.

This script is Unix specific, and depends on the trace_file_name.sql script.

Download script for: 8.1 to 9.2


Ixora Pty Ltd.   All rights reserved.
12-Oct-2007 22:22
Search   Questions   Feedback   Up   Home