ITPub博客

首页 > 数据库 > Oracle > RMAN备份之参数(待完善)

RMAN备份之参数(待完善)

原创 Oracle 作者:天地展飞扬 时间:2016-03-24 16:29:01 0 删除 编辑














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博客 ” ,链接:https://blog.itpub.net/29757060/viewspace-2063243/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2014-07-17

  • 博文量
    2
  • 访问量
    9180