使用rman做全库备份
最简单是backup database ; ,它默认的放在db_recovery_file_dest 目录里面。
1
2
3
4
5
6
7
8
idle> show parameter recovery
NAME TYPE VALUE
------------------------------------ ---------------------- ------------------------------
db_recovery_file_dest string D:\apps\work\db\1123\fast_reco
very_area
db_recovery_file_dest_size big integer 20G
recovery_parallelism integer 0
另外也可以加更多的参数,比如下面的命令:
1
2
3
4
5
6
7
8
run{
allocate channel dev1 type disk ;
allocate channel dev2 type disk ;
backup database format '/u01/backup/DEX/backups/xxxx/bk_%t_%s' plus archivelog format '/u01/backup/DEX/backups/xxxx/arc_%t_%s' delete all input ;
crosscheck backup ;
delete noprompt obsolete ;
delete noprompt expired backup;
}
allocate channel dev1 type disk ;allocate channel dev2 type disk ;
表示分配两个通道(开启多线程)
backup database format '/u01/backup/DEX/backups/xxxx/bk_%t_%s'
备份数据库,至于/u01/backup/DEX/backups/xxxx/目录下面,格式为bk_%t_%s,
%s 备份集的号 %t 备份集时间戳
plus archivelog format '/u01/backup/DEX/backups/xxxx/arc_%t_%s' delete all input ;
备份归档文件,指定路径为/u01/backup/DEX/backups/xxxx/,格式为arc_%t_%s,备份后删除所有备份过的归档日志。
crosscheck backup ;
检查备份
delete noprompt obsolete ;
删除过期的备份文件(noprompt = 不做yes or no 提示)
delete noprompt expired backup;
删除实效的备份文件
上面的也是简单的备份脚本,它的选项很多,详细可以参考oracle 官方文档中的
Backup and Recovery User's Guide
Backup and Recovery Reference
地址:
http://www.oracle.com/pls/db112/portal.portal_db?selected=14&frame=