本文提供了一个Oracle数据库的全库备份脚本示例，包括归档日志、控制文件和SPFILE参数文件等关键组件的备份过程。脚本通过RMAN工具执行，并详细记录了备份的日志信息。
全库备份脚本，包括归档日志及控制文件、SPFILE参数文件
[oracle@~]$ cat fullback.sh
#!/bin/sh
source /home/oracle/.bash_profile
rman log /opt/uniload/oracle/backup/log/backfull-`date +%Y%m%d-%H%M`.log <<EOF
connect target /;
run {
backup full tag 'bys001-full' database
format "/opt/uniload/oracle/backup/full_back/bys001full_%d_%t_%s"
plus archivelog
format "/opt/uniload/oracle/backup/full_back/bys001arch_%d_%t_%s"
delete all input;
}
exit
[oracle@~]$ cat fullback.sh
#!/bin/sh
source /home/oracle/.bash_profile
rman log /opt/uniload/oracle/backup/log/backfull-`date +%Y%m%d-%H%M`.log <<EOF
connect target /;
run {
backup full tag 'bys001-full' database
format "/opt/uniload/oracle/backup/full_back/bys001full_%d_%t_%s"
plus archivelog
format "/opt/uniload/oracle/backup/full_back/bys001arch_%d_%t_%s"
delete all input;
}
exit
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
