BCD
"This method for transporting tablespaces requires that you place the tablespaces to be transported in read-only mode until you complete the transporting process. If this is undesirable, you can use the transportable tablespaces from backup feature" -> BC correct
MAX_DATAPUMP_JOBS_PER_PDB determines the maximum number of concurrent Oracle Data Pump jobs per PDB. -> D correct
https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/transporting-data.html#GUID-9304426D-9D40-4F0D-8661-F53B608A652F
https://docs.oracle.com/en/database/oracle/oracle-database/19/refrn/MAX_DATAPUMP_JOBS_PER_PDB.html#GUID-E911645F-2CA4-447D-AFB7-EBD4753AA09F
I think its ABD
A: there are 2 metjods of transporting tablesapces.
First, put source database live tablespace in read only mode and take metadata backup using Expdp.
Second, backup based using Rman that doesn't require source database tablespace to put in read only mode.
But during operation oracle create auxiliary instance restore & recover tablesapce from backup and take export of tablespace by puting them in read only mode.
so tablesapces never remain in read write mode during transportable tablespace operations.
B: TRANSPORTABLE = KEEP_READ_ONLY clause plugged0in tableapse can remain in read only mode.
D: init parameter MAX_DATAPUMP_JOBS_PER_PDB limits simultaneous data pump job at pdb level
According to this: https://docs.oracle.com/en-us/iaas/Content/Database/Tasks/mig-data-pump-transp-tablespace.htm
You MUST set thetablespaces to read-only to perfom these operations so A should be correct
BCD
This is a new feature in 19c and latest
https://docs.oracle.com/en/database/oracle/oracle-database/19/newft/new-features.html#GUID-8BAADCB7-F93A-48D0-BF24-369C4947C56B
"You can now import tablespace files mounted on two different databases as long as the files are set as read-only."
You can set read/only, so its not mandatory.
D is also correct for MAX_DATAPUMP_JOBS_PER_PBD parameter
The problem with this explanation is "You can now *import* as long as set to read only" not "You can *set to read only* to import"
so it does says that read only is mandatory, just the import itself is on you.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
RinD
Highly Voted 3 years, 3 months agoKishor123
2 years, 11 months agoanddeyyp
2 years, 12 months agoKuraudio
Most Recent 7 months agoGuhborges
1 year ago_gio_
1 year, 1 month agoScottL
1 year, 3 months agoleozanon94
2 years, 7 months agoasduta
2 years, 2 months agogon20
3 years, 3 months agomporislav
3 years, 3 months agomporislav
3 years, 2 months ago