Database Administration (MOSC)

MOSC Banner

How to get around the single threaded PDB archive process?

edited Feb 28, 2024 4:21PM in Database Administration (MOSC) 7 commentsQuestion

For: Oracle RDBMS (all editions) 19c (using 19.17)

I have an outstanding Oracle service request (SR) that I logged over a year ago and I still do not have an answer from Oracle support about this. So I'm reaching out to see if anyone in Oracle land has come up with a reasonable workaround.

Basically, if you do something like the following two steps you will create a PDB archive using Oracle's single threaded unplug operation:

alter pluggable database PDB1 close immediate;

alter pluggable database PDB1 unplug into '/u01/PDB_Archives/PDB1.pdb';

However, if you were to unplug using XML and then use something like 7zip to create the archive you can take advantage of your RDBMS host CPUs to create the archive much, much faster. This is true regardless of what type of storage system you have.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center