I have read about logical standby databases and want to use it in
my project for reporting.

My main database instance will be using Oracle9i RAC, Reporting database
instance may use only Oracle9i.

Are there any issues with Oracle9i RAC to Oracle9i for logical standy.
Also are there any issues from Oracle9i RAC to Oracle9i RAC.


Prem

Prem K Mehrotra wrote:

> I have read about logical standby databases and want to use it in
> my project for reporting.
>
> My main database instance will be using Oracle9i RAC, Reporting database
> instance may use only Oracle9i.
>
> Are there any issues with Oracle9i RAC to Oracle9i for logical standy.
> Also are there any issues from Oracle9i RAC to Oracle9i RAC.
>
>
> Prem

None technical ... a few financial.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

Prem K Mehrotra wrote:
> I have read about logical standby databases and want to use it in
> my project for reporting.
>
> My main database instance will be using Oracle9i RAC, Reporting database
> instance may use only Oracle9i.
>
> Are there any issues with Oracle9i RAC to Oracle9i for logical standy.
> Also are there any issues from Oracle9i RAC to Oracle9i RAC.

You mean, apart from the fact that logical standby has lots of bugs
associated with it, and doesn't actually work very reliably?

No, none at all.

Regards
HJR

"Howard J. Rogers" <hjr@dizwell.com> wrote in message news:<409dd70f$0$442$afc38c87@news.optusnet.com.au >...
> Prem K Mehrotra wrote:
> > I have read about logical standby databases and want to use it in
> > my project for reporting.
> >
> > My main database instance will be using Oracle9i RAC, Reporting database
> > instance may use only Oracle9i.
> >
> > Are there any issues with Oracle9i RAC to Oracle9i for logical standy.
> > Also are there any issues from Oracle9i RAC to Oracle9i RAC.
>
> You mean, apart from the fact that logical standby has lots of bugs
> associated with it, and doesn't actually work very reliably?
>
> No, none at all.
>
> Regards
> HJR


What bugs? Are there bugs in dataguard in general?

Ryan Gaffuri wrote:

> "Howard J. Rogers" <hjr@dizwell.com> wrote in message news:<409dd70f$0$442$afc38c87@news.optusnet.com.au >...
>
>>Prem K Mehrotra wrote:
>>
>>>I have read about logical standby databases and want to use it in
>>>my project for reporting.
>>>
>>>My main database instance will be using Oracle9i RAC, Reporting database
>>>instance may use only Oracle9i.
>>>
>>>Are there any issues with Oracle9i RAC to Oracle9i for logical standy.
>>> Also are there any issues from Oracle9i RAC to Oracle9i RAC.
>>
>>You mean, apart from the fact that logical standby has lots of bugs
>>associated with it, and doesn't actually work very reliably?
>>
>>No, none at all.
>>
>>Regards
>>HJR
>
>
>
> What bugs? Are there bugs in dataguard in general?

DataGuard physical standby databases have been around for a long time
and are pretty reliable.

Logical standby is much newer and doesn't seem to be robust enough to
use as a first choice for disaster recovery. For example, if you drop a
user and then re-import on the primary, including lots of constraints,
sequences, triggers, packages and procedures, in my tests the logical
standby eventually stalled out to the point where it was easier to just
re-create it than try to cajole the SQL apply to complete successfully.

But logical standby might be just the thing for other uses besides
disaster recovery. If you have ever implemented a physical standby so
that you could open it read-only from time to time, then logical standby
might better meet your needs.

Be sure to get the white paper from Metalink "Oracle 9i Dataguard: SQL
Apply Best Practices". I found several items there, not included in the
main documentation, which resolved some bugs I was experiencing.

--Mark Bole

Mark Bole <makbo@pacbell.net> wrote in message news:<joNnc.65698$Z15.25503@newssvr25.news.prodigy .com>...
> Ryan Gaffuri wrote:
>
> > "Howard J. Rogers" <hjr@dizwell.com> wrote in message news:<409dd70f$0$442$afc38c87@news.optusnet.com.au >...
> >
> >>Prem K Mehrotra wrote:
> >>
> >>>I have read about logical standby databases and want to use it in
> >>>my project for reporting.
> >>>
> >>>My main database instance will be using Oracle9i RAC, Reporting database
> >>>instance may use only Oracle9i.
> >>>
> >>>Are there any issues with Oracle9i RAC to Oracle9i for logical standy.
> >>> Also are there any issues from Oracle9i RAC to Oracle9i RAC.
> >>
> >>You mean, apart from the fact that logical standby has lots of bugs
> >>associated with it, and doesn't actually work very reliably?
> >>
> >>No, none at all.
> >>
> >>Regards
> >>HJR
> >
> >
> >
> > What bugs? Are there bugs in dataguard in general?
>
> DataGuard physical standby databases have been around for a long time
> and are pretty reliable.
>
> Logical standby is much newer and doesn't seem to be robust enough to
> use as a first choice for disaster recovery. For example, if you drop a
> user and then re-import on the primary, including lots of constraints,
> sequences, triggers, packages and procedures, in my tests the logical
> standby eventually stalled out to the point where it was easier to just
> re-create it than try to cajole the SQL apply to complete successfully.
>
> But logical standby might be just the thing for other uses besides
> disaster recovery. If you have ever implemented a physical standby so
> that you could open it read-only from time to time, then logical standby
> might better meet your needs.
>
> Be sure to get the white paper from Metalink "Oracle 9i Dataguard: SQL
> Apply Best Practices". I found several items there, not included in the
> main documentation, which resolved some bugs I was experiencing.
>
> --Mark Bole

Mark:

Thanks a lot, I was not aware of this metalink note. I want to use
logical standby more for reporting than for disaster rceovery. I know
it came only
in 9.2, but if people have used it for reporting without any major
problems
I will like to use it.


Thanks,

Prem