With RMAN automatic backup script, and automatic copy of the backup file to other machines last write a batch backup script with exp, the response is good, see: http://www.cnoug.org/viewthread.php? Tid = 20864
Encouraged by this, the RMAN script for maintaining the product database will be contributed this time.
This script has more impact than the previous one.
A brief introduction is as follows:
Background:
At present, many product databases need to be maintained and must be 24 × 7, with a large amount of data. In addition, some databases are RAC databases. In this case, the advantages of RMAN backup are shown. This is also the backup method recommended by Oracle. In most cases, tape or tape library is required for backup, which requires a high investment. Is there a way to back up tape or tape library?
Try the method described in this article? It will satisfy you!
Script Function:
You can use RMAN to back up the database and automatically copy the backup files to other machines. In addition, only archived logs can be backed up on a regular basis. In this way, we can achieve this requirement. Even if the machine where the database is located crashes, all the hard disk data is lost, and only some time of data is lost. In the early stage, logs are archived at specified times, and the log_checkpoint_timeout parameter is set in the database. Of course, if the control file, online log file, and tablespace file are not lost during database crash, this backup script can be used to recover to the collapse point.
This backup method can replace tape library and tape backup, and is more efficient.
Usage:
Decompress the downloaded package to any directory. 'Readme.txt'
Prerequisites:
This script uses the SCP command, so you need to set the password-less login function between the backup server and the database server.
Read this script using the shell programming capability in UNIX
/Files/jimeper/rman_backup_script.rar