Skip to main content
Solved

Can Restore Oracle DB EE to Oracle DB SE

  • 28 October 2021
  • 2 replies
  • 325 views

Hi All,

I’ve problem smon when restore oracle DB EE to oracle DB SE. it can be possible restore DB EE to DB SE ? i search in oracle forum, using rman it’s not possible to restore DB EE to DB SE, must migrate the data. i using CV 11.20. My pfile and spfile is copied from DB EE to DB SE and set same DB ID too. Anyone have same problem ?

2 replies

Userlevel 3
Badge +10

Hi @riski.pe 

 

I asked one of my colleges whom seems to an Oracle geek :-) He says “No you can’t”. You basically have to do an export / import into a new DB. The other other way around, though, is easy he says…. what ever he means by this :-)   So if this isn’t possible (or supported) within Oracle itself, I’m sure Commvault won’t be able to do this either.. 

 

Have a great day.. 

 

Kind regards

Rubeck

Userlevel 2
Badge +7

As per Oracle Support document

Converting An Enterprise Edition Database To Standard Edition (Doc ID 139642.1)

The only way to properly convert from an Enterprise Edition back to a Standard Edition is through an Export/Import operation

Reply