Re: Logical Standby

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 19 Jan 2023 17:05:28 -0500

On 1/19/23 16:54, Ram Raman wrote:

Hi,
We are looking into setting up logical standby in ver 19. We want to replicate 4 small (in size) schemas on the standby with the possibility to query the data in the standby in Linux. Can anyone point to a link other than manual? TIA.
We are also considering exporting the schemas, ftping and importing into the standby nightly. If anyone has scripts for that, please feel free to share.
PS. I have setup physical data guard standby in versions 10, 12 and 19.
Thanks,
Ram.
--

I believe you'll find everything that you need here:

https://docs.oracle.com/en/database/oracle/oracle-database/19/books.html

Also, logical standby is being deprecated. You should go with GG.

--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 01-2023