Chinaunix首页 | 论坛 | 博客

ET_cat

首页　| 　博文目录　| 　关于我

lzp_0004

  • 博客访问： 651628
  • 博文数量： 128
  • 博客积分： 265
  • 博客等级： 二等列兵
  • 技术积分： 1464
  • 用 户 组： 普通用户
  • 注册时间： 2011-09-27 20:44
个人简介

just do it

文章分类

全部博文（128）

文章存档

2023年（1）

2020年（1）

2019年（1）

2018年（3）

2017年（6）

2016年（17）

2015年（16）

2014年（39）

2013年（34）

2012年（10）

我的朋友
最近访客
推荐博文
相关博文
oracle备份脚本

分类： Oracle

2015-10-13 08:21:18


点击(此处)折叠或打开

  1. oracle9i备份脚本：
  3. 全备（level 0）：
  4. bash-3.00$ more ora9i_rman_bak.sh | grep -v "#"
  6.  
  7. CUSER=`id |cut -d"(" -f2 | cut -d ")" -f1`
  8.  
  10. RMAN_LOG_FILE=${0}.out
  13. if [ -f "$RMAN_LOG_FILE" ]
  14. then
  15.         rm -f "$RMAN_LOG_FILE"
  16. fi
  18.  
  19. echo >> $RMAN_LOG_FILE
  20. chmod 666 $RMAN_LOG_FILE
  21.  
  22.  
  23. echo Script $0 >> $RMAN_LOG_FILE
  24. echo ==== started on `date` ==== >> $RMAN_LOG_FILE
  25. echo >> $RMAN_LOG_FILE
  26.  
  28. ORACLE_HOME=/orahome/oracle/product/9.2.0
  29. export ORACLE_HOME
  32. ORACLE_SID=bims
  33. export ORACLE_SID
  36. ORACLE_USER=oracle
  39. TARGET_CONNECT_STR=/
  40.  
  42. RMAN=$ORACLE_HOME/bin/rman
  45. echo >> $RMAN_LOG_FILE
  46. echo   "RMAN: $RMAN" >> $RMAN_LOG_FILE
  47. echo   "ORACLE_SID: $ORACLE_SID" >> $RMAN_LOG_FILE
  48. echo   "ORACLE_USER: $ORACLE_USER" >> $RMAN_LOG_FILE
  49. echo   "ORACLE_HOME: $ORACLE_HOME" >> $RMAN_LOG_FILE
  52. echo  >> $RMAN_LOG_FILE
  53. echo   "NB_ORA_FULL: $NB_ORA_FULL" >> $RMAN_LOG_FILE
  54. echo   "NB_ORA_INCR: $NB_ORA_INCR" >> $RMAN_LOG_FILE
  55. echo   "NB_ORA_CINC: $NB_ORA_CINC" >> $RMAN_LOG_FILE
  56. echo   "NB_ORA_SERV: $NB_ORA_SERV" >> $RMAN_LOG_FILE
  57. echo   "NB_ORA_POLICY: $NB_ORA_POLICY" >> $RMAN_LOG_FILE
  60. echo >> $RMAN_LOG_FILE
  61.  
  62. if [ "$NB_ORA_FULL" = "1" ]
  63. then
  64.         echo "Full backup requested" >> $RMAN_LOG_FILE
  65.         BACKUP_TYPE="INCREMENTAL LEVEL=0"
  66.  
  67. elif [ "$NB_ORA_INCR" = "1" ]
  68. then
  69.         echo "Differential incremental backup requested" >> $RMAN_LOG_FILE
  70.         BACKUP_TYPE="INCREMENTAL LEVEL=1"
  71.  
  72. elif [ "$NB_ORA_CINC" = "1" ]
  73. then
  74.         echo "Cumulative incremental backup requested" >> $RMAN_LOG_FILE
  75.         BACKUP_TYPE="INCREMENTAL LEVEL=1 CUMULATIVE"
  76.  
  77. elif [ "$BACKUP_TYPE" = "" ]
  78. then
  79.         echo "Default - Full backup requested" >> $RMAN_LOG_FILE
  80.         BACKUP_TYPE="INCREMENTAL LEVEL=0"
  81. fi
  85. CMD_STR="
  86. ORACLE_HOME=$ORACLE_HOME
  87. export ORACLE_HOME
  88. ORACLE_SID=$ORACLE_SID
  89. export ORACLE_SID
  90. NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'
  91. export NLS_DATE_FORMAT
  92. $RMAN target $TARGET_CONNECT_STR nocatalog msglog $RMAN_LOG_FILE append << EOF
  93. crosscheck archivelog all;
  94. delete noprompt expired archivelog all;
  95. RUN {
  96. ALLOCATE CHANNEL ch00 TYPE disk;
  97. ALLOCATE CHANNEL ch01 TYPE disk;
  98. ALLOCATE CHANNEL ch02 TYPE disk;
  99. ALLOCATE CHANNEL ch03 TYPE disk;
  100. BACKUP
  101.     $BACKUP_TYPE
  102.     SKIP INACCESSIBLE
  103.     TAG hot_db_bk_level0
  104.     FILESPERSET 5
  105.     FORMAT '/orahomebak/backup/database/bk_%s_%p_%t'
  106.     DATABASE;
  107.     sql 'alter system archive log current';
  108. RELEASE CHANNEL ch00;
  109. RELEASE CHANNEL ch01;
  110. RELEASE CHANNEL ch02;
  111. RELEASE CHANNEL ch03;
  112. ALLOCATE CHANNEL ch00 TYPE disk;
  113. ALLOCATE CHANNEL ch01 TYPE disk;
  114. BACKUP
  115.    filesperset 20
  116.    FORMAT '/orahomebak/backup/arch/al_%s_%p_%t'
  117.    ARCHIVELOG ALL DELETE INPUT;
  118. RELEASE CHANNEL ch00;
  119. RELEASE CHANNEL ch01;
  120. ALLOCATE CHANNEL ch00 TYPE disk;
  121. BACKUP
  122.     FORMAT '/orahomebak/backup/database/cntrl_%s_%p_%t'
  123.     CURRENT CONTROLFILE;
  124. RELEASE CHANNEL ch00;
  125. }
  126. EOF
  127. "
  128.  
  129. if [ "$CUSER" = "root" ]
  130. then
  131.     su - $ORACLE_USER -c "$CMD_STR" >> $RMAN_LOG_FILE
  132.     RSTAT=$?
  133. else
  134.     /usr/bin/sh -c "$CMD_STR" >> $RMAN_LOG_FILE
  135.     RSTAT=$?
  136. fi
  137.  
  138.  
  139. if [ "$RSTAT" = "0" ]
  140. then
  141.     LOGMSG="ended successfully"
  142. else
  143.     LOGMSG="ended in error"
  144. fi
  145.  
  146. echo >> $RMAN_LOG_FILE
  147. echo Script $0 >> $RMAN_LOG_FILE
  148. echo ==== $LOGMSG on `date` ==== >> $RMAN_LOG_FILE
  149. echo >> $RMAN_LOG_FILE
  150.  
  151. exit $RSTAT
  157. Differential incremental backup（level 1）：
  159. bash-3.00$ more ora9i_rman_bak.sh | grep -v "#"
  161.  
  162. CUSER=`id |cut -d"(" -f2 | cut -d ")" -f1`
  163.  
  165. RMAN_LOG_FILE=${0}.out
  168. if [ -f "$RMAN_LOG_FILE" ]
  169. then
  170.         rm -f "$RMAN_LOG_FILE"
  171. fi
  173.  
  174. echo >> $RMAN_LOG_FILE
  175. chmod 666 $RMAN_LOG_FILE
  176.  
  177.  
  178. echo Script $0 >> $RMAN_LOG_FILE
  179. echo ==== started on `date` ==== >> $RMAN_LOG_FILE
  180. echo >> $RMAN_LOG_FILE
  181.  
  183. ORACLE_HOME=/orahome/oracle/product/9.2.0
  184. export ORACLE_HOME
  187. ORACLE_SID=bims
  188. export ORACLE_SID
  191. ORACLE_USER=oracle
  194. TARGET_CONNECT_STR=/
  195.  
  197. RMAN=$ORACLE_HOME/bin/rman
  200. echo >> $RMAN_LOG_FILE
  201. echo   "RMAN: $RMAN" >> $RMAN_LOG_FILE
  202. echo   "ORACLE_SID: $ORACLE_SID" >> $RMAN_LOG_FILE
  203. echo   "ORACLE_USER: $ORACLE_USER" >> $RMAN_LOG_FILE
  204. echo   "ORACLE_HOME: $ORACLE_HOME" >> $RMAN_LOG_FILE
  207. echo  >> $RMAN_LOG_FILE
  208. echo   "NB_ORA_FULL: $NB_ORA_FULL" >> $RMAN_LOG_FILE
  209. echo   "NB_ORA_INCR: $NB_ORA_INCR" >> $RMAN_LOG_FILE
  210. echo   "NB_ORA_CINC: $NB_ORA_CINC" >> $RMAN_LOG_FILE
  211. echo   "NB_ORA_SERV: $NB_ORA_SERV" >> $RMAN_LOG_FILE
  212. echo   "NB_ORA_POLICY: $NB_ORA_POLICY" >> $RMAN_LOG_FILE
  215. echo >> $RMAN_LOG_FILE
  216. echo "Differential incremental backup requested" >> $RMAN_LOG_FILE
  220. CMD_STR="
  221. ORACLE_HOME=$ORACLE_HOME
  222. export ORACLE_HOME
  223. ORACLE_SID=$ORACLE_SID
  224. export ORACLE_SID
  225. NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'
  226. export NLS_DATE_FORMAT
  227. $RMAN target $TARGET_CONNECT_STR nocatalog msglog $RMAN_LOG_FILE append << EOF
  228. crosscheck archivelog all;
  229. delete noprompt expired archivelog all;
  230. RUN {
  231. ALLOCATE CHANNEL ch00 TYPE disk;
  232. ALLOCATE CHANNEL ch01 TYPE disk;
  233. ALLOCATE CHANNEL ch02 TYPE disk;
  234. ALLOCATE CHANNEL ch03 TYPE disk;
  235. BACKUP
  236.     INCREMENTAL LEVEL 1
  237.     SKIP INACCESSIBLE
  238.     TAG hot_db_bk_level1
  239.     FILESPERSET 5
  240.     FORMAT '/orahomebak/backup/database/bk_%s_%p_%t'
  241.     DATABASE;
  242.     sql 'alter system archive log current';
  243. RELEASE CHANNEL ch00;
  244. RELEASE CHANNEL ch01;
  245. RELEASE CHANNEL ch02;
  246. RELEASE CHANNEL ch03;
  247. ALLOCATE CHANNEL ch00 TYPE disk;
  248. ALLOCATE CHANNEL ch01 TYPE disk;
  249. BACKUP
  250.    filesperset 20
  251.    FORMAT '/orahomebak/backup/arch/al_%s_%p_%t'
  252.    ARCHIVELOG ALL DELETE INPUT;
  253. RELEASE CHANNEL ch00;
  254. RELEASE CHANNEL ch01;
  255. ALLOCATE CHANNEL ch00 TYPE disk;
  256. BACKUP
  257.     FORMAT '/orahomebak/backup/database/cntrl_%s_%p_%t'
  258.     CURRENT CONTROLFILE;
  259. RELEASE CHANNEL ch00;
  260. }
  261. EOF
  262. "
  263.  
  264. if [ "$CUSER" = "root" ]
  265. then
  266.     su - $ORACLE_USER -c "$CMD_STR" >> $RMAN_LOG_FILE
  267.     RSTAT=$?
  268. else
  269.     /usr/bin/sh -c "$CMD_STR" >> $RMAN_LOG_FILE
  270.     RSTAT=$?
  271. fi
  272.  
  273.  
  274. if [ "$RSTAT" = "0" ]
  275. then
  276.     LOGMSG="ended successfully"
  277. else
  278.     LOGMSG="ended in error"
  279. fi
  280.  
  281. echo >> $RMAN_LOG_FILE
  282. echo Script $0 >> $RMAN_LOG_FILE
  283. echo ==== $LOGMSG on `date` ==== >> $RMAN_LOG_FILE
  284. echo >> $RMAN_LOG_FILE
  285.  
  286. exit $RSTAT

阅读(2246) | 评论(0) | 转发(1) |
0

上一篇：oracle11gR2 dataguard部署测试（单实例）

下一篇：如何获得创建控制文件的脚本并重建控制文件

给主人留下些什么吧！~~
关于我们 | 关于IT168 | 联系方式 | 广告合作 | 法律声明 | 免费注册

Copyright 2001-2010 ChinaUnix.net All Rights Reserved 北京皓辰网域网络信息技术有限公司. 版权所有

感谢所有关心和支持过ChinaUnix的朋友们

16024965号-6