Different MOS Notes for xTTS PERL scripts – Use V4 scripts

A long time ago my colleagues published PERL scripts to assist especially with cross platform Transportable Tablespace migrations. The PERL scripts allow you to utilize incremental backups. This way you can decrease the downtime in a migration with large databases significantly. But there are different MOS Notes for xTTS PERL scripts available. Which one should you take? Transportable Tablespaces and Incremental Backups The biggest pain points in a transportable tablespace migration are usually the size of the database and its complexity. With RMAN Incrementally Rolled Forward Backups you can tackle the size aspect. Instead of having a long downtime to…

OOW 2018: Cloud Migration from AIX to ExaCC – for DBAs and managers

Yes, OOW starts next week. And I’d like to introduce the third of our 4 talks. And let me say upfront about this talk atΒ OOW 2018: Cloud Migration from AIX to ExaCC – for DBAs and managers. This is not the usual “cloud” talk πŸ™‚ The official title is: Oracle Database Cloud Migration: Fast, Simple, Universal. Well, we should discuss the “simple“. But that’s why you want to see this talk. It will happen on Thursday, 9:00 a.m.. Hence, remember to leave the party the night before not too late. You need to be awake when you visit our talk…

ZDLRA ready for Oracle Database 18c

ZDLRA is one of the best acronyms ever. It took me 5+ years to not mix up the sequence of characters πŸ™‚ And even Larry made a joke about the name a while ago at his OOW keynote (I think it was 2016). ZDLRA stands for Zero Data Loss Recovery Appliance. And that basically tells you what it is. Hence, it isn’t a bad acronym as it tells you straight forward what it does. Good news: ZDLRA ready for Oracle Database 18c. ZDLRA ready for Oracle Database 18c Why am I writing about this? Some of the customers I’m working…

RMAN Recovery Catalog with July PSU: How to resolve RASCHEMAVER and BASCHEMAVER schema mismatch

Related blog posts: RMAN Catalog Upgrade fails – ORA-02296 – error creating modify_ts_pdbinc_key_not_null (April 19, 2016) RMAN Catalog requires Enterprise Edition (EE) since Oracle Database 12.1.0.2 (April 22, 2016) RMAN Catalog Upgrade to Oracle 12.1.0.2 (August 1, 2014) Thanks to Ah Huat Tan from Amway IT Services for keeping me updated! Actually as I see that more people who got hit by this issue so I’d consider it to be worth to write about it. Problem and Analysis You’d apply the July 2016 PSU or BP. According to the readme you are required to upgrade your RMAN catalog afterwards. The…