RMAN

Virtual Classroom Seminar 12: Migrating Very Large Databases on Dec 9, 2021

Posted on December 8, 2021 by Workshop 2

It looks to me that every possible event in 2021 happens in October/November/December 2021. No complaint from my side – but just in case you wonder about so little update activity on our blogs since weeks. We are just so busy in delivering virtual seminars. Which is good – but it requires lots of effort on our side as we want to deliver decent quality and real tech content. And now, since the year is almost at its end, it is time for our final Virtual Classroom Seminar 12: Migrating Very Large Databases on Dec 9, 2021 this year.

Virtual Classroom Seminar 12: Migrating Very Large Databases on Dec 9, 2021

Photo

… Continue reading...

Different MOS Notes for xTTS PERL scripts – Use V4 scripts

Posted on January 28, 2019 by Transportable 67

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?

Photo by VanveenJF on Unsplash

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 …

Continue reading...

RMAN Backup Gives RMAN-06091: No Channel Allocated for Maintenance

Posted on August 21, 2018 by Flaws and Pitfalls RMAN 17

RMAN Backup Gives RMAN-06091: No Channel Allocated for MaintenanceI really don’t want to turn this blog into an accumulation of issues and flaws. But as I explained many times before, the blog for me is also a way to dump information I likely will need the sooner or later again.

Recently I blogged about another RMAN issue in Oracle 12.2.0.1 with traces. This was fixed with the July 2018 RU for Oracle 12.2.0.1. But the issue below about which Piero Ferraz from Brazil alerted me (thanks!!!), happens in exactly this RU.

RMAN Backup Gives RMAN-06091: No Channel Allocated for Maintenance

This issue gets introduced with the July …

Continue reading...

ZDLRA ready for Oracle Database 18c

Posted on July 23, 2018 by MAA RMAN 7

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

ZDLRA ready for Oracle Database 18cWhy am I writing about this? Some of the customers …

Continue reading...

RMAN backup generates traces in Oracle 12.2.0.1

Posted on May 24, 2018 by Flaws and Pitfalls 5

RMAN backup generates traces in Oracle 12.2.0.1Oracle 12.2.0.1 seems to be the “tracing” release without further patch or parameter treatments. After posting about MMON unconditional traces in Oracle 12.2.0.1 a day ago, I received a couple of comments either on the blog, via LinkedIn or Twitter regarding other trace facilities in Oracle Database 12.2.0.1. One of them is the case that RMAN backup generates traces in Oracle 12.2.0.1.

And please, very important upfront:
Oracle Database 12.2.0.1 is a very stable and reliable release based on all the customer feedback Roy and I received so far. For instance, when we check for optimizer issues …

Continue reading...

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

Posted on October 7, 2016 by Patch Recommendation RMAN 3

Related blog posts:

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 …

Continue reading...

MOS Note:136697.1 – New HCHECK.SQL for Oracle Database 12c

Posted on May 19, 2016 by Flaws and Pitfalls RMAN 0

A while back we added this slide to our big slide deck:

The story behind this slide

A large and important customer in the US tested a patch set upgrade – but when they approached the production upgrade from 11.2.0.2 to 11.2.0.3 on a large RAC cluster they’ve had to cancel the attempt and revert to the previous state.

Reason

They’ve hit a dictionary corruption somewhere silently sleeping in the database causing no trouble at all so far – until the upgrade touched the broken structures

They’ve asked us:
“How could we ensure the database is really healthy and …

Continue reading...

RMAN Catalog Upgrade fails – ORA-02296 – error creating modify_ts_pdbinc_key_not_null

Posted on April 19, 2016 by Flaws and Pitfalls RMAN 4

This issue got raised to my via a customer I know for quite a while – all credits go to Andy Kielhorn for digging down into that issue and solving it.

Failed RMAN Catalog Upgrade from 11.2.0.4 to 12.1.0.2

The RMAN catalog upgrade:

SQL> @?/rdbms/admin/dbmsrmansys.sql

$ rman CATALOG rman/xxx@rman01

RMAN> UPGRADE CATALOG; 

RMAN> UPGRADE CATALOG;

failed with the following sequence of error messages:

error creating modify_ts_pdbinc_key_not_null
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06004: ORACLE error from recovery catalog database: ORA-02296: cannot enable (RMAN.) - null values found

error creating modify_tsatt_pdbinc_key_not_null
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR
… Continue reading...

