RMAN备份之参数（待完善）

oracle@Redhat55.cuug.net:/home/oracle> rman target/
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Mar 24 02:59:43 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
connected to target database: TESTDB12 (DBID=2811829300)
RMAN> host;
[oracle@Redhat55 ~]$ exit
exit
host command complete
RMAN> 
---显示所有的参数
RMAN> show all;
RMAN configuration parameters for database with db_unique_name TESTDB12 are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default ---默认备份到硬盘，SBT是磁带设备
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default---是否自动备份控制文件
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default---指定备份控制文件的格式
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default---指定备份文件的属性为backupset，介质为硬盘的可以是backupset或者是imagecopies介质为tape的只能是backupset，如果需要压缩TO COMPRESSED BACKUPSET，默认是非压缩文件。
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_TestDB12.f'; # default


---如果不指定下列参数，默认是存放在fast_recovery_area下面
CONFIGURE CHANNEL DEVICE TYPE DISK MAXPIECESIZE 2G;---此属性只对最后一次指定的参数有效，之前指定的参数会恢复到默认值
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/disk1/ora_df%t_s%s_s%p';---指定备份文件的路径和命名规则，%t 四位的时间戳, %s 备份集数, %p 备份片数.
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT /tmp/%U;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '+dgroup1';---指定ASM磁盘组为存储位置
#default表示此处参数是默认的值
---显示指定的参数
SHOW RETENTION POLICY;
SHOW DEFAULT DEVICE TYPE;
---将参数恢复到默认值
CONFIGURE BACKUP OPTIMIZATION CLEAR;
CONFIGURE RETENTION POLICY CLEAR;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK CLEAR;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29757060/viewspace-2063243/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29757060/viewspace-2063243/