Skip to Main Content

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question.

Asked: August 16, 2021 - 9:34 am UTC

Last updated: August 18, 2021 - 5:57 am UTC

Version: Oracle 12C 12.1.0 Standard Edition

Viewed 1000+ times

You Asked

Dear Team,
I am in a process of creating a physical standby database. Already I have created one and synching this physical standby database by shipping log files from primary database and applying them at the secondary site. For this purpose I have written a cron job in linux to automate this process. My query is whether it is possible to shipping and applying log files using some oracle mechanism. Oracle version is 12c 12.1.0 standard edition. If its possible please give me some links or writeups.

Thanks in advance.

and Connor said...

Not with Standard Edition unfortunately.

For SE, you'll need to continue with what your doing, ie, manual transfer/apply.

Alternatively, you can check out DBVisit who do a commercial implementation of the same.

Rating

  (1 rating)

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

Comments

Physical database

A reader, August 17, 2021 - 2:40 pm UTC

Thanks for clearing my doubts. I tried a lot to automate it using oracle itself and then got the feeling may be its standard edition which is restricting this automation.
Connor McDonald
August 18, 2021 - 5:57 am UTC

Yup. DataGuard is a sweet tool...but its EE
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