rman备份例子
1.全备份例子
#!/bin/sh
RMAN_OUTPUT_LOG=/home/oracle/rman_output.log
RMAN_ERROR_LOG=/home/oracle/rman_error.log
rman target / log=/home/oracle/rman_output.log<<EOF
run
{
allocate channel ch1 device type disk;
backup full database format '/home/oracle/rman_bakckup/db_fullbackup_%d_%s_%p_%T';
backup current controlfile format '/home/oracle/rman_bakckup/ctl_%d_%s_%p_%T';
backup archivelog all format '/home/oracle/rman_bakckup/arch_%d_%s_%p_%T';
backup spfile format '/home/oracle/rman_bakckup/backup/spfile_%d_%s_%p_%T';
release channel ch1;
}
EOF
#!/bin/sh
RMAN_OUTPUT_LOG=/home/oracle/rman_output.log
RMAN_ERROR_LOG=/home/oracle/rman_error.log
rman target / << EOF 1>>$RMAN_OUTPUT_LOG 2>>$RMAN_ERROR_LOG
run
{
allocate channel ch1 device type disk;
backup full database format '/home/oracle/rman_bakckup/db_fullbackup_%d_%s_%p_%T';
backup current controlfile format '/home/oracle/rman_bakckup/ctl_%d_%s_%p_%T';
backup archivelog all format '/home/oracle/rman_bakckup/arch_%d_%s_%p_%T';
backup spfile format '/home/oracle/rman_bakckup/backup/spfile_%d_%s_%p_%T';
release channel ch1;
}
EOF
2.压缩备份
##非归档备份数据库
rman target / <<EOF
run
{
allocate channel ch1 device type disk;
backup as compressed backupset full filesperset 5 database format '/home/oracle/rman_bakckup/db_fullbackup_%d_%s_%p_%T';
backup current controlfile format '/home/oracle/rman_bakckup/ctl_%d_%s_%p_%T';
backup spfile format '/home/oracle/rman_bakckup/spfile_%d_%s_%p_%T';
release channel ch1;
crosscheck backup;
delete noprompt expired backup;
delete noprompt obsolete;
}
EOF
3.压缩备份数据文件和归档日志文件
[oracle@cyz-server scripts]$ more rman_backup.sh
#!/bin/sh
backup_date=`date +%Y-%m-%d`
rman target / log=/home/oracle/scripts/logs/rmanbackup_log_${backup_date}.log<<EOF
run
{
allocate channel ch1 device type disk;
backup as compressed backupset full filesperset 5 database format '/home/oracle/rman_backup/db_fullbackup_%d_%s_%p_%T';
sql 'alter system archive log current';
backup as compressed backupset archivelog all delete input format '/home/oracle/rman_backup/arch_%d_%s_%p_%T';
backup current controlfile format '/home/oracle/rman_backup/ctl_%d_%s_%p_%T';
backup spfile format '/home/oracle/rman_backup/spfile_%d_%s_%p_%T';
release channel ch1;
crosscheck backup;
delete noprompt expired backup;
delete noprompt obsolete;
}
EOF
相关文章
- web安全day29:linux日志异地备份
- mysql命令备份和还原
- Oracle 备份与还原
- rdiff-backup:一个 Linux 中的远程增量备份工具
- 使用 pg_dump 和 pd_dumpall 备份数据库
- 使用python脚本Telnet 华为交换机备份配置
- MySQL mysqldump备份数据库及恢复数据库(mysql命令)
- mongodb 数据自动备份
- 转 如何使用Mysqldump备份和还原MySQL数据库
- rsync是类unix系统下的数据镜像备份工具
- svn 备份脚本
- (4.9)mysql备份还原——binlog查看工具之mysqlbinlog的使用
- (2.9)备份与还原--进一步了解事务日志的作用于结构(解析事务日志fn_dblog(null.null))
- 5款靠谱的安卓备份应用
- SQL SERVER 数据库备份的三种策略及语句
- 火狐FireFox恢复备份失败,无法处理备份文件