OraFAQ Forum: Multitenant » Migration from PDB to Non PDB oracle 19.11 database

Home » Server Options » Multitenant » Migration from PDB to Non PDB oracle 19.11 database (linux x86_64 , 7.9 )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Migration from PDB to Non PDB oracle 19.11 database [message #685441]

Tue, 11 January 2022 13:22

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 .

Report message to a moderator

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

John Watson
Messages: 8944
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.

Report message to a moderator

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

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

John Watson
Messages: 8944
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.

Report message to a moderator

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

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

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

Report message to a moderator

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

Frank
Messages: 7901
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

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?
Next Topic:	ORA-39712

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Sep 07 11:37:45 CDT 2024