Skip to Main Content
  • Questions

  • Oracle Manual Standby - Log shipping

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, Vasco .

Asked: December 15, 2015 - 9:28 pm UTC

Last updated: December 16, 2015 - 1:39 am UTC

Version: 11G

Viewed 1000+ times

You Asked

I´ve implemented a manual standby procedure for synchronizing a Primary Database with a Standby database, using a slightly modified approach as the one described here: http://managingoracle.blogspot.pt/2012/04/oracle-manual-standby-no-dataguard.html

The simple example i used for a testing scenario works correctly, but the procedure synchronizes ALL database.

Is it possible to use a similar procedure, using Log Shipping, BUT, specifying a single schema, instead of the entire database?

Thanks in advance.

and Connor said...

Nope.

Redo logs, and hence redo Log shipping is database-wide.

You could craft all sorts of complicated scenarios using tablespace-point-in-time-recovery, but that would be very hard.

You might to check out

- streams or goldengate
- logical standby
- data pump

in order to get what you want.

Rating

  (1 rating)

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

Comments

Response review

Vasco Oliveira, December 16, 2015 - 9:50 am UTC

The response was extremely helpful, and addressed one of my major questions regarding Log shipping.
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 latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Data Pump

All of the database utilities including Data Pump are explained in the Utilities guide.