暂无图片
xtts升级问题
我来答
分享
者行孙
2021-03-15
xtts升级问题
暂无图片 5M

Oracle aix 6.1 10.2.0.4能通过xtts直接升级到redhat 7.9 x86-64的19.8么

我来答
添加附件
收藏
分享
问题补充
3条回答
默认
最新
Jack.Li

可以。

Prerequisites
The following prerequisites must be met before starting this procedure:

The limitations and considerations for transportable tablespaces must still be followed. They are defined in the following manuals:
Oracle Database Administrator’s Guide
Oracle Database Utilities
In addition to the limitations and considerations for transportable tablespaces, the following conditions must be met:
The current version does NOT support Windows.
The source database must be running 10.2.0.3 or higher.
Cross platform is only possible with Enterprise Edition. This procedure cannot be used with Standard Edition.
The source database must have its COMPATIBLE parameter set to 10.2.0 or higher.
The source database’s COMPATIBLE parameter must not be greater than the destination database’s COMPATIBLE parameter.
The source database must be in ARCHIVELOG mode.
The destination database must be running 11.2.0.4 or higher.
Although preferred destination system is Linux (either 64-bit Oracle Linux or a certified version of RedHat Linux), this procedure can be used with other unix based operating systems.
The Oracle version of source must be lower or equal to destination. Therefore, this procedure can be used as an upgrade method. Restrictions to transportable tablespace will apply…
RMAN’s default device type should be configured to DISK
RMAN on the source system must not have DEVICE TYPE DISK configured with COMPRESSED. If so, procedure may return: ORA-19994: cross-platform backup of compressed backups different endianess.
The set of tablespaces being moved must all be online, and contain no offline data files. Tablespaces must be READ WRITE. Tablespaces that are READ ONLY may be moved with the normal XTTS method. There is no need to incorporate Cross Platform Incremental Backups to move tablespaces that are always READ ONLY.
All steps in this procedure are run as the oracle user that is a member of the OSDBA group. OS authentication is used to connect to both the source and destination databases.
If the Prepare Phase method selected is dbms_file_transfer, then the destination database must be 11.2.0.4. See the Selecting the Prepare Phase Method section for details.
If the Prepare Phase method selected is RMAN backup, then staging areas are required on both the source and destination systems. See the Selecting the Prepare Phase Method section for details.
It is not supported to execute this procedure against a standby or snapshot standby databases.
If the destination database version is 11.2.0.3 or lower, then a separate database home containing 11.2.0.4 running an 11.2.0.4 instance on the destination system is required to perform the incremental backup conversion. See the Destination Database 11.2.0.3 and Earlier Requires a Separate Incremental Convert Home and Instance section for details. If using ASM for 11.2.0.4 Convert Home, then ASM needs to be on 11.2.0.4, else error ORA-15295 (e.g. ORA-15295: ASM instance software version 11.2.0.3.0 less than client version 11.2.0.4.0) is raised.

暂无图片 评论
暂无图片 有用 0
打赏 0
者行孙

有没有实际这样做过呢?

暂无图片 评论
暂无图片 有用 0
打赏 0
Jack.Li

参考
11G - Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backup (Doc ID 1389592.1)

暂无图片 评论
暂无图片 有用 0
打赏 0
回答交流
Markdown


请输入正文
提交
相关推荐
新建用户疑问❓
回答 7
所以mkyps这个用户是可以查哪个其他用户的数据?
Oracle 查创建索引的默认 storage(next)大小的参数是哪个?
回答 1
INITRANS,该参数决定了索引块中可以保存的事务槽的数量
oracle rac 11g安装执行root.sh时报错
回答 11
监控状态贴一下,我感觉像是监控有问题。贴一下:/etc/hosts和listener.ora里的内容
有没有Oracle大牛,来回答一下这个问题
回答 4
上面已经讲的很清楚,我就不讲了
ins060001
回答 3
SSH互信可以通过手动配置,删除以前的,用sshkeygen一路回车。或者用数据库自带的脚本,有可能是openssh版本的问题或者bash版本问题;也有可能$HOME/.SSH或其中的文件由不同的用户
想学习MySQL的体系结构,有没有类似Oracle的ocp培训课程?
回答 3
已采纳
同学你好,恩墨学院提供全套MySQL OCP培训套餐哦;由一线技术专家交付培训,班级群提供辅导答疑。附大纲部分内容:若实际工作场景有深入学习需要,可进一步参加MySQL进阶的扩展学习。获取详
oracle 批量插入数据,怎么做?比如有10条数据。 是用for循环在程序里面一条一条地调用insert,还是其他方法? 还有,for循环能保证事务么?
回答 2
已采纳
例如,执行以下存储过程,即一次性提交:DECLAREBEGINFORiIN1..10LOOPinsertintolucifervalues(i,'test');ENDLOOP;END;/查询插入结果:
19c 集群安装过程中因为有问题,中断了,需要做哪些操作才能重新安装?
回答 1
有专门的清除脚本的rootcrs.pl
MySQL数据同步到oracle 数据库,一般采用什么方案?
回答 2
oceanbase数据库的oma工具
oracle11G数据库,经常出现ORA-04031错误。该如何优化?
回答 2
已采纳
1、问题原因1种:SGA区域比较小,可以将SGA区域的值,再设置大一些(至少达到服务器的内存的60%),然后在观察一段时间,看是否会在出现。若继续出现,那么要考虑以下几种因素,特别是AWRTOPSQL