请教如何配置一个缺省备份设备
情况是这样滴，我们用一个EMC Avamar设备作Oracle备份，需要先配置一个flag文件来记录用户名，密码和备份路径什么的--cat avtar_rman.log
--pidname=Oracle
--pidnum=1002
--logfile=/var/avamar/rman/avtar_rman.log
--vardir=/var/avamar
--id=<admin_user>
--ap=<admin_pwd>
--path=/linux_clients/pdbcluster03.els.ops.boingo.com
--expires=180
--ddr
--ddr-index=1
然后在Rman脚本里手工创建那个channel,并调用刚才那个flag file即可正常向Avamar server备份数据库或archive log --
RMAN> run{
allocate channel c1 type sbt PARMS="SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so";
send channel='c1' '"--prefix=11g/eprod01/" "--flagfile=/var/avamar/rman/avtar-flags.txt"
"--logfile=/var/avamar/rman/avtar_rman.log" "--bindir=/usr/local/avamar/bin"';
backup database plus archivelog;
release channel c1;
}
但这样就只能手工运行rman脚本来备份整个数据库，我们想能否在rman中将它配置成default channel，
例如能否做成 --
CONFIGURE DEFAULT DEVICE TYPE SBT;
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS'SBT_LIBRARY=mylibrary.disksbt,ENV=(BACKUP_PARAM=value)';
但是我不会将
allocate channel c1 type sbt PARMS="SBT_LIBRARY=/usr/local/avamar/lib/libobk_avamar64.so";
send channel='c1' '"--prefix=11g/eprod01/" "--flagfile=/var/avamar/rman/avtar-flags.txt"
"--logfile=/var/avamar/rman/avtar_rman.log" "--bindir=/usr/local/avamar/bin"';
合并成一句 -- configure channel device....
所以就没法将这个Avamar 设备配成default channel， 实在没法解决。恳请各位大侠帮忙。
Thanks in advance for any help. 本帖最后由 Eisen 于 2016-02-17 11:33 编辑
目前的rman设置为 -
$ rman target /;
Recovery Manager: Release 11.2.0.1.0 - Production on Tue Feb 16 03:20:28 2016
Copyright (c) 1982, 2009, Oracle and/or its affiliates.All rights reserved.
connected to target database: ORCL (DBID=1330766534)
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF;
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE SBT_TAPE TO '%F'; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS'AVTAR/Avamar backup (EMC)';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'MEDIUM' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/home/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/snapcf_orcl.f'; # default
就这最后这个 configure channel device type 'SBT_TAPE' PARMS后面怎么写不会了。 求帮助，多谢
页:
[1]