oracle备份脚本代码,PLSQL代码库,德仔网

代码语言

代码分类

【PLSQL】 oracle备份脚本

作者:Billing / 发布于2012/8/30/ 1009

oracle@ocsdb1[/oracle]$cat -n /bak_cc/scripts/rman_cc.sh
  #! /bin/sh
  
  ps -ef|grep   ora_pmon_cc|grep -v -q  grep
  
  if [ $? -gt 0 ]
  then 
  echo cc not running ;
  exit 0;
  fi
  
  bdf|grep   bak_cc|grep -v -q  grep
  
  if [ $? -gt 0 ]
  then 
  echo bak_cc not mounted ;
  exit 0;
  fi
  
  hostname|grep ocsdb1|grep -v -q  grep
  if [ $? -gt 0 ]
  then 
  export ORACLE_SID=cc2;
  else
  export ORACLE_SID=cc1;
  fi
  
  DIR=/bak_cc/wp_L0cc
  BAKDIR=/bak_cc/bak_L0cc
  
  DT=`date +%Y%m%d`
  
  find $DIR  -type f -exec rm {} \;
  
  export ORACLE_HOME=/oracle/product/102
  $ORACLE_HOME/bin/rman target / catalog rman/rman@rb log=$DIR/rman.log<<EOF
  run {
  allocate channel 'disk1' type disk format '$DIR/%d_L0_%T_%s_p%p' maxpiecesize 10G;
  allocate channel 'disk2' type disk format '$DIR/%d_L0_%T_%s_p%p' maxpiecesize 10G;
  allocate channel 'disk3' type disk format '$DIR/%d_L0_%T_%s_p%p' maxpiecesize 10G;
  allocate channel 'disk4' type disk format '$DIR/%d_L0_%T_%s_p%p' maxpiecesize 10G;
  backup incremental level 0 as compressed backupset  
  database include current controlfile;
  
  sql 'alter system archive log current' ;
  backup format '$DIR/arc%d_AC_%T_%h_%e_s%s_p%p' archivelog  all delete all input;
  release channel 'disk1';
  release channel 'disk2';
  release channel 'disk3';
  release channel 'disk4';
  }
  quit;
  EOF
  
  /usr/contrib/bin/gzip $DIR/CC_L0_$DT*
  
  touch  $BAKDIR/DATA_READY
  
  
  find $DIR -mtime +1  -type f -exec rm {} \;
  
  exit 0;

试试其它关键字

　oracle备份　

同语言下

可能有用的

Billing贡献的其它代码(2)