The recent need for a scheduled Oracle Backup program, can be restored to the latest state, reference http://blog.sina.com.cn/s/blog_7756ebc30100tnqy.html, I have in the shell processing a bit, Get 2 shell scripts, init.sh, oraclebackup.sh, execute init.sh param1 (backup file path) param2 (archive log path), you can set up a scheduled backup, the
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,
Backup is the most important. Many test environments are built on windows, and there is one on the master's computer. to ensure its security, it is decided to perform regular backup. The example shows how to use scripts + windows scheduled tasks in windows to periodically execute full backup. Backup
In an Oracle database, Rman backs up a lot of scripts, and here's a case of how a shell script can be backed up by Rman, and FTP uploads the Rman backup file and the archive log file script.
fullback.sh inside call
The RMAN backup script in Windows is relatively simple. Let's look at the content.
1.ModifyRMANRelated Parameters
RMAN> show all;
RMAN> Configure controlfile autobackup on;
RMAN> Configure controlfile autobackup format for device
Backup is a top priority for DBAs. No matter how powerful your technology is and there is no backup, you are still helpless when something goes wrong.
Here is just the BACKUP command summarized in the work. The scripts collected in the future will be continuously updated ......
1. In the RAC environment, if the archivelog of the two nodes are stored locally, how
There is an automatic backup script program for rman. I have previously written an automatic backup case for exp backup specific solution (Oracle automatic backup case for Linux platfor
1. Oracle scheduled task:
Crontab-e
* ***/Home/oracle/workspace/scripts/bk_main.sh>/home/oracle/workspace/log/bk_err.log 2> 12. Main Control Program
/Home/oracle/workspace/scripts/bk_main.sh
#! /Bin/bash
Dat = 'date + '% m''
If ($ dat = 0 ))
Then
/Home/oracle/workspace/scripts/bk _. sh 0
Elif ($ dat % 50 = 0 ))
Then
/Home/oracle/workspace/scripts/bk _. sh 2
Elif ($ dat % 40 = 0 ))
Then
/Home/oracle/workspace/scripts/bk _. sh 2
Elif ($ dat % 30 = 0 ))
Then
/Home/oracle/workspace/scripts/bk _.
To define environment variables, even if the ORACLE user crontab-e is used. Sourcehomeoracle. bash_profile or directly change homeoracle. bash_pr
To define environment variables, even if the ORACLE user crontab-e is used. Source/home/oracle/. bash_profile or directly Mount/home/oracle/. bash_pr
I have previously written a script (see). You can manually execute it. Using crontab, you cannot run it successfully. This afternoon, I spent two hours ex
Rman backup script
#! /Bin/bash
Su-oracle
Rman target/
Backup as compressed backupset database
Include current controlfile format '/orabak/db _ % d _ % T _ % s'
Plus archivelog format'/orabak/arch _ % d _ % T _ % s' delete allinput;
Delete noprompt obsolete;
Exit;
EOF
Th
Tags: rman scripting shell1, the database is fully prepared to the hard disk[[Emailprotected]scripts]$catrman_backup.shsource/home/oracle/.bash_ profilermantarget/log=/home/oracle/backup/backupall_rman.log2. Incremental backup ScriptLevel 0 increments[[Emailprotected]scripts]$catrman_backup_level0.shsource/home/oracle /.bash_profilermantarget/log=/home/oracle/
Tags: rman scripting shell1, the database is fully prepared to the hard disk[[Emailprotected]scripts]$catrman_backup.shsource/home/oracle/.bash_ profilermantarget/log=/home/oracle/backup/backupall_rman.log2. Incremental backup ScriptLevel 0 increments[[Emailprotected]scripts]$catrman_backup_level0.shsource/home/oracle /.bash_profilermantarget/log=/home/oracle/
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.