Oracle Migration from on-premises using DMS and Rman
Customer that is testing the migration process from Oracle On-premises to Oracle on EC2. They're performing:
- backup using RMAN from an Oracle Database 11GR2 on-premises.
- Restore it on Oracle 18c with upgrade option on EC2.
- Start a replication from on-premises 11G to ec2 18c AWS using SCN.
Does it work?
As I could see in our documentation we can do it using datapump: https://aws.amazon.com/blogs/database/migrating-oracle-databases-with-near-zero-downtime-using-aws-dms/ But can we do the same steps and instead of datapump use rman?
Thank you very much!
- 최신
- 최다 투표
- 가장 많은 댓글
Simple answer to your question is, Yes it'll work. Only point customer should understand is that SCN should be taken before starting the RMAN. Then when you start replication you need to specify the SCN that was noted earlier. This way customer will be able to ensure all changes before the start of RMAN are being captured in pushed to target database.
However I have worked with few customers who have successfully migrated using combination of Datapump (for Full load) and CDC (for ongoing replication changes) using the blog already mentioned by you.
관련 콘텐츠
- 질문됨 4달 전
AWS 공식업데이트됨 2년 전- AWS 공식업데이트됨 4년 전