DBUA and Read-Only Tablespaces – Things to Know II

Posted on March 30, 2016 by DBUA Flaws and Pitfalls Oracle Database 12c 3

Related Blog Posts:

Thanks to Rodolfo Baselli commenting on a previous blog post about the DBUA and Read-Only Tablespaces I dug a bit deeper and found out that “assuming silently” does not mean “works as intended“.

But one piece after another.

Rodolfo commented that if he …

Continue reading...

DBUA and Read-Only Tablespaces – Things to Know – I

Posted on February 3, 2016 by DBUA Flaws and Pitfalls Oracle Database 12c 13

Related Blog Posts:

Some people prefer the manual upgrade on the command line, others prefer the graphical tool Database Upgrade Assistant (DBUA).

DBUA and Read-Only Tablespaces 

The DBUA offers you an option of setting your non-Oracle tablespaces read-only during the upgrade.

DBUA Read Only 1

What the option doesn’t tell you …

Continue reading...

RMAN NOOPEN Clause DUPLICATE FOR UPGRADE

Posted on January 11, 2016 by Data Guard Oracle Database 12c RMAN Upgrade / Migration 10

In Oracle Database 12c, the RMAN “DUPLICATE” command has new “NOOPEN” option which clones the database but does not open the auxiliary instance. This feature can be used to duplicate a database to higher version.

MOS Note: 2022820.1
Upgrade to 12c database using RMAN Duplicate with NOOPEN clause

The note contains also a full example on how to duplicate the production database as a standby, and upgrade it.

–Mike…

Continue reading...

RMAN Catalog requires Enterprise Edition (EE)
since Oracle Database 12.1.0.2

Posted on August 14, 2014 by Flaws and Pitfalls RMAN 26

Credits go to Cameron Hodge, Malcom and Martin Mäs who all highlighted issues to me following my previous entry about RMAN – and sorry for any disappointment but I wasn’t aware of all these nice little things.

Ok, you’d upgrade your RMAN Catalog to be ready to backup/recover Oracle Database 12.1.0.2 databases and you see this error:

RMAN>
upgrade catalog;
error creating create_deleted_object_seq
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06004: ORACLE error from recovery catalog database:
ORA-00439:  feature not enabled: Partitioning

Now you start to wonder as your Catalog Database had been an Oracle Standard …

Continue reading...

RMAN Catalog Upgrade to Oracle 12.1.0.2

Posted on August 11, 2014 by Flaws and Pitfalls RMAN 15

It sounds so simple – but in this specific case a bit of doc reading is required as upgrading the RMAN catalog to handle Oracle 12.1.0.2 databases is not as trivial as in the past.

Thanks to a German customer and a friendly colleague from Sales Consulting in Stuttgart I have learned my RMAN lesson for Oracle Database 12.1.0.2 this week. A simple “upgrade catalog” is not the correct step once you’d like to handle backups of Oracle 12.1.0.2 databases in your current catalog schema. 

Even though you may not have ever heard before about Virtual Private …

Continue reading...

Fundamental Oracle flaw revealed??? Update …!

Posted on January 26, 2012 by Flaws and Pitfalls 0

Writing a blog has a nice effect on the side: it brings me in touch with people I’ve never met – but we have similar targets or interests. Today I’ve received a comment from Gökhan Atil about the Fundamental Oracle Flaw known also as the SCN issue.

And for sure I did visit Gökhan’s blog and I did watch his very interesting 5 minutes demonstration how to bring down a database with the SCN issue. Which is very good to know as I thought the database won’t come down because of this issue. But watch Gökhan’s video by …

Continue reading...

Fundamental Oracle flaw revealed??? Really …?

Posted on January 19, 2012 by Flaws and Pitfalls 2

This Infoworld article from Jan 17, 2012  Fundamental Oracle flaw revealed did alert Oracle database customers.Infoworld has raised this issue to Oracle before going public with it. Patches are included in the Jan 2012 CPU and PSU. So again, it’s strongly recommended to apply the Jan 2012 PSU (or CPU if you are just asking for security fixes) to your environments.

… Continue reading...
Mike Dietrich
Oracle Senior Director of Product Manager for Database Upgrade, Migrations and Patching writing just another blog.

Opinions certainly are my own as is this page.

Archives

Categories

Upgrade @YouTube

Subscribe via Email

Join 7,887 other subscribers

Follow me on Twitter