| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Physicall to Logical
Thanks Carel
The requirement for LSB is for Reporting purpose and it is initially been created as Physical standby as the Primary Hardware was not stable as well as Database size is too big to be backed up on the Disk. Now we have got all issue resolved and so thought of taking this database back to the LSB
Thanks Again for your views and suggestion
Sanjay
Carel-Jan Engel <cjpengel.dbalert_at_xs4all.nl> wrote:
Sanjay,
Conversion between Standby types is non-existent. You have to drop the PSB,
and re-instantiate an LSB.
I don't know whether you are right or not, LSB is released with 9iR2, and
certainly isn't very stable.
I wouldn't rely on it for HA-purposes. For reporting, with restrictions in
mind about unsupported data- and objecttypes, the cost of additional
logging etcetera, it might help you.
Don't jump into solutions, but get your requirements for standby written
down properly first. Then determine whether a proposed solution will work.
And test!
You might consider (if space allows you) to have PSB as well as LSB. PSB
for HA, LSB for reporting.
Regards, Carel-Jan
===
If you think education is expensive, try ignorance. (Derek Bok)
===
At 09:48 PM 5/14/2004, you wrote:
>Hi
>
>Can anybody has an idea that how can I convert mine existing Physical
>standby to Logical standby. I am on 9iRel 2 and If I am right then
>Logicall standby is working good in this release.
>thanks in Advance
>
>Sanjay
>
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- --------------------------------- Do you Yahoo!? SBC Yahoo! - Internet access at a great low price. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Sun May 16 2004 - 21:33:11 CDT
 |
 |