Home » Server Options » Multitenant » Migration from PDB to Non PDB oracle 19.11 database (linux x86_64 , 7.9 )
Migration from PDB to Non PDB oracle 19.11 database [message #685441] Tue, 11 January 2022 13:22 Go to next message
User_oracle1999
Messages: 5
Registered: January 2022
Junior Member
we have a 20TB oracle 19.11 plugable database on RHEL 7.9 , that we are looking to migrate to Non plugable 19.11 oracle single instance database on RHEL 7.9 .

Can we use transportable tablespace for the same ?

has anyone applied this solution ?

Due to databases size , we are not considering exp/imp.

We can not consider goldengate > cost issue .


Re: Migration from PDB to Non PDB oracle 19.11 database [message #685442 is a reply to message #685441] Tue, 11 January 2022 15:10 Go to previous messageGo to next message
John Watson
Messages: 8782
Registered: January 2010
Location: Global Village
Senior Member
Welcome to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

You cannot convert a PDB into a non-CDB. This is a documented technology limitation. Note that non-CDB is de-supported in the next release. Why do you want to do this? If you can explain, perhaps a solution can be found.
Re: Migration from PDB to Non PDB oracle 19.11 database [message #685443 is a reply to message #685442] Tue, 11 January 2022 15:14 Go to previous messageGo to next message
User_oracle1999
Messages: 5
Registered: January 2022
Junior Member
This database is being migrated from customers in-house setup to our setup on cloud .
The application design on cloud is such that the databases are created with standalone filesystem based non Rac and non CDB databases .

[Updated on: Tue, 11 January 2022 15:21]

Report message to a moderator

Re: Migration from PDB to Non PDB oracle 19.11 database [message #685444 is a reply to message #685443] Tue, 11 January 2022 15:22 Go to previous messageGo to next message
John Watson
Messages: 8782
Registered: January 2010
Location: Global Village
Senior Member
You did not say which cloud, but (unless your customer is financially insane) it must be OCI, and an OCI DB System (VM or BM) can certainly be file system based and non-RAC. But surely there can be no reason to insist on non-CDB. If your design is limited to non-CDB, you will have problems moving forward. This customer will be the first of many that you have to reject.

Perhaps someone else can come up with a solution, but I shall have to retire.


Re: Migration from PDB to Non PDB oracle 19.11 database [message #685445 is a reply to message #685444] Tue, 11 January 2022 15:26 Go to previous messageGo to next message
User_oracle1999
Messages: 5
Registered: January 2022
Junior Member
Could we take any kind of rman backup from PDB and restore it in Non CDB ?

[Updated on: Tue, 11 January 2022 15:27]

Report message to a moderator

Re: Migration from PDB to Non PDB oracle 19.11 database [message #685446 is a reply to message #685445] Tue, 11 January 2022 15:33 Go to previous messageGo to next message
User_oracle1999
Messages: 5
Registered: January 2022
Junior Member
I found this on PDB to non CDB conversion . Could this be used in this case :
https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=228306474737197&id=2027352.1&_afrWindowMode=0&_adf.ctrl-s tate=81t9n5wk9_4
Re: Migration from PDB to Non PDB oracle 19.11 database [message #685448 is a reply to message #685446] Wed, 12 January 2022 02:10 Go to previous messageGo to next message
Frank
Messages: 7897
Registered: March 2000
Senior Member
Since running upto 3 PDBs in a CDB does not require a multi-tenancy license, and since legacy databases (i.e. non-CDB) will (most likely) no longer be supported in new versions, why would you go through all this trouble?
(Edit: Note that the 3 PDB limit is for release 19 and up; before that 1 PDB was allowed without the multi-tenancy license)

[Updated on: Wed, 12 January 2022 02:11]

Report message to a moderator

Re: Migration from PDB to Non PDB oracle 19.11 database [message #685452 is a reply to message #685444] Wed, 12 January 2022 04:59 Go to previous message
User_oracle1999
Messages: 5
Registered: January 2022
Junior Member
we are using IBM cloud . - VMware vsphere .

This database is being migrated from customers in-house setup to our setup on cloud .
The application design on cloud is such that the databases are created with standalone filesystem based non Rac and non CDB databases .

[Updated on: Wed, 12 January 2022 04:59]

Report message to a moderator

Previous Topic: Which Database, CDB or PDB, Should I Use for my Tables, and How Do I Connect Forms12 to CDB?
Goto Forum:
  


Current Time: Fri Dec 02 13:40:43 CST 2022