![\"\"](\"https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2021\/10\/img_617a923b0d2d8.png\")
<\/p>\nToday my experiment will be upgrading 12.2 (Oct 2021 RU & OJVM), running in the non-CDB mode, to the latest 19c version (currently it is 19.13) in multitenant architecture. The idea of this scenario is to validate and test not only the upgrade process but especially the downgrade strategy.<\/p>\n
<\/p>\n
I will keep the COMPATIBLE parameter of my 19c target as 12.2.0 so I can try my fallback strategy without any issues.<\/p>\n
The first important thing to note here is that the non-cdb to pdb conversion is not reversible. So that’s why I plan to use transportable tablespaces as my fallback plan.<\/p>\n
However, before anything, I’ve already blogged about transportable tablespace not working to previous releases<\/a>. So my plan will be breaking the fallback to 12.2 in 2 stages:<\/p>\n My playground will be:<\/strong><\/p>\n Note that my target DB, I haven’t used the General_Purpose template as I want this database to have a lower COMPATIBLE (12.2.0). For more details on how to create a 19c with lower compatibility, check this article<\/a>.<\/p>\n I will need a transient fallback database for this exercise. It will be exactly the same as the Source DB but in CDB mode.<\/p>\n In my 12c non-cdb source system, I will create some user data, so I can check them later after the migration.<\/p>\n The first step is to perform the upgrade of the 12c non-cdb to 19c cdb. I will use AutoUpgrade as it automates most of the tasks for me.<\/p>\n My config file has:<\/p>\n As I’m also moving to a new server, I will break the AutoUpgrade<\/strong> in the 3 steps approach<\/a>. Please note you don’t need to break it into 3 phases if you have the new Oracle Home version already deployed on that same server.<\/p>\n So first, let me start with the analyze<\/strong> phase:<\/p>\n Next, the fixups<\/strong>:<\/p>\n The last step is to stop the database and move all the database and configuration files (including datafiles, controlfiles, spfile, pwfile) and also the files generated by AutoUpgrade tool (upgrade.cfg<\/em> and \/u01\/app\/oracle\/cfgtoollogs\/autoupgrade\/<\/em> folder) to the new server. Note again you won’t need this if you are upgrading to the same server.<\/p>\n After everything is placed, I need to start up the database in 19c Oracle Home in upgrade mode:<\/p>\n And finally, I will call the upgrade<\/strong> phase of AutoUpgrade on the target machine:<\/p>\n Now just checking if my database was really upgraded:<\/p>\n Now that I’m on 19c, let’s imagine a fallback scenario. After running my production in this environment for some time, I want to move back to the original 12c database. I can’t simply restore a backup as I already had some production workload executed in this new database. So a downgrade is the only option I have.<\/p>\n First, I will add a new table to my tablespace:<\/p>\n Let’s start the downgrading process. I followed the official documentation<\/a> but there is also a MOS Note<\/a> for it.<\/p>\n The overall steps are:<\/p>\n First, I need to clean (or backup) the UNIFIED_AUDIT_TRAIL in that container:<\/p>\n The next step is to start up the pluggable database in downgrade mode:<\/p>\n Finally, calling the $ORACLE_HOME\/bin\/dbdowngrade<\/strong><\/em> wrapper:<\/p>\n As you can see above. No errors were returned.<\/p>\n Now, the next step is to unplug this PDB from 19c CDB and plug it back on a 12c CDB. As I’ve shown before, I’ve created a “fallback database” to hold it, as my original 12c database was in non-cdb architecture.<\/p>\n Let’s unplug it:<\/p>\n Now I move the XML file and all the datafiles to the source system. Remember this is not required if they reside on the same server. Finally, I will plug it back to the 12c CDB:<\/p>\n And the last step is to run catrelod.sql<\/strong><\/em>, to recreate the database objects for the 12c version:<\/p>\n Now I’m with my CDB is back in 12c:<\/p>\n Perfect. At this point, we are back to 12c, however not exactly as before as now we are in multitenant architecture. The next and final step, if I really want to fall back to the same scenario I was before, would be using TTS to move all my data back to the original system. Let’s try it:<\/p>\n I will also change the default tablespace of my dba “TEST” user from USER to SYSTEM as I will run expdp with it, and datapump needs to create some temporary tables:<\/p>\n Now calling expdp for transportable:<\/p>\n Now, finally, I will import the data back to a non-cdb 12c. I don’t recommend you to use the original one as the target database here. Instead, create a new empty in non-cdb mode. That way, you won’t have any conflict with existing objects and you can even compare later with the original for any difference.<\/p>\n As the USERS tablespace already exists on a out-of-box database, I will just rename it to USERS_OLD to avoid conflict on the FTTS import.<\/p>\n I will position the datafiles and the dump file created by the expdp ftts process in the location I want.<\/p>\n Calling now the impdp:<\/p>\n I got 5 errors, but in this case that can be safely ignored as they are related to objects that already exist.<\/p>\n Now checking my tables:<\/p>\n And that’s it! As you can see, there is no mystery about moving forward and back from 19c PDB to 12.2 NON-CDB.<\/p>\n Don’t forget to always try the full upgrade\/downgrade process in a “prod like” environment before.<\/p>\nHave you enjoyed? Please leave a comment or give a ?!<\/b>\n![\"\"](\"https:\/\/dev.dbarj.com.br\/wp-content\/uploads\/2021\/10\/img_617a927698bf4.png\")
<\/p>\nSource DB (12.2):<\/strong><\/h4>\n
\n
\n
\n
dbca -silent -createDatabase \\\r\n-gdbName orcl \\\r\n-templateName General_Purpose.dbc \\\r\n-characterSet AL32UTF8 \\\r\n-createAsContainerDatabase false \\\r\n-databaseConfigType SINGLE \\\r\n-databaseType MULTIPURPOSE \\\r\n-datafileDestination \/u01\/app\/oracle\/oradata \\\r\n-dvConfiguration false \\\r\n-emConfiguration NONE \\\r\n-enableArchive false \\\r\n-memoryMgmtType AUTO_SGA \\\r\n-totalMemory 4000 \\\r\n-nationalCharacterSet AL16UTF16 \\\r\n-olsConfiguration false \\\r\n-recoveryAreaDestination \/u01\/app\/oracle\/fra \\\r\n-sampleSchema false \\\r\n-sid orcl \\\r\n-storageType FS \\\r\n-useOMF false \\\r\n-sysPassword \"Rodrigo.123\" \\\r\n-systemPassword \"Rodrigo.123\"<\/pre>\n
Target DB (19.13.0):<\/strong><\/h4>\n
\n
\n
\n
dbca -silent -createDatabase \\\r\n-gdbName cdb19c \\\r\n-templateName My_Template.dbt \\\r\n-characterSet AL32UTF8 \\\r\n-createAsContainerDatabase true \\\r\n-numberOfPDBs 1 \\\r\n-pdbAdminPassword \"Rodrigo.123\" \\\r\n-pdbName PDB01 \\\r\n-useLocalUndoForPDBs true \\\r\n-databaseConfigType SINGLE \\\r\n-databaseType MULTIPURPOSE \\\r\n-datafileDestination \/u01\/app\/oracle\/oradata \\\r\n-dvConfiguration false \\\r\n-emConfiguration NONE \\\r\n-enableArchive false \\\r\n-memoryMgmtType AUTO_SGA \\\r\n-totalMemory 4000 \\\r\n-nationalCharacterSet AL16UTF16 \\\r\n-olsConfiguration false \\\r\n-recoveryAreaDestination \/u01\/app\/oracle\/fra \\\r\n-sampleSchema false \\\r\n-sid cdb19c \\\r\n-storageType FS \\\r\n-useOMF false \\\r\n-sysPassword \"Rodrigo.123\" \\\r\n-systemPassword \"Rodrigo.123\" \\\r\n-initParams compatible=12.2.0<\/pre>\n
Fallback DB (12.2):<\/strong><\/h4>\n
\n
\n
\n
dbca -silent -createDatabase \\\r\n-gdbName cdb12c \\\r\n-templateName General_Purpose.dbc \\\r\n-characterSet AL32UTF8 \\\r\n-createAsContainerDatabase true \\\r\n-numberOfPDBs 1 \\\r\n-pdbAdminPassword \"Rodrigo.123\" \\\r\n-pdbName PDB01 \\\r\n-useLocalUndoForPDBs true \\\r\n-databaseConfigType SINGLE \\\r\n-databaseType MULTIPURPOSE \\\r\n-datafileDestination \/u01\/app\/oracle\/oradata \\\r\n-dvConfiguration false \\\r\n-emConfiguration NONE \\\r\n-enableArchive false \\\r\n-memoryMgmtType AUTO_SGA \\\r\n-totalMemory 4000 \\\r\n-nationalCharacterSet AL16UTF16 \\\r\n-olsConfiguration false \\\r\n-recoveryAreaDestination \/u01\/app\/oracle\/fra \\\r\n-sampleSchema false \\\r\n-sid cdb12c \\\r\n-storageType FS \\\r\n-useOMF false \\\r\n-sysPassword \"Rodrigo.123\" \\\r\n-systemPassword \"Rodrigo.123\"<\/pre>\n
Preparing my source environment<\/span><\/h4>\n
[oracle@odbfcl-12-2-0-1 oradata]$ export ORACLE_SID=orcl\r\n[oracle@odbfcl-12-2-0-1 oradata]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 12.2.0.1.0 Production on Thu Oct 28 15:49:29 2021\r\n\r\nCopyright (c) 1982, 2016, Oracle. All rights reserved.\r\n\r\nConnected to:\r\nOracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production\r\n\r\nSQL> CREATE USER TEST IDENTIFIED BY \"oracle\";\r\n\r\nUser created.\r\n\r\nSQL> GRANT DBA TO TEST;\r\n\r\nGrant succeeded.\r\n\r\nSQL> select file_name from dba_data_files;\r\n\r\nFILE_NAME\r\n--------------------------------------------------------------------------------\r\n\/u01\/app\/oracle\/oradata\/orcl\/users01.dbf\r\n\/u01\/app\/oracle\/oradata\/orcl\/undotbs01.dbf\r\n\/u01\/app\/oracle\/oradata\/orcl\/system01.dbf\r\n\/u01\/app\/oracle\/oradata\/orcl\/sysaux01.dbf\r\n\r\nSQL> CREATE TABLESPACE TOOLS DATAFILE '\/u01\/app\/oracle\/oradata\/orcl\/tools01.dbf' size 10M;\r\n\r\nTablespace created.\r\n\r\nSQL> CREATE TABLE TEST.T1 TABLESPACE TOOLS AS SELECT * FROM DBA_TABLES;\r\n\r\nTable created.\r\n\r\nSQL> select count(*) from TEST.T1;\r\n\r\n COUNT(*)\r\n----------\r\n 2108\r\n\r\nSQL> exit\r\n\r\nDisconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production<\/pre>\n
Upgrading first<\/span><\/h4>\n
global.autoupg_log_dir=\/u01\/app\/oracle\/cfgtoollogs\/autoupgrade\r\nupg1.log_dir=\/u01\/app\/oracle\/cfgtoollogs\/autoupgrade\/12c\r\nupg1.sid=orcl\r\nupg1.source_home=\/u01\/app\/oracle\/product\/12.2.0.1\/dbhome_1\r\nupg1.target_cdb=cdb19c\r\nupg1.target_home=\/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\r\nupg1.target_version=19\r\nupg1.target_pdb_name=pdb12c\r\nupg1.upgrade_node=localhost\r\nupg1.run_utlrp=yes\r\nupg1.timezone_upg=no<\/pre>\n
[oracle@odbfcl-12-2-0-1 ~]$ $ORACLE_HOME\/jdk\/bin\/java -jar autoupgrade.jar -config .\/upgrade.cfg -mode analyze\r\nAutoUpgrade 21.2.210721 launched with default options\r\nProcessing config file ...\r\n+--------------------------------+\r\n| Starting AutoUpgrade execution |\r\n+--------------------------------+\r\n1 databases will be analyzed\r\nType 'help' to list console commands\r\nupg> Job 101 completed\r\n------------------- Final Summary --------------------\r\nNumber of databases [ 1 ]\r\n\r\nJobs finished [1]\r\nJobs failed [0]\r\nJobs pending [0]\r\n\r\nPlease check the summary report at:\r\n\/u01\/app\/oracle\/cfgtoollogs\/autoupgrade\/cfgtoollogs\/upgrade\/auto\/status\/status.html\r\n\/u01\/app\/oracle\/cfgtoollogs\/autoupgrade\/cfgtoollogs\/upgrade\/auto\/status\/status.log<\/pre>\n
[oracle@odbfcl-12-2-0-1 ~]$ $ORACLE_HOME\/jdk\/bin\/java -jar autoupgrade.jar -config .\/upgrade.cfg -mode fixups\r\nAutoUpgrade 21.2.210721 launched with default options\r\nProcessing config file ...\r\n+--------------------------------+\r\n| Starting AutoUpgrade execution |\r\n+--------------------------------+\r\n1 databases will be processed\r\nType 'help' to list console commands\r\nupg> Job 102 completed\r\n------------------- Final Summary --------------------\r\nNumber of databases [ 1 ]\r\n\r\nJobs finished [1]\r\nJobs failed [0]\r\nJobs pending [0]\r\n\r\nPlease check the summary report at:\r\n\/u01\/app\/oracle\/cfgtoollogs\/autoupgrade\/cfgtoollogs\/upgrade\/auto\/status\/status.html\r\n\/u01\/app\/oracle\/cfgtoollogs\/autoupgrade\/cfgtoollogs\/upgrade\/auto\/status\/status.log<\/pre>\n
[oracle@odbfcl-12-2-0-1 ~]$ export ORACLE_SID=orcl\r\n[oracle@odbfcl-12-2-0-1 ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 12.2.0.1.0 Production on Thu Oct 28 16:21:49 2021\r\n\r\nCopyright (c) 1982, 2016, Oracle. All rights reserved.\r\n\r\nConnected to:\r\nOracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production\r\n\r\nSQL> shut immediate;\r\nDatabase closed.\r\nDatabase dismounted.\r\nORACLE instance shut down.\r\n\r\nSQL> exit\r\nDisconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production<\/pre>\n
[oracle@odbfcl-19-0-0-0 ~]$ export ORACLE_SID=orcl\r\n[oracle@odbfcl-19-0-0-0 ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 28 17:02:46 2021\r\nVersion 19.13.0.0.0\r\n\r\nCopyright (c) 1982, 2021, Oracle. All rights reserved.\r\n\r\nConnected to an idle instance.\r\n\r\nSQL> startup upgrade;\r\n\r\nORACLE instance started.\r\n\r\nTotal System Global Area 3154113392 bytes\r\nFixed Size\t\t 8901488 bytes\r\nVariable Size\t\t 687865856 bytes\r\nDatabase Buffers\t 2449473536 bytes\r\nRedo Buffers\t\t 7872512 bytes\r\nDatabase mounted.\r\nDatabase opened.\r\nSQL> exit\r\nDisconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\r\nVersion 19.13.0.0.0<\/pre>\n
[oracle@odbfcl-19-0-0-0 ~]$ $ORACLE_HOME\/jdk\/bin\/java -jar autoupgrade.jar -config .\/upgrade.cfg -mode upgrade\r\nAutoUpgrade 21.2.210721 launched with default options\r\nProcessing config file ...\r\n+--------------------------------+\r\n| Starting AutoUpgrade execution |\r\n+--------------------------------+\r\n1 databases will be processed\r\nType 'help' to list console commands\r\nupg> lsj\r\n+----+-------+---------+---------+-------+--------------+--------+------------+\r\n|Job#|DB_NAME| STAGE|OPERATION| STATUS| START_TIME| UPDATED| MESSAGE|\r\n+----+-------+---------+---------+-------+--------------+--------+------------+\r\n| 103| orcl|DBUPGRADE|EXECUTING|RUNNING|21\/10\/28 17:04|17:07:13|10%Upgraded |\r\n+----+-------+---------+---------+-------+--------------+--------+------------+\r\nTotal jobs 1\r\n\r\nupg> Job 103 completed\r\n------------------- Final Summary --------------------\r\nNumber of databases [ 1 ]\r\n\r\nJobs finished [1]\r\nJobs failed [0]\r\nJobs pending [0]\r\n\r\nPlease check the summary report at:\r\n\/u01\/app\/oracle\/cfgtoollogs\/autoupgrade\/cfgtoollogs\/upgrade\/auto\/status\/status.html\r\n\/u01\/app\/oracle\/cfgtoollogs\/autoupgrade\/cfgtoollogs\/upgrade\/auto\/status\/status.log\r\n[oracle@odbfcl-19-0-0-0 ~]$<\/pre>\n
[oracle@odbfcl-19-0-0-0 ~]$ export ORACLE_SID=cdb19c\r\n[oracle@odbfcl-19-0-0-0 ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 28 18:02:44 2021\r\nVersion 19.13.0.0.0\r\n\r\nCopyright (c) 1982, 2021, Oracle. All rights reserved.\r\n\r\nConnected to:\r\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\r\nVersion 19.13.0.0.0\r\n\r\nSQL> show pdbs\r\n\r\n CON_ID CON_NAME OPEN MODE RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n 2 PDB$SEED READ ONLY NO\r\n 3 PDB01 READ WRITE NO\r\n 4 PDB12C READ WRITE NO\r\n\r\nSQL> alter session set container=PDB12C;\r\n\r\nSession altered.\r\n\r\nSQL> select count(*) from TEST.T1;\r\n\r\n COUNT(*)\r\n----------\r\n 2108\r\n\r\nSQL> select cname, prv_version, version from registry$;\r\n\r\nCNAME PRV_VERSION VERSION\r\n----------------------------------- ------------------------------ ------------------------------\r\nOracle Database Catalog Views 12.2.0.1.0 19.0.0.0.0\r\nOracle Database Packages and Types 12.2.0.1.0 19.0.0.0.0\r\nOracle XML Database 12.2.0.1.0 19.0.0.0.0\r\nOracle Workspace Manager 12.2.0.1.0 19.0.0.0.0\r\nJServer JAVA Virtual Machine 12.2.0.1.0 19.0.0.0.0\r\nOracle XDK 12.2.0.1.0 19.0.0.0.0\r\nOracle Database Java Packages 12.2.0.1.0 19.0.0.0.0\r\nOracle Text 12.2.0.1.0 19.0.0.0.0\r\nOracle Multimedia 12.2.0.1.0 19.0.0.0.0\r\nOLAP Analytic Workspace 12.2.0.1.0 19.0.0.0.0\r\nOracle OLAP API 12.2.0.1.0 19.0.0.0.0\r\nSpatial 12.2.0.1.0 19.0.0.0.0\r\nOracle Label Security 12.2.0.1.0 19.0.0.0.0\r\nOracle Database Vault 12.2.0.1.0 19.0.0.0.0\r\nOracle Real Application Clusters 12.2.0.1.0 19.0.0.0.0\r\n\r\n15 rows selected.\r\n\r\nSQL> show parameter compatible\r\n\r\nNAME TYPE VALUE\r\n------------------------------------ ----------- ------------------------------\r\ncompatible string 12.2.0\r\nnoncdb_compatible boolean FALSE<\/pre>\n
Downgrade<\/span><\/h4>\n
SQL> alter session set container=PDB12C;\r\n\r\nSession altered.\r\n\r\nSQL> create table test.t2 as select * from dba_tables;\r\n\r\nTable created.\r\n\r\nSQL> select count(*) from test.t2;\r\n\r\n COUNT(*)\r\n----------\r\n 2191\r\n\r\nSQL><\/pre>\n
\n
\n
\n<\/strong><\/li>\n<\/ul>\n<\/li>\n[oracle@odbfcl-19-0-0-0 ~]$ export ORACLE_SID=cdb19c\r\n[oracle@odbfcl-19-0-0-0 ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 28 18:36:47 2021\r\nVersion 19.13.0.0.0\r\n\r\nCopyright (c) 1982, 2021, Oracle. All rights reserved.\r\n\r\nConnected to:\r\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\r\nVersion 19.13.0.0.0\r\n\r\nSQL> alter session set container=PDB12C;\r\n\r\nSession altered.\r\n\r\nSQL> select count(*) from UNIFIED_AUDIT_TRAIL;\r\n\r\n COUNT(*)\r\n----------\r\n 26848\r\n\r\nSQL> EXEC DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(audit_trail_type => DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED, use_last_arch_timestamp => FALSE);\r\n\r\nPL\/SQL procedure successfully completed.\r\n\r\nSQL><\/pre>\n
SQL> show pdbs\r\n\r\n CON_ID CON_NAME OPEN MODE RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n 2 PDB$SEED READ ONLY NO\r\n 3 PDB01 READ WRITE NO\r\n 4 PDB12C READ WRITE YES\r\n\r\nSQL> alter pluggable database PDB12C close;\r\n\r\nPluggable database altered.\r\n\r\nSQL> alter pluggable database PDB12C open downgrade;\r\n\r\nPluggable database altered.\r\n\r\nSQL> show pdbs\r\n\r\n CON_ID CON_NAME OPEN MODE RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n 2 PDB$SEED READ ONLY NO\r\n 3 PDB01 READ WRITE NO\r\n 4 PDB12C MIGRATE YES<\/pre>\n
[oracle@odbfcl-19-0-0-0 ~]$ sh $ORACLE_HOME\/bin\/dbdowngrade -c 'PDB12C'\r\nDowngrading containers\r\ncatcon::set_log_file_base_path: ALL catcon-related output will be written to [\/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\/cfgtoollogs\/downgrade\/catdwgrd_catcon_27280.lst]\r\n\r\ncatcon::set_log_file_base_path: catcon: See [\/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\/cfgtoollogs\/downgrade\/catdwgrd*.log] files for output generated by scripts\r\n\r\ncatcon::set_log_file_base_path: catcon: See [\/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\/cfgtoollogs\/downgrade\/catdwgrd_*.lst] files for spool files, if any\r\n\r\ncatcon.pl: completed successfully\r\n[oracle@odbfcl-19-0-0-0 ~]$ grep '^ORA-' \/u01\/app\/oracle\/product\/19.0.0.0\/dbhome_1\/cfgtoollogs\/downgrade\/catdwgrd*.log\r\n[oracle@odbfcl-19-0-0-0 ~]$<\/pre>\n
[oracle@odbfcl-19-0-0-0 ~]$ export ORACLE_SID=cdb19c\r\n[oracle@odbfcl-19-0-0-0 ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 19.0.0.0.0 - Production on Thu Oct 28 19:17:28 2021\r\nVersion 19.13.0.0.0\r\n\r\nCopyright (c) 1982, 2021, Oracle. All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production\r\nVersion 19.13.0.0.0\r\n\r\nSQL> show pdbs\r\n\r\n CON_ID CON_NAME OPEN MODE RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n 2 PDB$SEED READ ONLY NO\r\n 3 PDB01 READ WRITE NO\r\n 4 PDB12C MIGRATE YES\r\n\r\nSQL> alter pluggable database PDB12C close immediate;\r\n\r\nPluggable database altered.\r\n\r\nSQL> alter pluggable database PDB12C unplug into '\/home\/oracle\/PDB12C.unplug.xml';\r\n\r\nPluggable database altered.\r\n\r\nSQL> show pdbs\r\n\r\n CON_ID CON_NAME OPEN MODE RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n 2 PDB$SEED READ ONLY NO\r\n 3 PDB01 READ WRITE NO\r\n 4 PDB12C MOUNTED\r\n\r\nSQL> drop pluggable database PDB12C;\r\n\r\nPluggable database dropped.\r\n\r\nSQL><\/pre>\n
[oracle@odbfcl-12-2-0-1 ~]$ export ORACLE_SID=cdb12c\r\n[oracle@odbfcl-12-2-0-1 ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 12.2.0.1.0 Production on Thu Oct 28 19:28:50 2021\r\n\r\nCopyright (c) 1982, 2016, Oracle. All rights reserved.\r\n\r\nConnected to:\r\nOracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production\r\n\r\nSQL> show pdbs\r\n\r\n CON_ID CON_NAME OPEN MODE RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n 2 PDB$SEED READ ONLY NO\r\n 3 PDB01 READ WRITE NO\r\n\r\nSQL> create pluggable database PDB12C using '\/home\/oracle\/PDB12C.unplug.xml' nocopy;\r\n\r\nPluggable database created.\r\n\r\nSQL> alter pluggable database PDB12C open upgrade;\r\n\r\nPluggable database altered.\r\n\r\nSQL> show pdbs\r\n\r\n CON_ID CON_NAME OPEN MODE RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n 2 PDB$SEED READ ONLY NO\r\n 3 PDB01 READ WRITE NO\r\n 4 PDB12C MIGRATE YES<\/pre>\n
SQL> alter session set container=PDB12C;\r\n\r\nSession altered.\r\n\r\nSQL> set termout off\r\nSQL> spool \/home\/oracle\/catrelod.log\r\nSQL> @?\/rdbms\/admin\/catrelod.sql\r\n\r\nSQL> spool off\r\nSQL> exit\r\nDisconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production\r\n[oracle@odbfcl-12-2-0-1 ~]$ grep '^ORA-' \/home\/oracle\/catrelod.log\r\n[oracle@odbfcl-12-2-0-1 ~]$<\/pre>\n
SQL> show pdbs\r\n\r\n CON_ID CON_NAME OPEN MODE RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n 4 PDB12C MIGRATE YES\r\n\r\nSQL> shut immediate;\r\nPluggable Database closed.\r\n\r\nSQL> startup;\r\nPluggable Database opened.\r\n\r\nSQL> show pdbs\r\n\r\n CON_ID CON_NAME OPEN MODE RESTRICTED\r\n---------- ------------------------------ ---------- ----------\r\n 4 PDB12C READ WRITE NO\r\n\r\nSQL> select count(*) from TEST.T1;\r\n\r\n COUNT(*)\r\n----------\r\n 2108\r\n\r\nSQL> select count(*) from TEST.T2;\r\n\r\n COUNT(*)\r\n----------\r\n 2191\r\n\r\nSQL><\/pre>\n
Full Transportable Tablespace<\/span><\/h4>\n
[oracle@odbfcl-12-2-0-1 ~]$ export ORACLE_SID=cdb12c\r\n[oracle@odbfcl-12-2-0-1 ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 12.2.0.1.0 Production on Thu Oct 28 20:17:22 2021\r\n\r\nCopyright (c) 1982, 2016, Oracle. All rights reserved.\r\n\r\n\r\nConnected to:\r\nOracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production\r\n\r\nSQL> alter session set container=PDB12C;\r\n\r\nSession altered.\r\n\r\nSQL> select tablespace_name from dba_tablespaces;\r\n\r\nTABLESPACE_NAME\r\n------------------------------\r\nSYSTEM\r\nSYSAUX\r\nUNDOTBS1\r\nTEMP\r\nUSERS\r\nTOOLS\r\n\r\n6 rows selected.\r\n\r\nSQL> alter tablespace TOOLS read only;\r\n\r\nTablespace altered.\r\n\r\nSQL> alter tablespace USERS read only;\r\n\r\nTablespace altered.\r\n\r\nSQL><\/pre>\n
SQL> alter session set container=PDB12C;\r\n\r\nSession altered.\r\n\r\nSQL> alter user test default tablespace system;\r\n\r\nUser altered.<\/pre>\n
[oracle@odbfcl-12-2-0-1 ~]$ expdp test\/oracle@localhost:1521\/pdb12c full=y transportable=always\r\n\r\nExport: Release 12.2.0.1.0 - Production on Fri Oct 29 11:21:31 2021\r\n\r\nCopyright (c) 1982, 2017, Oracle and\/or its affiliates. All rights reserved.\r\n\r\nConnected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production\r\nStarting \"TEST\".\"SYS_EXPORT_FULL_01\": test\/********@localhost:1521\/pdb12c full=y transportable=always\r\nProcessing object type DATABASE_EXPORT\/EARLY_OPTIONS\/VIEWS_AS_TABLES\/TABLE_DATA\r\nProcessing object type DATABASE_EXPORT\/NORMAL_OPTIONS\/TABLE_DATA\r\nProcessing object type DATABASE_EXPORT\/NORMAL_OPTIONS\/VIEWS_AS_TABLES\/TABLE_DATA\r\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/TABLE_DATA\r\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/INDEX\/STATISTICS\/INDEX_STATISTICS\r\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/STATISTICS\/TABLE_STATISTICS\r\nProcessing object type DATABASE_EXPORT\/STATISTICS\/MARKER\r\nProcessing object type DATABASE_EXPORT\/PLUGTS_FULL\/FULL\/PLUGTS_TABLESPACE\r\nProcessing object type DATABASE_EXPORT\/PLUGTS_FULL\/PLUGTS_BLK\r\nProcessing object type DATABASE_EXPORT\/END_PLUGTS_BLK\r\nProcessing object type DATABASE_EXPORT\/PRE_SYSTEM_IMPCALLOUT\/MARKER\r\nProcessing object type DATABASE_EXPORT\/PRE_INSTANCE_IMPCALLOUT\/MARKER\r\nProcessing object type DATABASE_EXPORT\/TABLESPACE\r\nProcessing object type DATABASE_EXPORT\/PROFILE\r\nProcessing object type DATABASE_EXPORT\/SYS_USER\/USER\r\nProcessing object type DATABASE_EXPORT\/SCHEMA\/USER\r\nProcessing object type DATABASE_EXPORT\/RADM_FPTM\r\nProcessing object type DATABASE_EXPORT\/GRANT\/SYSTEM_GRANT\/PROC_SYSTEM_GRANT\r\nProcessing object type DATABASE_EXPORT\/SCHEMA\/GRANT\/SYSTEM_GRANT\r\nProcessing object type DATABASE_EXPORT\/SCHEMA\/ROLE_GRANT\r\nProcessing object type DATABASE_EXPORT\/SCHEMA\/DEFAULT_ROLE\r\nProcessing object type DATABASE_EXPORT\/SCHEMA\/ON_USER_GRANT\r\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLESPACE_QUOTA\r\nProcessing object type DATABASE_EXPORT\/RESOURCE_COST\r\nProcessing object type DATABASE_EXPORT\/TRUSTED_DB_LINK\r\nProcessing object type DATABASE_EXPORT\/SYSTEM_PROCOBJACT\/PRE_SYSTEM_ACTIONS\/PROCACT_SYSTEM\r\nProcessing object type DATABASE_EXPORT\/SYSTEM_PROCOBJACT\/PROCOBJ\r\nProcessing object type DATABASE_EXPORT\/SYSTEM_PROCOBJACT\/POST_SYSTEM_ACTIONS\/PROCACT_SYSTEM\r\nProcessing object type DATABASE_EXPORT\/SCHEMA\/PROCACT_SCHEMA\r\nProcessing object type DATABASE_EXPORT\/EARLY_OPTIONS\/VIEWS_AS_TABLES\/TABLE\r\nProcessing object type DATABASE_EXPORT\/EARLY_POST_INSTANCE_IMPCALLOUT\/MARKER\r\nProcessing object type DATABASE_EXPORT\/NORMAL_OPTIONS\/TABLE\r\nProcessing object type DATABASE_EXPORT\/NORMAL_OPTIONS\/VIEWS_AS_TABLES\/TABLE\r\nProcessing object type DATABASE_EXPORT\/NORMAL_POST_INSTANCE_IMPCALLOUT\/MARKER\r\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/TABLE\r\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/COMMENT\r\nProcessing object type DATABASE_EXPORT\/XS_SECURITY\/SCHEMA\/XS_ACL\r\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/INDEX\/INDEX\r\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/CONSTRAINT\/CONSTRAINT\r\nProcessing object type DATABASE_EXPORT\/FINAL_POST_INSTANCE_IMPCALLOUT\/MARKER\r\nProcessing object type DATABASE_EXPORT\/SCHEMA\/POST_SCHEMA\/PROCACT_SCHEMA\r\nProcessing object type DATABASE_EXPORT\/AUDIT_UNIFIED\/AUDIT_POLICY_ENABLE\r\nProcessing object type DATABASE_EXPORT\/POST_SYSTEM_IMPCALLOUT\/MARKER\r\n. . exported \"SYS\".\"KU$_USER_MAPPING_VIEW\" 6.078 KB 37 rows\r\n. . exported \"SYSTEM\".\"REDO_DB\" 25.59 KB 1 rows\r\n. . exported \"ORDDATA\".\"ORDDCM_DOCS\" 252.9 KB 9 rows\r\n. . exported \"WMSYS\".\"WM$WORKSPACES_TABLE$\" 12.10 KB 1 rows\r\n. . exported \"WMSYS\".\"WM$HINT_TABLE$\" 9.984 KB 97 rows\r\n. . exported \"LBACSYS\".\"OLS$INSTALLATIONS\" 6.960 KB 2 rows\r\n. . exported \"WMSYS\".\"WM$WORKSPACE_PRIV_TABLE$\" 7.078 KB 11 rows\r\n. . exported \"SYS\".\"DAM_CONFIG_PARAM$\" 6.531 KB 14 rows\r\n. . exported \"SYS\".\"TSDP_SUBPOL$\" 6.328 KB 1 rows\r\n. . exported \"WMSYS\".\"WM$NEXTVER_TABLE$\" 6.375 KB 1 rows\r\n. . exported \"LBACSYS\".\"OLS$PROPS\" 6.234 KB 5 rows\r\n. . exported \"WMSYS\".\"WM$ENV_VARS$\" 5.976 KB 2 rows\r\n. . exported \"SYS\".\"TSDP_PARAMETER$\" 5.953 KB 1 rows\r\n. . exported \"SYS\".\"TSDP_POLICY$\" 5.921 KB 1 rows\r\n. . exported \"WMSYS\".\"WM$VERSION_HIERARCHY_TABLE$\" 5.984 KB 1 rows\r\n. . exported \"WMSYS\".\"WM$EVENTS_INFO$\" 5.812 KB 12 rows\r\n. . exported \"LBACSYS\".\"OLS$AUDIT_ACTIONS\" 5.757 KB 8 rows\r\n. . exported \"LBACSYS\".\"OLS$DIP_EVENTS\" 5.539 KB 2 rows\r\n. . exported \"LBACSYS\".\"OLS$AUDIT\" 0 KB 0 rows\r\n. . exported \"LBACSYS\".\"OLS$COMPARTMENTS\" 0 KB 0 rows\r\n. . exported \"LBACSYS\".\"OLS$DIP_DEBUG\" 0 KB 0 rows\r\n. . exported \"LBACSYS\".\"OLS$GROUPS\" 0 KB 0 rows\r\n. . exported \"LBACSYS\".\"OLS$LAB\" 0 KB 0 rows\r\n. . exported \"LBACSYS\".\"OLS$LEVELS\" 0 KB 0 rows\r\n. . exported \"LBACSYS\".\"OLS$POL\" 0 KB 0 rows\r\n. . exported \"LBACSYS\".\"OLS$POLICY_ADMIN\" 0 KB 0 rows\r\n. . exported \"LBACSYS\".\"OLS$POLS\" 0 KB 0 rows\r\n. . exported \"LBACSYS\".\"OLS$POLT\" 0 KB 0 rows\r\n. . exported \"LBACSYS\".\"OLS$PROFILE\" 0 KB 0 rows\r\n. . exported \"LBACSYS\".\"OLS$PROFILES\" 0 KB 0 rows\r\n. . exported \"LBACSYS\".\"OLS$PROG\" 0 KB 0 rows\r\n. . exported \"LBACSYS\".\"OLS$SESSINFO\" 0 KB 0 rows\r\n. . exported \"LBACSYS\".\"OLS$USER\" 0 KB 0 rows\r\n. . exported \"LBACSYS\".\"OLS$USER_COMPARTMENTS\" 0 KB 0 rows\r\n. . exported \"LBACSYS\".\"OLS$USER_GROUPS\" 0 KB 0 rows\r\n. . exported \"LBACSYS\".\"OLS$USER_LEVELS\" 0 KB 0 rows\r\n. . exported \"SYS\".\"AUD$\" 23.75 KB 2 rows\r\n. . exported \"SYS\".\"DAM_CLEANUP_EVENTS$\" 0 KB 0 rows\r\n. . exported \"SYS\".\"DAM_CLEANUP_JOBS$\" 0 KB 0 rows\r\n. . exported \"SYS\".\"TSDP_ASSOCIATION$\" 0 KB 0 rows\r\n. . exported \"SYS\".\"TSDP_CONDITION$\" 0 KB 0 rows\r\n. . exported \"SYS\".\"TSDP_FEATURE_POLICY$\" 0 KB 0 rows\r\n. . exported \"SYS\".\"TSDP_PROTECTION$\" 0 KB 0 rows\r\n. . exported \"SYS\".\"TSDP_SENSITIVE_DATA$\" 0 KB 0 rows\r\n. . exported \"SYS\".\"TSDP_SENSITIVE_TYPE$\" 0 KB 0 rows\r\n. . exported \"SYS\".\"TSDP_SOURCE$\" 0 KB 0 rows\r\n. . exported \"SYSTEM\".\"REDO_LOG\" 0 KB 0 rows\r\n. . exported \"WMSYS\".\"WM$BATCH_COMPRESSIBLE_TABLES$\" 0 KB 0 rows\r\n. . exported \"WMSYS\".\"WM$CONSTRAINTS_TABLE$\" 0 KB 0 rows\r\n. . exported \"WMSYS\".\"WM$CONS_COLUMNS$\" 0 KB 0 rows\r\n. . exported \"WMSYS\".\"WM$LOCKROWS_INFO$\" 0 KB 0 rows\r\n. . exported \"WMSYS\".\"WM$MODIFIED_TABLES$\" 0 KB 0 rows\r\n. . exported \"WMSYS\".\"WM$MP_GRAPH_WORKSPACES_TABLE$\" 0 KB 0 rows\r\n. . exported \"WMSYS\".\"WM$MP_PARENT_WORKSPACES_TABLE$\" 0 KB 0 rows\r\n. . exported \"WMSYS\".\"WM$NESTED_COLUMNS_TABLE$\" 0 KB 0 rows\r\n. . exported \"WMSYS\".\"WM$RESOLVE_WORKSPACES_TABLE$\" 0 KB 0 rows\r\n. . exported \"WMSYS\".\"WM$RIC_LOCKING_TABLE$\" 0 KB 0 rows\r\n. . exported \"WMSYS\".\"WM$RIC_TABLE$\" 0 KB 0 rows\r\n. . exported \"WMSYS\".\"WM$RIC_TRIGGERS_TABLE$\" 0 KB 0 rows\r\n. . exported \"WMSYS\".\"WM$UDTRIG_DISPATCH_PROCS$\" 0 KB 0 rows\r\n. . exported \"WMSYS\".\"WM$UDTRIG_INFO$\" 0 KB 0 rows\r\n. . exported \"WMSYS\".\"WM$VERSION_TABLE$\" 0 KB 0 rows\r\n. . exported \"WMSYS\".\"WM$VT_ERRORS_TABLE$\" 0 KB 0 rows\r\n. . exported \"WMSYS\".\"WM$WORKSPACE_SAVEPOINTS_TABLE$\" 0 KB 0 rows\r\n. . exported \"MDSYS\".\"RDF_PARAM$\" 6.515 KB 3 rows\r\n. . exported \"SYS\".\"AUDTAB$TBS$FOR_EXPORT\" 5.960 KB 2 rows\r\n. . exported \"SYS\".\"DBA_SENSITIVE_DATA\" 0 KB 0 rows\r\n. . exported \"SYS\".\"DBA_TSDP_POLICY_PROTECTION\" 0 KB 0 rows\r\n. . exported \"SYS\".\"FGA_LOG$FOR_EXPORT\" 0 KB 0 rows\r\n. . exported \"SYS\".\"NACL$_ACE_EXP\" 0 KB 0 rows\r\n. . exported \"SYS\".\"NACL$_HOST_EXP\" 6.976 KB 2 rows\r\n. . exported \"SYS\".\"NACL$_WALLET_EXP\" 0 KB 0 rows\r\n. . exported \"SYS\".\"SQL$TEXT_DATAPUMP\" 0 KB 0 rows\r\n. . exported \"SYS\".\"SQL$_DATAPUMP\" 0 KB 0 rows\r\n. . exported \"SYS\".\"SQLOBJ$AUXDATA_DATAPUMP\" 0 KB 0 rows\r\n. . exported \"SYS\".\"SQLOBJ$DATA_DATAPUMP\" 0 KB 0 rows\r\n. . exported \"SYS\".\"SQLOBJ$PLAN_DATAPUMP\" 0 KB 0 rows\r\n. . exported \"SYS\".\"SQLOBJ$_DATAPUMP\" 0 KB 0 rows\r\n. . exported \"SYSTEM\".\"SCHEDULER_JOB_ARGS\" 0 KB 0 rows\r\n. . exported \"SYSTEM\".\"SCHEDULER_PROGRAM_ARGS\" 9.515 KB 12 rows\r\n. . exported \"WMSYS\".\"WM$EXP_MAP\" 7.718 KB 3 rows\r\n. . exported \"WMSYS\".\"WM$METADATA_MAP\" 0 KB 0 rows\r\nMaster table \"TEST\".\"SYS_EXPORT_FULL_01\" successfully loaded\/unloaded\r\n******************************************************************************\r\nDump file set for TEST.SYS_EXPORT_FULL_01 is:\r\n \/u01\/app\/oracle\/admin\/cdb12c\/dpdump\/CF6972DD148B3675E0531201000A270A\/expdat.dmp\r\n******************************************************************************\r\nDatafiles required for transportable tablespace TOOLS:\r\n \/u01\/app\/oracle\/oradata\/CDB12C\/orcl\/tools01.dbf\r\nDatafiles required for transportable tablespace USERS:\r\n \/u01\/app\/oracle\/oradata\/CDB12C\/orcl\/users01.dbf\r\nJob \"TEST\".\"SYS_EXPORT_FULL_01\" successfully completed at Fri Oct 29 11:23:19 2021 elapsed 0 00:01:46\r\n\r\n[oracle@odbfcl-12-2-0-1 ~]$<\/pre>\n
[oracle@odbfcl-12-2-0-1 ~]$ export ORACLE_SID=orcl\r\n[oracle@odbfcl-12-2-0-1 ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 12.2.0.1.0 Production on Fri Oct 29 11:42:53 2021\r\n\r\nCopyright (c) 1982, 2016, Oracle. All rights reserved.\r\n\r\nConnected to:\r\nOracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production\r\n\r\nSQL> alter tablespace USERS rename to USERS_OLD;\r\n\r\nTablespace altered.\r\n\r\nSQL> alter database move datafile '\/u01\/app\/oracle\/oradata\/orcl\/users01.dbf' to '\/u01\/app\/oracle\/oradata\/orcl\/users01_old.dbf';\r\n\r\nDatabase altered.<\/pre>\n
[oracle@odbfcl-12-2-0-1 ~]$ export ORACLE_SID=orcl\r\n[oracle@odbfcl-12-2-0-1 ~]$ cp -av \/u01\/app\/oracle\/admin\/cdb12c\/dpdump\/CF6972DD148B3675E0531201000A270A\/expdat.dmp \/u01\/app\/oracle\/admin\/orcl\/dpdump\/expdat.dmp\r\n'\/u01\/app\/oracle\/admin\/cdb12c\/dpdump\/CF6972DD148B3675E0531201000A270A\/expdat.dmp' -> '\/u01\/app\/oracle\/admin\/orcl\/dpdump\/expdat.dmp'\r\n[oracle@odbfcl-12-2-0-1 ~]$ impdp \\\"\/ as sysdba\\\" transport_datafiles=\/u01\/app\/oracle\/oradata\/orcl\/tools01.dbf,\/u01\/app\/oracle\/oradata\/orcl\/users01.dbf\r\n\r\nImport: Release 12.2.0.1.0 - Production on Fri Oct 29 16:26:22 2021\r\n\r\nCopyright (c) 1982, 2017, Oracle and\/or its affiliates. All rights reserved.\r\n\r\nConnected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production\r\nMaster table \"SYS\".\"SYS_IMPORT_TRANSPORTABLE_01\" successfully loaded\/unloaded\r\nStarting \"SYS\".\"SYS_IMPORT_TRANSPORTABLE_01\": \"\/******** AS SYSDBA\" transport_datafiles=\/u01\/app\/oracle\/oradata\/orcl\/tools01.dbf,\/u01\/app\/oracle\/oradata\/orcl\/users01.dbf\r\nProcessing object type DATABASE_EXPORT\/PRE_SYSTEM_IMPCALLOUT\/MARKER\r\nProcessing object type DATABASE_EXPORT\/PRE_INSTANCE_IMPCALLOUT\/MARKER\r\nProcessing object type DATABASE_EXPORT\/PLUGTS_FULL\/PLUGTS_BLK\r\nProcessing object type DATABASE_EXPORT\/TABLESPACE\r\nORA-31684: Object type TABLESPACE:\"UNDOTBS1\" already exists\r\n\r\nORA-31684: Object type TABLESPACE:\"TEMP\" already exists\r\n\r\nProcessing object type DATABASE_EXPORT\/PROFILE\r\nProcessing object type DATABASE_EXPORT\/SYS_USER\/USER\r\nORA-31685: Object type USER:\"SYS\" failed due to insufficient privileges. Failing sql is:\r\n ALTER USER \"SYS\" IDENTIFIED BY VALUES 'S: ;T: ' TEMPORARY TABLESPACE \"TEMP\"\r\n\r\nProcessing object type DATABASE_EXPORT\/SCHEMA\/USER\r\nProcessing object type DATABASE_EXPORT\/RADM_FPTM\r\nProcessing object type DATABASE_EXPORT\/GRANT\/SYSTEM_GRANT\/PROC_SYSTEM_GRANT\r\nProcessing object type DATABASE_EXPORT\/SCHEMA\/GRANT\/SYSTEM_GRANT\r\nProcessing object type DATABASE_EXPORT\/SCHEMA\/ROLE_GRANT\r\nProcessing object type DATABASE_EXPORT\/SCHEMA\/DEFAULT_ROLE\r\nProcessing object type DATABASE_EXPORT\/SCHEMA\/ON_USER_GRANT\r\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLESPACE_QUOTA\r\nProcessing object type DATABASE_EXPORT\/RESOURCE_COST\r\nProcessing object type DATABASE_EXPORT\/TRUSTED_DB_LINK\r\nProcessing object type DATABASE_EXPORT\/SYSTEM_PROCOBJACT\/PRE_SYSTEM_ACTIONS\/PROCACT_SYSTEM\r\n>>> Cannot set an SCN larger than the current SCN. If a Streams Capture configuration was imported then the Apply that processes the captured messages needs to be dropped and recreated. See My Oracle Support article number 1380295.1.\r\nProcessing object type DATABASE_EXPORT\/SYSTEM_PROCOBJACT\/PROCOBJ\r\nORA-39083: Object type PROCOBJ:\"SYS\".\"XMLDB_NFS_JOBCLASS\" failed to create with error:\r\nORA-27477: \"SYS\".\"XMLDB_NFS_JOBCLASS\" already exists\r\n\r\nFailing sql is:\r\nBEGIN\r\ndbms_scheduler.create_job_class('\"XMLDB_NFS_JOBCLASS\"',NULL,NULL,128,NULL,\r\nNULL\r\n);COMMIT; END;\r\n\r\nProcessing object type DATABASE_EXPORT\/SYSTEM_PROCOBJACT\/POST_SYSTEM_ACTIONS\/PROCACT_SYSTEM\r\nProcessing object type DATABASE_EXPORT\/SCHEMA\/PROCACT_SCHEMA\r\nProcessing object type DATABASE_EXPORT\/EARLY_OPTIONS\/VIEWS_AS_TABLES\/TABLE\r\nProcessing object type DATABASE_EXPORT\/EARLY_OPTIONS\/VIEWS_AS_TABLES\/TABLE_DATA\r\n. . imported \"SYS\".\"KU$_EXPORT_USER_MAP\" 6.054 KB 36 rows\r\nProcessing object type DATABASE_EXPORT\/EARLY_POST_INSTANCE_IMPCALLOUT\/MARKER\r\nProcessing object type DATABASE_EXPORT\/NORMAL_OPTIONS\/TABLE\r\nProcessing object type DATABASE_EXPORT\/NORMAL_OPTIONS\/TABLE_DATA\r\n. . imported \"SYSTEM\".\"REDO_DB_TMP\" 25.59 KB 1 rows\r\n. . imported \"ORDDATA\".\"ORDDCM_DOCS_TRANSIENT\" 252.9 KB 9 rows\r\n. . imported \"WMSYS\".\"E$WORKSPACES_TABLE$\" 12.10 KB 1 rows\r\n. . imported \"WMSYS\".\"E$HINT_TABLE$\" 9.984 KB 97 rows\r\n. . imported \"WMSYS\".\"E$WORKSPACE_PRIV_TABLE$\" 7.078 KB 11 rows\r\n. . imported \"SYS\".\"AMGT$DP$DAM_CONFIG_PARAM$\" 6.531 KB 14 rows\r\n. . imported \"SYS\".\"DP$TSDP_SUBPOL$\" 6.328 KB 1 rows\r\n. . imported \"WMSYS\".\"E$NEXTVER_TABLE$\" 6.375 KB 1 rows\r\n. . imported \"WMSYS\".\"E$ENV_VARS$\" 5.976 KB 2 rows\r\n. . imported \"SYS\".\"DP$TSDP_PARAMETER$\" 5.953 KB 1 rows\r\n. . imported \"SYS\".\"DP$TSDP_POLICY$\" 5.921 KB 1 rows\r\n. . imported \"WMSYS\".\"E$VERSION_HIERARCHY_TABLE$\" 5.984 KB 1 rows\r\n. . imported \"WMSYS\".\"E$EVENTS_INFO$\" 5.812 KB 12 rows\r\n. . imported \"LBACSYS\".\"OLS_DP$OLS$AUDIT\" 0 KB 0 rows\r\n. . imported \"LBACSYS\".\"OLS_DP$OLS$COMPARTMENTS\" 0 KB 0 rows\r\n. . imported \"LBACSYS\".\"OLS_DP$OLS$GROUPS\" 0 KB 0 rows\r\n. . imported \"LBACSYS\".\"OLS_DP$OLS$LAB\" 0 KB 0 rows\r\n. . imported \"LBACSYS\".\"OLS_DP$OLS$LEVELS\" 0 KB 0 rows\r\n. . imported \"LBACSYS\".\"OLS_DP$OLS$POL\" 0 KB 0 rows\r\n. . imported \"LBACSYS\".\"OLS_DP$OLS$POLS\" 0 KB 0 rows\r\n. . imported \"LBACSYS\".\"OLS_DP$OLS$POLT\" 0 KB 0 rows\r\n. . imported \"LBACSYS\".\"OLS_DP$OLS$PROFILE\" 0 KB 0 rows\r\n. . imported \"LBACSYS\".\"OLS_DP$OLS$PROG\" 0 KB 0 rows\r\n. . imported \"LBACSYS\".\"OLS_DP$OLS$USER\" 0 KB 0 rows\r\n. . imported \"SYS\".\"AMGT$DP$AUD$\" 25.03 KB 11 rows\r\n. . imported \"SYS\".\"AMGT$DP$DAM_CLEANUP_EVENTS$\" 0 KB 0 rows\r\n. . imported \"SYS\".\"AMGT$DP$DAM_CLEANUP_JOBS$\" 0 KB 0 rows\r\n. . imported \"SYS\".\"DP$TSDP_ASSOCIATION$\" 0 KB 0 rows\r\n. . imported \"SYS\".\"DP$TSDP_CONDITION$\" 0 KB 0 rows\r\n. . imported \"SYS\".\"DP$TSDP_FEATURE_POLICY$\" 0 KB 0 rows\r\n. . imported \"SYS\".\"DP$TSDP_PROTECTION$\" 0 KB 0 rows\r\n. . imported \"SYS\".\"DP$TSDP_SENSITIVE_DATA$\" 0 KB 0 rows\r\n. . imported \"SYS\".\"DP$TSDP_SENSITIVE_TYPE$\" 0 KB 0 rows\r\n. . imported \"SYS\".\"DP$TSDP_SOURCE$\" 0 KB 0 rows\r\n. . imported \"SYSTEM\".\"REDO_LOG_TMP\" 0 KB 0 rows\r\n. . imported \"WMSYS\".\"E$BATCH_COMPRESSIBLE_TABLES$\" 0 KB 0 rows\r\n. . imported \"WMSYS\".\"E$CONSTRAINTS_TABLE$\" 0 KB 0 rows\r\n. . imported \"WMSYS\".\"E$CONS_COLUMNS$\" 0 KB 0 rows\r\n. . imported \"WMSYS\".\"E$LOCKROWS_INFO$\" 0 KB 0 rows\r\n. . imported \"WMSYS\".\"E$MODIFIED_TABLES$\" 0 KB 0 rows\r\n. . imported \"WMSYS\".\"E$MP_GRAPH_WORKSPACES_TABLE$\" 0 KB 0 rows\r\n. . imported \"WMSYS\".\"E$MP_PARENT_WORKSPACES_TABLE$\" 0 KB 0 rows\r\n. . imported \"WMSYS\".\"E$NESTED_COLUMNS_TABLE$\" 0 KB 0 rows\r\n. . imported \"WMSYS\".\"E$RESOLVE_WORKSPACES_TABLE$\" 0 KB 0 rows\r\n. . imported \"WMSYS\".\"E$RIC_LOCKING_TABLE$\" 0 KB 0 rows\r\n. . imported \"WMSYS\".\"E$RIC_TABLE$\" 0 KB 0 rows\r\n. . imported \"WMSYS\".\"E$RIC_TRIGGERS_TABLE$\" 0 KB 0 rows\r\n. . imported \"WMSYS\".\"E$UDTRIG_DISPATCH_PROCS$\" 0 KB 0 rows\r\n. . imported \"WMSYS\".\"E$UDTRIG_INFO$\" 0 KB 0 rows\r\n. . imported \"WMSYS\".\"E$VERSION_TABLE$\" 0 KB 0 rows\r\n. . imported \"WMSYS\".\"E$VT_ERRORS_TABLE$\" 0 KB 0 rows\r\n. . imported \"WMSYS\".\"E$WORKSPACE_SAVEPOINTS_TABLE$\" 0 KB 0 rows\r\nProcessing object type DATABASE_EXPORT\/NORMAL_OPTIONS\/VIEWS_AS_TABLES\/TABLE\r\nProcessing object type DATABASE_EXPORT\/NORMAL_OPTIONS\/VIEWS_AS_TABLES\/TABLE_DATA\r\n. . imported \"MDSYS\".\"RDF_PARAM$TBL\" 6.515 KB 3 rows\r\n. . imported \"SYS\".\"AMGT$DP$AUDTAB$TBS$FOR_EXPORT\" 5.960 KB 2 rows\r\n. . imported \"SYS\".\"DP$DBA_SENSITIVE_DATA\" 0 KB 0 rows\r\n. . imported \"SYS\".\"DP$DBA_TSDP_POLICY_PROTECTION\" 0 KB 0 rows\r\n. . imported \"SYS\".\"AMGT$DP$FGA_LOG$FOR_EXPORT\" 0 KB 0 rows\r\n. . imported \"SYS\".\"NACL$_ACE_IMP\" 0 KB 0 rows\r\n. . imported \"SYS\".\"NACL$_HOST_IMP\" 6.976 KB 2 rows\r\n. . imported \"SYS\".\"NACL$_WALLET_IMP\" 0 KB 0 rows\r\n. . imported \"SYS\".\"DATAPUMP$SQL$TEXT\" 0 KB 0 rows\r\n. . imported \"SYS\".\"DATAPUMP$SQL$\" 0 KB 0 rows\r\n. . imported \"SYS\".\"DATAPUMP$SQLOBJ$AUXDATA\" 0 KB 0 rows\r\n. . imported \"SYS\".\"DATAPUMP$SQLOBJ$DATA\" 0 KB 0 rows\r\n. . imported \"SYS\".\"DATAPUMP$SQLOBJ$PLAN\" 0 KB 0 rows\r\n. . imported \"SYS\".\"DATAPUMP$SQLOBJ$\" 0 KB 0 rows\r\n. . imported \"SYSTEM\".\"SCHEDULER_JOB_ARGS_TMP\" 0 KB 0 rows\r\n. . imported \"SYSTEM\".\"SCHEDULER_PROGRAM_ARGS_TMP\" 9.515 KB 12 rows\r\n. . imported \"WMSYS\".\"E$EXP_MAP\" 7.718 KB 3 rows\r\n. . imported \"WMSYS\".\"E$METADATA_MAP\" 0 KB 0 rows\r\nProcessing object type DATABASE_EXPORT\/NORMAL_POST_INSTANCE_IMPCALLOUT\/MARKER\r\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/TABLE\r\nProcessing object type DATABASE_EXPORT\/XS_SECURITY\/SCHEMA\/XS_ACL\r\nORA-39083: Object type XS_ACL:\"SYS\".\"NETWORK_ACL_CF6973C1EF8236DEE0531201000A24BE\" failed to create with error:\r\nORA-46212: XS entity with this name already exists.\r\n\r\nFailing sql is:\r\n\r\nDECLARE\r\n ace_list XS$ACE_LIST;\r\nBEGIN\r\n ace_list := XS$ACE_LIST(\r\n XS$ACE_TYPE(\r\n privilege_list => XS$NAME_LIST('\"RESOLVE\"'),\r\n principal_name=>'\"ORACLE_OCM\"',\r\n principal_type=>XS_ACL.PTYPE_DB));\r\n\r\n xs_acl.create_acl(\r\n name=>'\"SYS\".\"NETWORK_ACL_CF6973C1EF8236DEE0531201000A24BE\"',\r\n ace_list=>ace_list,\r\n sec_class=>'\"SYS\".\"NETWORK_SC\"',\r\n description=>'OCM User Resolve Network Access using UTL_INADDR');\r\nEND;\r\n\r\nProcessing object type DATABASE_EXPORT\/SCHEMA\/TABLE\/STATISTICS\/TABLE_STATISTICS\r\nProcessing object type DATABASE_EXPORT\/STATISTICS\/MARKER\r\nProcessing object type DATABASE_EXPORT\/END_PLUGTS_BLK\r\nProcessing object type DATABASE_EXPORT\/FINAL_POST_INSTANCE_IMPCALLOUT\/MARKER\r\nProcessing object type DATABASE_EXPORT\/SCHEMA\/POST_SCHEMA\/PROCACT_SCHEMA\r\nProcessing object type DATABASE_EXPORT\/AUDIT_UNIFIED\/AUDIT_POLICY_ENABLE\r\nProcessing object type DATABASE_EXPORT\/POST_SYSTEM_IMPCALLOUT\/MARKER\r\nJob \"SYS\".\"SYS_IMPORT_TRANSPORTABLE_01\" completed with 5 error(s) at Fri Oct 29 16:27:19 2021 elapsed 0 00:00:55<\/pre>\n[oracle@odbfcl-12-2-0-1 ~]$ export ORACLE_SID=orcl\r\n[oracle@odbfcl-12-2-0-1 ~]$ sqlplus \/ as sysdba\r\n\r\nSQL*Plus: Release 12.2.0.1.0 Production on Fri Oct 29 16:31:43 2021\r\n\r\nCopyright (c) 1982, 2016, Oracle. All rights reserved.\r\n\r\nConnected to:\r\nOracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production\r\n\r\nSQL> select count(*) from test.t1;\r\n\r\n COUNT(*)\r\n----------\r\n 2108\r\n\r\nSQL> select count(*) from test.t2;\r\n\r\n COUNT(*)\r\n----------\r\n 2191\r\n\r\nSQL><\/pre>\n
