易截截图软件、单文件、免安装、纯绿色、仅160KB

oracle 增量备份脚本

oracle 增量备份脚本
  OS :RHEL AS 4 oracle 10g
  0备份脚本
  #!/bin/bash
  # incremental level 0 backup script
  source /home/oracle/.bash_profile
  current_day=`date +%Y%m%d`
  mkdir /home/oracle/RMANBACKUP/$current_day
  rman target / <<EOF
  run
  {
  CONFIGURE CONTROLFILE AUTOBACKUP ON;
  CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/RMANBACKUP/$current_day/PID-%F';
  allocate channel dev1 type disk;
  allocate channel dev2 type disk;
  allocate channel dev3 type disk;
  backup incremental level 0 tag='db0'
  format '/home/oracle/RMANBACKUP/$current_day/%n_%T_%U' database;
  sql 'alter system archive log current';
  backup archivelog all format '/home/oracle/RMANBACKUP/$current_day/arc_%n_%T_%U' delete all input;
  release channel dev1;
  release channel dev2;
  release channel dev3;
  }
  EOF
  1级累积增量脚本
  #!/bin/bash
  # incremental level 1 backup script
  source /home/oracle/.bash_profile
  current_day=`date +%Y%m%d`
  incr_day=incr$current_day
  mkdir /home/oracle/RMANBACKUP/$incr_day
  rman target / <<EOF
  run
  {
  CONFIGURE CONTROLFILE AUTOBACKUP ON;
  CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/home/oracle/RMANBACKUP/$incr_day/PID-%F';
  allocate channel dev1 type disk;
  allocate channel dev2 type disk;
  allocate channel dev3 type disk;
  backup incremental level 1 cumulative tag='db1'
  format '/home/oracle/RMANBACKUP/$incr_day/%n_%T_%U' database;
  sql 'alter system archive log current';
  backup archivelog all format '/home/oracle/RMANBACKUP/$incr_day/arc_%n_%T_%U' delete all input;
  release channel dev1;
  release channel dev2;
  release channel dev3;
  }
  EOF
  每天RMAN出来的backup set集合到一个文件夹下面


相关文档:

Oracle ROLLUP和CUBE 用法

在做项目经常遇到分科室、人员进行汇总的问题,在ORACLE中对此类问题的处理相当方便!下面以项目中遇到的实例进行说明:
查询语句如下:
select f_sys_getsectnamebysectid(a.sectionid) as sectname,
        --a.sectionid,
       f_sys_employin ......

Oracle 备份 与 恢复 概述


玩Oracle也有2年的时间了, 零零散散的也整理一些资料。 东西一多了,就理不清楚。 所以结合张晓明的《大话Oracle RAC》的一些内容,和自己整理的一些笔记,对Oracle 的备份和恢复做了一个系统的整理。 也是自己对知识的一个巩固吧。 
一. 准备知识
先来看一些准备知识,了解 ......

oracle dblink 的应用

oracle dblink 的应用
url:http://blog.chinaunix.net/u/19820/showart_334013.html
1、用dblink链接oracle
(1)与平台无关的写法:
create public database
link cdt connect to apps
identified by apps using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.31.205.100)(PORT = 15 ......

Oracle 常用网址 积累中。。

官方文档:http://tahiti.oracle.com/
metalink:http://metalink.oracle.com
itpub:www.itpub.com
TOM:asktom.oracle.com
oracle forum:http://forums.oracle.com/forums/main.jspa?categoryID=84
OTN:http://www.oracle.com/technology/index.html
www.oracle.com.cn
www.eygle.com
 
Oracle ERP
www.erp10 ......

C#环境下往oracle中的blob字段插入文件

添加引用            
using System.Data.OracleClient;
主要用到了两个类
System.Data.OracleClient.OracleConnection 表示一个到数据库的连接。此类无法继承。
System.Data.OracleClient.OracleCommand   表示针对数据库执行的 SQL 语句或存 ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号