暂无图片
xtts 执行增量时报错
我来答
分享
只此无云
2022-06-30
xtts 执行增量时报错

xtts v3 执行 $ORACLE_HOME/perl/bin/perl xttdriver.pl -i  增量报错,错误如下:

--------------------------------------------------------------------
Starting incremental backup
--------------------------------------------------------------------

/data/xtts/scripts/incremental_Jun30_Thu_16_29_12_951//rmanincr.cmd

Recovery Manager: Release 12.2.0.1.0 - Production on Thu Jun 30 16:29:12 2022

Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.

RMAN-06005: connected to target database: XPORCL (DBID=2149971602)

RMAN> set nocfau;
2> host 'echo ts::APP_IDX';
3> backup incremental from scn 10853436934
4> tag tts_incr_update tablespace 'APP_IDX' format
5> '/data/rman_bak/%U';
6> set nocfau;
7> host 'echo ts::APP_BLOB';
8> backup incremental from scn 10853541514
9> tag tts_incr_update tablespace 'APP_BLOB' format
10> '/data/rman_bak/%U';
11> set nocfau;
12> host 'echo ts::APP_TBS';
13> backup incremental from scn 10853545334
14> tag tts_incr_update tablespace 'APP_TBS' format
15> '/data/rman_bak/%U';
16>
RMAN-03023: executing command: SET NOCFAU
RMAN-06009: using target database control file instead of recovery catalog

ts::APP_IDX
RMAN-06134: host command complete

RMAN-03090: Starting backup at 2022-06-30 16:29:14
RMAN-08030: allocated channel: ORA_DISK_1
RMAN-08500: channel ORA_DISK_1: SID=17307 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 06/30/2022 16:29:14
RMAN-20202: Tablespace not found in the recovery catalog
RMAN-06019: could not translate tablespace name "APP_IDX"

Recovery Manager complete.


!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Error:
------

Recovery Manager: Release 12.2.0.1.0 - Production on Thu Jun 30 16:29:12 2022

Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.

RMAN-06005: connected to target database: XPORCL (DBID=2149971602)

RMAN> set nocfau;
2> host 'echo ts::APP_IDX';
3> backup incremental from scn 10853436934
4> tag tts_incr_update tablespace 'APP_IDX' format
5> '/data/rman_bak/%U';
6> set nocfau;
7> host 'echo ts::APP_BLOB';
8> backup incremental from scn 10853541514
9> tag tts_incr_update tablespace 'APP_BLOB' format
10> '/data/rman_bak/%U';
11> set nocfau;
12> host 'echo ts::APP_TBS';
13> backup incremental from scn 10853545334
14> tag tts_incr_update tablespace 'APP_TBS' format
15> '/data/rman_bak/%U';
16>
RMAN-03023: executing command: SET NOCFAU
RMAN-06009: using target database control file instead of recovery catalog

ts::APP_IDX
RMAN-06134: host command complete

RMAN-03090: Starting backup at 2022-06-30 16:29:14
RMAN-08030: allocated channel: ORA_DISK_1
RMAN-08500: channel ORA_DISK_1: SID=17307 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 06/30/2022 16:29:14
RMAN-20202: Tablespace not found in the recovery catalog
RMAN-06019: could not translate tablespace name "APP_IDX"

Recovery Manager complete.
25
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!


请教各位大佬,指点一下,这一步为什么执行不下去?

我来答
添加附件
收藏
分享
问题补充
5条回答
默认
最新
只此无云

未能找到这个错误的原因,已经放弃使用xtts 传输表空间,来进行迁移。

改为使用PDB Refresh 迁移。

暂无图片 评论
暂无图片 有用 0
打赏 0
暂无图片
只此无云
升级问题到: 紧急故障
暂无图片 评论
暂无图片 有用 0
打赏 0
只此无云

数据库版本为:12.2.0.1.0

本次迁移表空间为PDB下的业务表空间。

暂无图片 评论
暂无图片 有用 0
打赏 0
cqiwen

RMAN-06019: could not translate tablespace name "APP_IDX"

要迁移的表空间没指定正确吗?目标端是否已经提前创建这个表空间?

暂无图片 评论
暂无图片 有用 0
打赏 0
只此无云
题主
2022-07-03
正确的,第一次-p 都是正常运行的。-i 就报错了。
cqiwen

exec dbms_tts.transport_set_check('APP_IDX',TRUE,TRUE);
select * from sys.transport_set_violations;

检查下这个表空间是否有自包含?另外看下 xtt.properties 的配置。


暂无图片 评论
暂无图片 有用 0
打赏 0
只此无云
题主
2022-07-03
检查了的,没有自包含
回答交流
Markdown


请输入正文
提交