Oracle DataGuard from another DataGuard

In Data Guard Set up, we have a primary and we can have upto nine stanbdby by databases which can be Physical or Logical.

Question is, Can I create a Logical Dataguard from another Physical Dataguard. We have a situation where we want to minimise cross the country network traffic and create a Logical Dataguard from an existing Physical Dataguard.

Please reply to KA10900@gmail.com  

Sincerely,

Kamal Agnihotri
Kamal AgnihotriAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

fluglashCommented:
take a look at metalink notes 789370.1 and 738643.1. There`s a guide on how to create physical standby dbs and how to convert to logical.
0
Richard OlutolaConsultantCommented:
In fact, to create a logical standby you have to create a physical standby first and then convert it to a logical standby.

So the answer is YES.

R.
0
Kamal AgnihotriAuthor Commented:
Let me rephrase, there is a Primary called Prim_1 and a Physical Standby called Phy_StdBy_1. They are working fine in tandem. Question is can I make another Phy_Stdby_2 FROM Phy_Stdby_1  WITHOUT TOUCHING the Primary Prim_1.
 
In my openion, the answer should be NO.

I can create UPTO nine Physical or Logical Standyby from one Primary database and can convert a Physical to a Logical Database but can not create another Physical or Logical Standby from another Physical Standby.

If my understanding is false, please point me to the Oracle Documentation that shows how to do that.

Thanks.

Kamal Agnihotri
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

fluglashCommented:
has no sense. is ti simple curiosisty?
0
Richard OlutolaConsultantCommented:
I understand what KamalAgnihotri is trying to do. He want to create another standby from existing standby so that the primary database is not disrupted during the process. This is because normally there is some downtime when creating standby from primary.

However, I don't think it is possible. Because the primary will be shipping to the new logical therefore the new logical must be created from the Primary.

I may be wrong.

Sorry I'm busy writing notes for dataguard training :) and I don't have time to give better explanation or research further into this. Perhaps later if it's still required.

R.
0
Mark GeerlingsDatabase AdministratorCommented:
No, it is not possible, because a standby is based on the archived redo logs of the primary.  A standby does not generate archived redo logs to pass on to another database.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Kamal AgnihotriAuthor Commented:
This Question can now be closed as it has been answered appropriately by markgeer.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.