ME TO 快照控制文件名
RMAN默认备份介质保存目录/home/oracle/backup
configure channel device type disk format '/home/oracle/backup/ocmdb_%U';
控制文件自动备份
configure controlfile autobackup on;
configure controlfile autobackup format for device type disk to '/home/oracle/backup/control/controlfile_%F';
备份并行度2
CONFIGURE DEVICE TYPE DISK PARALLELISM 2;
增量备份
configure backup optimization on;
备份介质保留期为30天
configure retention policy to recovery window of 30 days;
显示我们设置完的参数配置
show all;
四 RMAN备份和闪回数据库
官方文档：Backup and Recovery Reference -> BACKUP
Backup and Recovery Basics -> 4 Backing Up Databases Using RMAN -> 4.2.5 Using Compressed Backupsets for RMAN Backup
1.压缩全备
backup as compressed backupset database plus archivelog; 使用默认的备份介质目录和格式，使用控制文件和参数文件自动备份
2.RMAN模块版压缩备份数据库，采用压缩备份方式全库备份
run{
backup as compressed backupset full database
format '/home/oracle/backup/full_ocmdb_%u%p%s.rmn'
include current controlfile;
backup as compressed backupset archivelog all
format '/home/oracle/backup/arch_ocmdb_%u%p%s.rmn'
delete all input;
}
3.使用默认备份介质目录和格式，同时 删除备份过的归档日志
backup as compressed backupset full database include current controlfile plus archivelog delete all input;
4.“一行RMAN命令”压缩备份数据库
backup as compressed backupset full database format
'/home/oracle/backup/full_ocmdb_%u%p%s.rmn' include current controlfile
plus
archivelog format '/home/oracle/backup/arch_ocmdb_%u%p%s.rmn' delete all input;
5.检查所有备份集
list backupset summary;
6.配置flashback数据库
闪回数据库：使用闪回日志恢复数据库到之前的一个时间点。
启动闪回前提条件是开启归档：归档日志可以辅助闪回日志完成闪回工作，往回闪不用归档，往前闪会用到归档。
1.检查数据库状态
select open_mode,log_mode,flashback_on from v$database; 是否在mount和archive状态
archive log list;
先设置快速恢复区大小再设置目录
alter system set db_recovery_file_dest_size=2g;
mkdir -p /home/oracle/flash
alter system set db_recovery_file_dest='/home/oracle/flash'; （保存闪回日志）
设置闪回保留期24小时（1天）单位是分钟
alter system set db_flashback_retention_target=1440 scope=spfile;
2.重启使参数生效
shutdown immediate
startup mount
show parameter db_recovery
启动闪回功能
alter database flashback on;
3.打开数据库
alter database open;
select open_mode,log_mode,flashback_on from v$database;
闪回种类
闪回查询 undo
闪回表 recycbin
闪回版本 undo
闪回事物 undo
闪回数据库 闪回日志
闪回归档 表空间（永久保存11g新特性）
来源OCM实验选讲
|