RELATEED CONSULTING
相关咨询
选择下列产品马上在线沟通
服务时间:8:30-17:00
你可能遇到了下面的问题
关闭右侧工具栏

新闻中心

这里有您想知道的互联网营销解决方案
rman备份时如何指定备份到两个目录下

这期内容当中小编将会给大家带来有关rman备份时如何指定备份到两个目录下,文章内容丰富且以专业的角度为大家分析和叙述,阅读完这篇文章希望大家可以有所收获。

创新互联建站2013年至今,先为海南州等服务建站,海南州等地企业,进行企业商务咨询服务。为海南州企业网站制作PC+手机+微官网三网同步一站式服务解决您的所有建站问题。

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备份时如何指定备份到两个目录下了,如果刚好有类似的疑惑,不妨参照上述分析进行理解。如果想知道更多相关知识,欢迎关注创新互联行业资讯频道。


标题名称:rman备份时如何指定备份到两个目录下
网站路径:http://scyingshan.cn/article/pocceh.html