oracle rman 备份脚本
来源:互联网 发布:anime studio pro mac 编辑:程序博客网 时间:2024/05/19 15:43
[oracle@qyxxmh_db1 ~]$ cat /home/oracle/orabackup/fullbackup.sh
#!/bin/sh
. /home/oracle/.bash_profile
rman log ='/home/oracle/orabackup/fulltmp.log' <<EOF
connect target /
run {
allocate channel d1 type disk;
allocate channel d2 type disk;
allocate channel d3 type disk;
allocate channel d4 type disk;
backup as compressed backupset format 'full_%d_%t_%s_%p_%T.dbf' database;
release channel d1;
release channel d2;
release channel d3;
release channel d4;
}
run {
allocate channel d1 type disk;
allocate channel d2 type disk;
allocate channel d3 type disk;
crosscheck backup;
crosscheck archivelog all;
delete noprompt obsolete;
delete noprompt expired backup;
delete noprompt expired archivelog all;
release channel d1;
release channel d2;
release channel d3;
}
exit;
EOF
cat /home/oracle/orabackup/fulltmp.log >>/home/oracle/orabackup/fullbackup.log
cd /u01/app/oracle/product/11.2.0/dbhome_1/dbs
cp *.dbf /sharedisk/rman_bak/
find /sharedisk/rman_bak/ -mtime +2 -type f -name "full*.dbf" -exec rm -rf {} \;
----------------------------------------------------------------------------------------
[oracle@qyxxmh_db1 ~]$ cat /home/oracle/orabackup/archbackup.sh
. /home/oracle/.bash_profile
rman log ='/home/oracle/orabackup/archtmp.log' <<EOF
connect target /
run {
allocate channel d1 type disk;
backup as compressed backupset archivelog all format 'al_%d_%t_%s_%p_%T.dbf';
allocate channel d2 type disk;
crosscheck backup;
crosscheck archivelog all;
delete noprompt obsolete;
delete noprompt expired backup;
delete noprompt expired archivelog all;
release channel d1;
release channel d2;
}
exit;
EOF
cat /home/oracle/orabackup/archtmp.log >> /home/oracle/orabackup/archfull.log
cd /u01/app/oracle/product/11.2.0/dbhome_1/dbs
cp al*.dbf /sharedisk/rman_bak/
find /sharedisk/rman_bak/ -mtime +2 -type f -name "al*.dbf" -exec rm -rf {} \;
#!/bin/sh
. /home/oracle/.bash_profile
rman log ='/home/oracle/orabackup/fulltmp.log' <<EOF
connect target /
run {
allocate channel d1 type disk;
allocate channel d2 type disk;
allocate channel d3 type disk;
allocate channel d4 type disk;
backup as compressed backupset format 'full_%d_%t_%s_%p_%T.dbf' database;
release channel d1;
release channel d2;
release channel d3;
release channel d4;
}
run {
allocate channel d1 type disk;
allocate channel d2 type disk;
allocate channel d3 type disk;
crosscheck backup;
crosscheck archivelog all;
delete noprompt obsolete;
delete noprompt expired backup;
delete noprompt expired archivelog all;
release channel d1;
release channel d2;
release channel d3;
}
exit;
EOF
cat /home/oracle/orabackup/fulltmp.log >>/home/oracle/orabackup/fullbackup.log
cd /u01/app/oracle/product/11.2.0/dbhome_1/dbs
cp *.dbf /sharedisk/rman_bak/
find /sharedisk/rman_bak/ -mtime +2 -type f -name "full*.dbf" -exec rm -rf {} \;
----------------------------------------------------------------------------------------
[oracle@qyxxmh_db1 ~]$ cat /home/oracle/orabackup/archbackup.sh
. /home/oracle/.bash_profile
rman log ='/home/oracle/orabackup/archtmp.log' <<EOF
connect target /
run {
allocate channel d1 type disk;
backup as compressed backupset archivelog all format 'al_%d_%t_%s_%p_%T.dbf';
allocate channel d2 type disk;
crosscheck backup;
crosscheck archivelog all;
delete noprompt obsolete;
delete noprompt expired backup;
delete noprompt expired archivelog all;
release channel d1;
release channel d2;
}
exit;
EOF
cat /home/oracle/orabackup/archtmp.log >> /home/oracle/orabackup/archfull.log
cd /u01/app/oracle/product/11.2.0/dbhome_1/dbs
cp al*.dbf /sharedisk/rman_bak/
find /sharedisk/rman_bak/ -mtime +2 -type f -name "al*.dbf" -exec rm -rf {} \;
0 0
- Oracle RMAN备份脚本
- oracle rman备份脚本
- Oracle RMAN备份脚本
- oracle rman 备份脚本
- Oracle Rman-备份脚本
- oracle rman 备份数据库脚本
- oracle rman自动备份脚本
- Oracle RMAN数据库备份脚本
- oracle rman 定时备份脚本
- Oracle rman 自动备份脚本
- [Rman]Oracle Rman增量备份Level012脚本
- ORACLE RMAN备份的脚本配置
- Oracle数据库RMAN的自动备份脚本
- ORACLE 10G rman 备份脚本
- Oracle的RMAN备份与恢复脚本
- Oracle生产环境RMAN备份脚本
- Oracle的RMAN备份与恢复脚本
- Oracle的RMAN备份与恢复脚本
- 技术概念
- SQL查询结果区分大小写
- iOS Application相关知识
- 4.4
- java Jedis连接池的使用
- oracle rman 备份脚本
- docker学习-安装及基本命令使用
- CAS--SSO单点登录完整教程
- 单元测试中模拟HttpContext.Current
- java 并发操作list集合导致java.util.ConcurrentModificationException
- ScrollView 的content设置
- 已知left和top,求right和bottom
- mysql中日期比较大小方法详解
- id类型和NSObject的区别