Skip to Main Content
  • Questions

  • Alternative for standby database in Oracle 19c standard edition 2

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Luis Manuel.

Asked: April 01, 2023 - 8:19 pm UTC

Last updated: April 18, 2023 - 3:24 am UTC

Version: Oracle 19c SE 2

Viewed 10K+ times! This question is

You Asked

Hi Tom in my organization we have Oracle Standard Edition 2.

I am trying to create a manual DataGuard, but when duplicating the production database the resulting clone has a different dbid and therefore I cannot apply the archived redo. Could you tell me the correct command to duplicate the database and that the clone has the same dbid?
And any other suggestion that you can advise me.

Thanks a ton.

and Connor said...

Rather than a duplicate, you need to truly "clone" the database, ie, copy the datafiles/controlfiles/spfile/etc

Thus you can

- shutdown the source db
- copy the files to a new location
- start the copied database in mount mount
- issue manual recovery.

If you are seriously heading down the DataGuard path for SE, it might be best to look at 3rd party soluitions (eg DB Visit).

Otherwise, note that you can migrate to autonomous from SE2 for basically a like-for-like license cost.

See https://www.oracle.com/assets/paas-iaas-universal-credits-3940775.pdf

Rating

  (3 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Luis Manuel Castillo, April 05, 2023 - 7:48 pm UTC

Thank you very much for your timely and prompt response.
Connor McDonald
April 06, 2023 - 6:46 am UTC

Glad to help

Why not use RMAN?

John, April 10, 2023 - 5:18 pm UTC

Wouldn't it be so much easier and less risky to use RMAN?

duplicate database for standby from active database dorecover;

Connor McDonald
April 11, 2023 - 4:33 am UTC

"duplicate database for standby" might not work or might be a violation of license usage for a Standard Edition database.

(I have not checked this, but it worries me :-))

Follow up to use of RMAN Duplicate with SE2

John, April 17, 2023 - 11:32 pm UTC

I haven't found any evidence that RMAN Duplicate Database is a restricted feature. RMAN table level and block level restore, as well as advanced compression are clearly off limits. But, the licensing information available online is not entirely clear in many respects.
Is there any chance that you might recruit a licensing expert to join your support team here?
I have a hunch that I'm not alone in navigating the shark-infested waters of SE2 vs EE, and the consequences of crossing a line.
Connor McDonald
April 18, 2023 - 3:24 am UTC

Thats what support.oracle.com is for. They are always the best place for license issues because they have access to your license details etc
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database