rman configure命令
来源:互联网 发布:淘宝网10至20包邮 编辑:程序博客网 时间:2024/06/05 14:21
记录rman的命令,备忘
连接到目标数据库: BACK (DBID=4048592102)
连接到恢复目录数据库
RMAN> 2> show all;
RMAN 配置参数为:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'd:\backup\control_%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SNCFBACK.ORA'; # default
介绍一下参数
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
这两个备份策略只能两个取一,不能共存。
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'd:\backup\control_%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET; --备份的并行度和备份压缩
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SNCFBACK.ORA'; # default --备份文件的镜像
- rman configure命令
- RMAN中常用configure命令
- 【RMAN】【RMAN命令】CONFIGURE命令(1)--RMAN 配置参数说明
- RMAN CONFIGURE
- RMAN CONFIGURE
- RMAN CONFIGURE
- RMAN CONFIGURE
- Oracle Rman 命令详解(List report backup configure)
- Oracle Rman 命令详解(List report backup configure)
- Oracle Rman 命令详解(List report backup configure)
- Oracle Rman 命令详解(List report backup configure)
- Oracle Rman 命令详解(List report backup configure)
- Oracle Rman 命令详解(List report backup configure)
- Oracle Rman 命令详解(List report backup configure)
- Oracle Rman 命令详解(List report backup configure)
- Oracle Rman 命令详解(List report backup configure)
- Oracle Rman 命令详解(List report backup configure) .
- Oracle Rman 命令详解(List report backup configure)
- 一种快速的无监督的向量化方法做地标识别
- association 的使用
- ActiveX组件开发和使用
- HDU4920 Matrix multiplication (CPU cache对程序的影响)
- Python中的条件选择和循环语句
- rman configure命令
- mysql由浅入深视频-有高可用架构、调优、排错等
- const使用及问题总结
- 匹配一个2个相邻并且相同的字符
- LA 4329 Ping pong乒乓比赛【树状数组】
- 找朋友
- java播放声音
- 功能强大的sscanf函数(2)之正则表达式
- java TIFF转JPG并压缩