ITPub博客

首页 > Linux操作系统 > Linux操作系统 > rman备份时指定备份到两个目录下

rman备份时指定备份到两个目录下

原创 Linux操作系统 作者:paulyibinyi 时间:2008-01-03 10:56:37 0 删除 编辑

itpub上看的一个问题

1rman备份时应该可以指定备份到两个目录下吧?这样就不用手动去拷贝了.那要如何实现?

 

RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

old RMAN configuration parameters:
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
new RMAN configuration parameters:
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'd:\backup\%U','d:\tools\%U';

old RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   'd:\backup\%U',   'd:\tools\%U';
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   'd:\backup\%U',   'd:\tools\%U';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
released channel: ORA_DISK_1

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
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\%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT   'd:\backup\%U';
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   'd:\backup\%U',   'd:\tools\%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ORACLE\ORA92\DATABASE\SNCFPAUL.ORA';
# default
RMAN configuration has no stored or default parameters

RMAN> backup database format 'd:\backup\%U','d:\tools\%U';

Starting backup at 03-JAN-08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=15 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=D:\ORACLE\ORADATA\PAUL\SYSTEM01.DBF
input datafile fno=00002 name=D:\ORACLE\ORADATA\PAUL\UNDOTBS01.DBF
input datafile fno=00006 name=D:\ORACLE\ORADATA\PAUL\TS_TEST01.DBF
input datafile fno=00003 name=D:\ORACLE\ORADATA\PAUL\INDX01.DBF
input datafile fno=00005 name=D:\ORACLE\ORADATA\PAUL\USERS01.DBF
input datafile fno=00004 name=D:\ORACLE\ORADATA\PAUL\TOOLS01.DBF
channel ORA_DISK_1: starting piece 1 at 03-JAN-08
channel ORA_DISK_1: finished piece 1 at 03-JAN-08 with 2 copies
piece handle=D:\BACKUP\4NJ57K6P_1_1 comment=NONE
piece handle=D:\TOOLS\4NJ57K6P_1_2 comment=NONE                   --两个路径下生成的备份文件

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:57
Finished backup at 03-JAN-08

Starting Control File and SPFILE Autobackup at 03-JAN-08
piece handle=D:\BACKUP\C-1605165889-20080103-01 comment=NONE
Finished Control File and SPFILE Autobackup at 03-JAN-08

RMAN>

 

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

请登录后发表评论 登录
全部评论
学习数据库

注册时间:2007-12-11

  • 博文量
    902
  • 访问量
    6575874