Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Cross-Platform Database Migration Using RMAN without placing tablespaces Read Only

User_UHYSQMar 8 2022

Best regards, Dear Friends.
Please, I require your support, in terms of guiding me on the best path I should take for the following activity:
We need to clone an Oracle database with the following characteristics
##################################################
Source Database:
Version: Oracle Database 11g EE Release 11.2.0.4.0 - 64bit
LOG_MODE: ARCHIVELOG
Single Instance: YES
Same Server: NO
Same Endian: NO (BIG)
OS: AIX 7.2.2.16 TL02
Storage: ASM (DiskGroup)
Preferred method for cloning: RMAN: (To maintain data integrity).
Planned downtime: It's not possible.
Can set tablespaces to Read Only: It's not possible.
Database Size: 2.5 TB
Multitenant: No
##################################################
Target Database (New Database):
Versión: Oracle Database 19c EE Release 19.10.0.0.0
LOG_MODE: ARCHIVELOG
Single Instance: YES
Same Server: NO
Same Endian: NO (Little)
OS: Red Hat Enterprise Linux Server 7.4
Software Oracle RDBMS and GRID 19c installed and configured: YES
Storage: ASM (DiskGroup)
Preferred method for cloning: RMAN: (To maintain data integrity).
Database Size: 2.5 TB
Multitenant: No
Database created: NO (It will be created from the cloning of the Source Database)
##################################################
Dear, I have reviewed several notes regarding performing Cross platform migration, but all that I have found indicate that in the Source Database the Tablespaces must be placed in Read Only.
I do not have the possibility to put the tablespaces in read only because the source database is used by an application on which unavailability cannot be generated.
I tried doing this activity via expdp/impdp but it was inconsistent, expdp failed many times, many objects were not exported and when importing many objects they were decompiled by dependencies, so I had to drop this database and consider using RMAN to clone it.
Please can you guide me on the best path I should take in the proposed cloning scenario.
Thank you very much for your time and support.
Best regards.

Comments
Post Details
Added on Mar 8 2022
3 comments
682 views