1200字范文,内容丰富有趣,写作的好帮手!
1200字范文 > windows oracle增量备份脚本 oracle 增量备份脚本

windows oracle增量备份脚本 oracle 增量备份脚本

时间:2024-06-14 07:50:59

相关推荐

windows 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 / <

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 / <

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;

&

本内容不代表本网观点和政治立场,如有侵犯你的权益请联系我们处理。
网友评论
网友评论仅供其表达个人看法,并不表明网站立场。