Script for automatic backup using RMAN

Source: Internet
Author: User
Tags scp command
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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.