rman script example

#!/bin/shsource/home/oracle/.bash_profileif [-Z]then echo "please Input a number,usage:0|1|2" Exitelse Rman_leve L=$1fiexport oracle_sid=xxxxexport today= ' date ' +%y%m%d ' export rman_dir=/backup/archivelog/rman/$ORACLE _sid/$ today-$RMAN _levelmkdir-p $RMAN _dircd $RMAN _dirlogfile=ora_rman_bk_$oracle_sid-l$rman_lev

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 can I perform the backup? Enable the two channels and connect them to the two instances using the TNS connection string for backup. Thi

RMAN database Daily backup script (for Windows) Example: RMAN backup Daily orawin Database: 1, new backup. cmd: www.2cto.com set oracle_sid = orawinrman target/nocatalog partition file = F: Scriptorawinbackupfull. SQL log = F: Scriptorawinbackupfull. log append 2: Create backupfull under the path specified in the previ

Label:With 0112111 incremental backup strategy, 7 days a cycle that is, Sunday level 0 backup, Week 1 2 4 5 6 with 2-level incremental backup, week 3 with 1-level incremental backupConfigure control file backup path RMAN > CONFIGURE controlfile autobackup FORMAT for DEVICE TYPE DISK to '/u01/backup/rmanbk/ccontrolfile_%f '; Data Backup directory $ mkdir-p/U01/BACKUP/RMANBK First set the number of days to expire to 7 d

The logs backed up by RMAN are put in a file. The backup script in nocatalg was sent using Linux Sendmail. However, this affects the system startup time. It is still sent using python. After the backup, call the script. Send RMAN logs to the mailbox. Check the email in the morning to check whether the backup is success

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 type disk to 'd:/backup/% F ';

Oracle Rman backup script and automatic deletion of duplicate backup files, mongolerman #!/bin/shsource /home/oracle/.bash_profileif [ -z $1 ]then echo "Please Input a number,Usage: 0|1|2" exitelse RMAN_LEVEL=$1fiexport ORACLE_SID=xxxxexport TODAY=`date '+%Y%m%d'`export RMAN_DIR=/backup/archivelog/rman/$ORACLE_SID/$TODAY-$RMAN_LEVELmkdir -p $RMAN_DIRcd $RMAN_D

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

One, incremental backup scriptLevel 0 Backup script: Red section directory for custom backup files Copy Code code as follows: #script.: backupfull.sh #creater: Xyh #date: 2014-03-08 #desc: Backup full database datafile in archive with Rman #connect Database Export Oracle_base=/u01/app/oracle Export ORACLE_SID=ORCL Export Oracle_home=/

************************************************************************* * * * Original:blog.csdn.net/clark_xu Xu Changliang's Column************************************************************************Rman Backup Script#! /bin/bashSu-oracle Rman Target/Backup as compressed BACKUPSET DatabaseInclude current controlfile format '/orabak/db_%d_%t_%s 'plus arc

#!/bin/bashif [$]thenbackup_level=$1elsebackup_level=0fibackup_user=sysbackup_user_pw=oracle#catalog_user=rman #catalog_user_pw =rmanlog_file=/oracle/admin/$ORACLE _sid/rman_backup.logecho "Beginning rman backup ..." > $log _ filedata>> $log _filerman target $backup _user/$backup _user_pw Shell Script Rman Backup

I. Incremental backup scriptLevel 0 backup script: The red part is the directory of the custom backup fileCopy codeThe Code is as follows:# Script.: BackupFull. sh# Creater: xyh# Date: 2014-03-08# Desc: backup full database datafile in archive with rman# Connect databaseExport ORACLE_BASE =/u01/app/oracleExport ORACLE_SID = orclExport ORACLE_HOME =/u01/app/oracle

Oracle Rman Cold Shell script (I am here full backup, created 2 channels C1, C2) can be changed on this basis650) this.width=650; "Src=" Http://s4.51cto.com/wyfs02/M00/86/18/wKioL1e0fHyRO_TTAABgkcV8Mm0539.png-wh_500x0-wm_3 -wmp_4-s_2228178479.png "title=" capture. PNG "alt=" Wkiol1e0fhyro_ttaabgkcv8mm0539.png-wh_50 "/>Text:#!/bin/bash#Author: Wangergui email:[email protected] date:2016-08-17#Function: Oracl

$ FLSTEcho "## Step 3: lgmf_arch fzlfmes datafile arch export Backup End ### "> $ FLOG Mt-f $ DEVFILn offline Echo "please insert the fourth tape"Getyn "Was the fourth tape insert? (Y/n )" /Usr/bin/mt-f $ {DEVFILn} rewindCd/ Echo "# Step 4: lgmf_arch fzlfmes datafile arch export Backup ### "> $ FLOGFind u08/EXP_BK/lgmfs/* $ {MM} $ {DD}. *-print | cpio-ocv-H odc-C 30720-O $ DEVF ILn | tee-a $ FLSTFind u08/RMANBK/lgmfs/* $ {MM} $ {DD} *-print | cpio-ocv-H odc-C 30720-O $ DEVFI Ln | tee-a $

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 The third backup storage platform automatically clears expired backup files #! /Bin/bash

Environment:OEL + Oracle 11.2.0.1ORACLE_SID = orcl2Create the following directory:[Root @ DBA2/] $ mkdir/backup[Root @ DBA2/] $ mkdir/backup/0[Root @ DBA2/] $ mkdir/backup/1[Root @ DBA2/] $ mkdir/backup/2[Root @ DBA2/] $ mkdir/backup/3[Root @ DBA2/] $ mkdir/backup/4[Root @ DBA2/] $ mkdir/backup/5[Root @ DBA2/] $ mkdir/backup/6 Change owner:[Root @ DBA2 ~] # Chown-R oracle: dba/backup/ The script content is as follows:##################################

Oracle rman automatic backup script #! /Bin/sh. /opt/oracle /. bash_profilePWD_SYS = "/" BAK_DIR = "/opt/oracle/backup/oatest" BEGIN_SEQ =$ (sqlplus-s $ {PWD_SYS} 'as sysdba'

ls Desktop oracle_backup.rman oracle_backup. SH[[email protected] ~]$ cat Oracle_backup.rman run{configureBACKUPOptimization on; CONFIGURE Controlfile autobackup on; CONFIGURE RETENTION POLICY toRECOVERY WINDOW of 7Days ; CONFIGURE controlfile autobackup FORMAT forDEVICE TYPEDISK to '/u01/backup/%f'; ALLOCATE CHANNEL CH1 DEVICE TYPEDISKFORMAT'/u01/backup/%u'; ALLOCATE CHANNEL CH2 DEVICE TYPEDISKFORMAT'/u01/backup2/%u';BACKUP DATABASESKIP Inaccessible FilespersetTenPLUS ARCHIVELOG Filesperset

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/backup/backupall_rman.logLevel 1 increments[[Emailprotected]scripts]$catrman_backup_level1.sh

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/backup/backupall_rman.logLevel 1 increments[[Emailprotected]scripts]$catrman_backup_level1.sh