求oracle增量备份的方法 如何实现oracle增量备份? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 -- *1). 完整备份 + 压缩备份 脚本:#!/bin/bash# incremental level 0 backup scriptsource /home/oracle/.bash_profilecurrent_day=`date +%Y%m%d`current_day=12_$current_daymkdir /data/obase/ora_backup/$current_dayecho '-------------------------------------------------------------------------'echo "-- Begin Backup of DB 10.4.1.12 DateTime: `date` --"echo '-------------------------------------------------------------------------'rman target / <<EOFrun{CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;CONFIGURE BACKUP OPTIMIZATION ON;CONFIGURE CONTROLFILE AUTOBACKUP ON;CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/data/obase/ora_backup/$current_day/PID-%F';CONFIGURE DEVICE TYPE DISK PARALLELISM 4;crosscheck backup;delete noprompt obsolete;delete noprompt expired backup;allocate channel dev1 type disk;allocate channel dev2 type disk;allocate channel dev3 type disk;allocate channel dev4 type disk;backup as compressed backupset incremental level 0 tag='db0'format '/data/obase/ora_backup/$current_day/%n_%T_%U' database;sql 'alter system archive log current';backup archivelog all format '/data/obase/ora_backup/$current_day/arc_%n_%T_%U' delete all input;release channel dev1;release channel dev2;release channel dev3;release channel dev4;}EOFecho '------------------------------------------------------------------------'echo "-- End Backup of DB 10.4.1.12 DateTime: `date` --"echo '------------------------------------------------------------------------'scp -l 81920 -r /data/obase/ora_backup/$current_day [email protected]:/data/obase/ora_backup12 &waitecho '------------------------------------------------------------------------'echo "-- End of Send file to 10.4.1.13 DateTime: `date` --"echo '------------------------------------------------------------------------'-- *2) 增量备份 + 压缩备份脚本:#!/bin/bash# incremental level 1 backup scriptsource /home/oracle/.bash_profilecurrent_day=`date +%Y%m%d`incr_day=12_incr$current_daymkdir /data/obase/ora_backup/$incr_dayecho '-------------------------------------------------------------------------'echo "-- Begin Backup of DB 10.4.1.12 DateTime: `date` --"echo '-------------------------------------------------------------------------'rman target / <<EOFrun{CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;CONFIGURE BACKUP OPTIMIZATION ON;CONFIGURE CONTROLFILE AUTOBACKUP ON;CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/data/obase/ora_backup/$incr_day/PID-%F';CONFIGURE DEVICE TYPE DISK PARALLELISM 4;delete noprompt obsolete;crosscheck backup;delete noprompt expired backup;allocate channel dev1 type disk;allocate channel dev2 type disk;allocate channel dev3 type disk;allocate channel dev4 type disk;backup as compressed backupset incremental level 1 cumulative tag='db1'format '/data/obase/ora_backup/$incr_day/%n_%T_%U' database;sql 'alter system archive log current';backup archivelog all format '/data/obase/ora_backup/$incr_day/arc_%n_%T_%U' delete all input;release channel dev1;release channel dev2;release channel dev3;release channel dev4;}EOFecho '------------------------------------------------------------------------'echo "-- End Backup of DB 10.4.1.12 DateTime: `date` --"echo '------------------------------------------------------------------------'scp -l 81920 -r /data/obase/ora_backup/$incr_day [email protected]:/data/obase/ora_backup12 &waitecho '------------------------------------------------------------------------'echo "-- End of Send file to 10.4.1.13 DateTime: `date` --"echo '------------------------------------------------------------------------' -- 然后,我的crontab 如下:[oracle@localhost bk_script]$ crontab -l05 18 * * 6 /data/obase/ora_backup/bk_script/bk_script_level0.sh >> /data/obase/ora_backup/12_bk_level0.log05 18 * * 0-5 /data/obase/ora_backup/bk_script/bk_script_level1.sh >> /data/obase/ora_backup/12_bk_level1.log 顶!不错。有没有windows下的脚本? !!!!!!小白问题!!!!!!! 求解释 ORA-12541:TNS:没有监听器 oracle问题 使用oracle中的哪个目录下的菜单操作oracle?(初学者) 求解:Oracle一个简单的触发器创建 高分求一个触发器,请高手赐教!谢谢! 紧急求助关于ORACLE锁的问题! 重装机器了,8i没备份,重装8i后还能恢复吗? 主从表关联数据,如何写的sql语句得到主表的记录和相关的从表记录 oracle 管道函数 如何使用拼接sql字符串 oracle字符串中文内容替换的问题! orcale连接远程数据库提示未连接到orcale
#!/bin/bash
# incremental level 0 backup scriptsource /home/oracle/.bash_profilecurrent_day=`date +%Y%m%d`
current_day=12_$current_day
mkdir /data/obase/ora_backup/$current_day
echo '-------------------------------------------------------------------------'
echo "-- Begin Backup of DB 10.4.1.12 DateTime: `date` --"
echo '-------------------------------------------------------------------------'
rman target / <<EOF
run
{
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/data/obase/ora_backup/$current_day/PID-%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 4;
crosscheck backup;
delete noprompt obsolete;
delete noprompt expired backup;
allocate channel dev1 type disk;
allocate channel dev2 type disk;
allocate channel dev3 type disk;
allocate channel dev4 type disk;
backup as compressed backupset incremental level 0 tag='db0'
format '/data/obase/ora_backup/$current_day/%n_%T_%U' database;
sql 'alter system archive log current';
backup archivelog all format '/data/obase/ora_backup/$current_day/arc_%n_%T_%U' delete all input;
release channel dev1;
release channel dev2;
release channel dev3;
release channel dev4;
}
EOF
echo '------------------------------------------------------------------------'
echo "-- End Backup of DB 10.4.1.12 DateTime: `date` --"
echo '------------------------------------------------------------------------'
scp -l 81920 -r /data/obase/ora_backup/$current_day [email protected]:/data/obase/ora_backup12 &
wait
echo '------------------------------------------------------------------------'
echo "-- End of Send file to 10.4.1.13 DateTime: `date` --"
echo '------------------------------------------------------------------------'-- *2) 增量备份 + 压缩备份脚本:
#!/bin/bash
# incremental level 1 backup scriptsource /home/oracle/.bash_profilecurrent_day=`date +%Y%m%d`
incr_day=12_incr$current_day
mkdir /data/obase/ora_backup/$incr_day
echo '-------------------------------------------------------------------------'
echo "-- Begin Backup of DB 10.4.1.12 DateTime: `date` --"
echo '-------------------------------------------------------------------------'
rman target / <<EOF
run
{
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/data/obase/ora_backup/$incr_day/PID-%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 4;
delete noprompt obsolete;
crosscheck backup;
delete noprompt expired backup;
allocate channel dev1 type disk;
allocate channel dev2 type disk;
allocate channel dev3 type disk;
allocate channel dev4 type disk;
backup as compressed backupset incremental level 1 cumulative tag='db1'
format '/data/obase/ora_backup/$incr_day/%n_%T_%U' database;
sql 'alter system archive log current';
backup archivelog all format '/data/obase/ora_backup/$incr_day/arc_%n_%T_%U' delete all input;
release channel dev1;
release channel dev2;
release channel dev3;
release channel dev4;
}
EOF
echo '------------------------------------------------------------------------'
echo "-- End Backup of DB 10.4.1.12 DateTime: `date` --"
echo '------------------------------------------------------------------------'
scp -l 81920 -r /data/obase/ora_backup/$incr_day [email protected]:/data/obase/ora_backup12 &
wait
echo '------------------------------------------------------------------------'
echo "-- End of Send file to 10.4.1.13 DateTime: `date` --"
echo '------------------------------------------------------------------------'
[oracle@localhost bk_script]$ crontab -l
05 18 * * 6 /data/obase/ora_backup/bk_script/bk_script_level0.sh >> /data/obase/ora_backup/12_bk_level0.log
05 18 * * 0-5 /data/obase/ora_backup/bk_script/bk_script_level1.sh >> /data/obase/ora_backup/12_bk_level1.log
有没有windows下的脚本?