首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >RMAN备份-使用相同命令的不同输出

问RMAN备份-使用相同命令的不同输出
EN

Stack Overflow用户
提问于 2019-02-05 05:55:14
回答 1查看 235关注 0票数 1

我看到使用"format keyword“的RMAN 'backup database‘命令的输出或行为不同,因为我将语法的一部分放在中间,另一部分放在最后,它将备份存储在不同的位置,如下面的情况所述

在下面的情况1中-我在中间使用了format关键字,它将备份集保存在定义的位置,但是如果我在最后使用带有format关键字的相同命令,它会将备份片段存储在ORACLE_HOME/dbs位置。不确定,为什么它会这么做。任何想法都是值得欣赏的。

注意:-法兰克福机场参数未启用,因为之前它在使用case2时将备份条目存储到法兰克福机场位置。

案例1:-在中间使用format关键字。

代码语言:javascript
复制
RMAN> backup format '/o/export/export/cold_test/backup_%U_%u_%t_%d' incremental level 0 database plus archivelog ;


Starting backup at 04-FEB-19
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=283 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=16 RECID=16 STAMP=999351604
input archived log thread=1 sequence=17 RECID=17 STAMP=999351609
input archived log thread=1 sequence=18 RECID=18 STAMP=999351923
channel ORA_DISK_1: starting piece 1 at 04-FEB-19
channel ORA_DISK_1: finished piece 1 at 04-FEB-19
piece handle=/o/export/export/cold_test/backup_1stp1pjj_1_1_1stp1pjj_999351923_TEST tag=TAG20190204T134523 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 04-FEB-19

Starting backup at 04-FEB-19
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA_01/TEST/DATAFILE/tnext_indx.dbf
input datafile file number=00005 name=+DATA_01/TEST/DATAFILE/tnext_data.dbf
input datafile file number=00007 name=+DATA_01/TEST/DATAFILE/tnext_data02.dbf
input datafile file number=00008 name=+DATA_01/TEST/DATAFILE/tnext_data03.dbf
input datafile file number=00003 name=+DATA_01/TEST/DATAFILE/sysaux.dbf
input datafile file number=00001 name=+DATA_01/TEST/DATAFILE/system.dbf
input datafile file number=00004 name=+DATA_01/TEST/DATAFILE/undotbs1.dbf
input datafile file number=00006 name=+DATA_01/TEST/DATAFILE/users.dbf
channel ORA_DISK_1: starting piece 1 at 04-FEB-19
channel ORA_DISK_1: finished piece 1 at 04-FEB-19
piece handle=/o/export/export/cold_test/backup_1ttp1pjk_1_1_1ttp1pjk_999351924_TEST tag=TAG20190204T134524 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 04-FEB-19
channel ORA_DISK_1: finished piece 1 at 04-FEB-19
piece handle=/o/export/export/cold_test/backup_1utp1pjr_1_1_1utp1pjr_999351931_TEST tag=TAG20190204T134524 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 04-FEB-19

Starting backup at 04-FEB-19
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=19 RECID=19 STAMP=999351933
channel ORA_DISK_1: starting piece 1 at 04-FEB-19
channel ORA_DISK_1: finished piece 1 at 04-FEB-19
piece handle=/o/export/export/cold_test/backup_1vtp1pjt_1_1_1vtp1pjt_999351933_TEST tag=TAG20190204T134533 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 04-FEB-19

RMAN>

案例2:在备份命令的末尾使用format关键字。

代码语言:javascript
复制
RMAN> backup incremental level 0 database plus archivelog format '/o/export/export/cold_test/backup_%U_%u_%t_%d' ;


Starting backup at 04-FEB-19
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=283 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=16 RECID=16 STAMP=999351604
input archived log thread=1 sequence=17 RECID=17 STAMP=999351609
input archived log thread=1 sequence=18 RECID=18 STAMP=999351923
input archived log thread=1 sequence=19 RECID=19 STAMP=999351933
input archived log thread=1 sequence=20 RECID=20 STAMP=999352079
input archived log thread=1 sequence=21 RECID=21 STAMP=999352087
input archived log thread=1 sequence=22 RECID=22 STAMP=999358913
channel ORA_DISK_1: starting piece 1 at 04-FEB-19
channel ORA_DISK_1: finished piece 1 at 04-FEB-19
piece handle=/o/export/export/cold_test/backup_29tp20e1_1_1_29tp20e1_999358913_TEST tag=TAG20190204T154153 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 04-FEB-19

Starting backup at 04-FEB-19
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00002 name=+DATA_01/TEST/DATAFILE/tnext_indx.dbf
input datafile file number=00005 name=+DATA_01/TEST/DATAFILE/tnext_data.dbf
input datafile file number=00007 name=+DATA_01/TEST/DATAFILE/tnext_data02.dbf
input datafile file number=00008 name=+DATA_01/TEST/DATAFILE/tnext_data03.dbf
input datafile file number=00003 name=+DATA_01/TEST/DATAFILE/sysaux.dbf
input datafile file number=00001 name=+DATA_01/TEST/DATAFILE/system.dbf
input datafile file number=00004 name=+DATA_01/TEST/DATAFILE/undotbs1.dbf
input datafile file number=00006 name=+DATA_01/TEST/DATAFILE/users.dbf
channel ORA_DISK_1: starting piece 1 at 04-FEB-19
channel ORA_DISK_1: finished piece 1 at 04-FEB-19
piece handle=/o/oracle/DB12102/dbs/2atp20e2_1_1 tag=TAG20190204T154154 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 04-FEB-19
channel ORA_DISK_1: finished piece 1 at 04-FEB-19
piece handle=/o/oracle/DB12102/dbs/2btp20e6_1_1 tag=TAG20190204T154154 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 04-FEB-19

Starting backup at 04-FEB-19
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=23 RECID=23 STAMP=999358920
channel ORA_DISK_1: starting piece 1 at 04-FEB-19
channel ORA_DISK_1: finished piece 1 at 04-FEB-19
piece handle=/o/export/export/cold_test/backup_2ctp20e8_1_1_2ctp20e8_999358920_TEST tag=TAG20190204T154200 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 04-FEB-19

RMAN>

谢谢,DBA

EN

回答 1

Stack Overflow用户

发布于 2019-02-07 19:27:29

backup命令包含两种密钥文件格式。第一个密钥格式定义了数据库本身的备份文件的位置和格式,第二个密钥格式定义了归档日志的备份文件的位置和格式。

代码语言:javascript
复制
RMAN> backup format '/o/export/export/cold_test/backup_%U_%u_%t_%d'  incremental level 0 database plus archivelog format '/o/export/export/cold_test/backup_%U_%u_%t_%d' ;
票数 0
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/54524889

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档