Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database opened in restricted mode after unplug and plug

Chandar_AUAug 12 2023 — edited Aug 12 2023

Hi Expert,

I tried to move my PDBs from one database to other using DBCA. I unplugged and plugged it back using DBCA but unfortunately the database was opened in restricted mode.

====

Environment:

Database : Oracle 19c (19.19.0.0.0)

OS: Ms Windows 2016 server edition 64 bit.

Feature : Oracle multi tenant multiple PDBs.

====

I tried following ,

  • Compiled the databaseusing utlrp which did not help
  • I ran datapatch.sql which also did not help
  • I tried to open database in read/write using force clause which also did not help."alter pluggable database prod_copy open force"I tried following ,
  • Compiled the databaseusing utlrp which did not help
  • I ran datapatch.sql which also did not help
  • I tried to open database in read/write using force clause which also did not help."alter pluggable database prod_copy open force"

Thank in advance!

Ram

This post has been answered by Chandar_AU on Aug 18 2023
Jump to Answer
Comments
Post Details
Added on Aug 12 2023
3 comments
930 views