英皇国际赌场游戏-金属BCS超导体

首页

AD联系:507867812

英皇国际赌场游戏

时间:2019-11-22 05:10:54 作者:ag网络平台 浏览量:60864

英皇国际赌场游戏Linux 下crontab管理RMAN一周自动增量备份

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxLinux 下crontab管理RMAN一周自动增量备份

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux,见下图

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxLinux 下crontab管理RMAN一周自动增量备份,见下图

Linux 下crontab管理RMAN一周自动增量备份Linux 下crontab管理RMAN一周自动增量备份

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux,如下图

Linux 下crontab管理RMAN一周自动增量备份Linux 下crontab管理RMAN一周自动增量备份

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

如下图

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux,如下图

Linux 下crontab管理RMAN一周自动增量备份Linux 下crontab管理RMAN一周自动增量备份,见图

英皇国际赌场游戏

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxLinux 下crontab管理RMAN一周自动增量备份

Linux 下crontab管理RMAN一周自动增量备份

Linux 下crontab管理RMAN一周自动增量备份Linux 下crontab管理RMAN一周自动增量备份Linux 下crontab管理RMAN一周自动增量备份Linux 下crontab管理RMAN一周自动增量备份Linux 下crontab管理RMAN一周自动增量备份

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxLinux 下crontab管理RMAN一周自动增量备份

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxLinux 下crontab管理RMAN一周自动增量备份Linux 下crontab管理RMAN一周自动增量备份Linux 下crontab管理RMAN一周自动增量备份Linux 下crontab管理RMAN一周自动增量备份Linux 下crontab管理RMAN一周自动增量备份

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxLinux 下crontab管理RMAN一周自动增量备份Linux 下crontab管理RMAN一周自动增量备份Linux 下crontab管理RMAN一周自动增量备份。

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

英皇国际赌场游戏Linux 下crontab管理RMAN一周自动增量备份

Linux 下crontab管理RMAN一周自动增量备份

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxLinux 下crontab管理RMAN一周自动增量备份Linux 下crontab管理RMAN一周自动增量备份

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxLinux 下crontab管理RMAN一周自动增量备份

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

Linux 下crontab管理RMAN一周自动增量备份

1.Linux 下crontab管理RMAN一周自动增量备份

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxLinux 下crontab管理RMAN一周自动增量备份

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxLinux 下crontab管理RMAN一周自动增量备份

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxLinux 下crontab管理RMAN一周自动增量备份

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

2.Linux 下crontab管理RMAN一周自动增量备份。

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxLinux 下crontab管理RMAN一周自动增量备份

3.

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxLinux 下crontab管理RMAN一周自动增量备份Linux 下crontab管理RMAN一周自动增量备份Linux 下crontab管理RMAN一周自动增量备份

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxLinux 下crontab管理RMAN一周自动增量备份

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

4.Linux 下crontab管理RMAN一周自动增量备份。

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxLinux 下crontab管理RMAN一周自动增量备份

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxLinux 下crontab管理RMAN一周自动增量备份

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linuxLinux 下crontab管理RMAN一周自动增量备份Linux 下crontab管理RMAN一周自动增量备份Linux 下crontab管理RMAN一周自动增量备份Linux 下crontab管理RMAN一周自动增量备份。英皇国际赌场游戏

展开全文
相关文章
国外直播网站

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux

太阳城管理网唯一官网

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux....

365asia怎么进不去了

Linux 下crontab管理RMAN一周自动增量备份....

娱乐开户app

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux....

澳门皇冠注册网站

Linux 下crontab管理RMAN一周自动增量备份....

相关资讯
manbetx客户端价格

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux....

ag怎么买呀

编写各自对应的级别备份脚本 rmanbklevel_0.sh rmanbklevel_1.sh rmanbklevel_2.sh[Oracle@oracle11gR2 scripts]$ pwd/u01/scripts[oracle@oracle11gR2 scripts]$ lltotal 44-rw-r--r--. 1 oracle oinstall 102 Jul 20 04:39 audit.sql-rwxr-xr-x. 1 oracle oinstall 398 Jul 22 03:50 coldbak.sh-rw-r--r--. 1 oracle oinstall 829 Jul 17 02:08 deadlock.sql-rw-r--r--. 1 oracle oinstall 126 Jul 20 04:29 fail_count.sql-rw-r--r--. 1 oracle oinstall 327 Jul 20 04:28 fail_user.sql-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:45 rmanbklevel_0.sh //0级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:46 rmanbklevel_1.sh //1级备份要有可执行权限x-rwxr-xr-x. 1 oracle oinstall 260 Jul 22 19:47 rmanbklevel_2.sh //2级备份要有可执行权限x-rw-r--r--. 1 oracle oinstall 116 Jul 20 00:44 spid.sql-rw-r--r--. 1 oracle oinstall 143 Jul 17 04:59 undo.sql-rwxr-xr-x. 1 oracle oinstall 613 Jul 22 15:00 userbak.sh[oracle@oracle11gR2 scripts]$

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_0.sh //0级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl0.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 0format '/rmanbk/incremental_level0_%u_%T'tag backup_inc0database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_1.sh //1级备份脚本

#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl1.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 1format '/rmanbk/incremental_level1_%u_%T'tag backup_inc1database;release channel cha1;}EOFexit

[oracle@oracle11gR2 scripts]$ vi rmanbklevel_2.sh //2级备份脚本#!/bin/shexport ORACLE_SID=orclrman log='/rmanbk/bakl2.log' append <<EOFconnect target /;run{allocate channel cha1 type disk;backup incremental level 2format '/rmanbk/incremental_level2_%u_%T'tag backup_inc2database;release channel cha1;}EOFexit

在root身份下添加crontab任务计划[root@oracle11gR2 ~]# crontab -e59 19 * * 0 su - oracle -c /u01/scripts/rmanbklevel_0.sh 每周日19点59分0级备份59 19 * * 1 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周一19点59分2级备份59 19 * * 2 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周二19点59分2级备份59 19 * * 3 su - oracle -c /u01/scripts/rmanbklevel_1.sh 每周三19点59分1级备份59 19 * * 4 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周四19点59分2级备份59 19 * * 5 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周五19点59分2级备份59 19 * * 6 su - oracle -c /u01/scripts/rmanbklevel_2.sh 每周六19点59分2级备份保存退出

[root@oracle11gR2 ~]# service crond restart //重启任务计划Stopping crond: [ OK ]Starting crond: [ OK ]

一周的RMAN自动备份任务完成

推荐阅读:

Oracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htm

RMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htm

RMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htm

Oracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm

更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx?tid=12

linux....

热门资讯