| 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: Standy database / RMAN
Manjula,
On the RMAN topic others can advise you better than I can. Data Guard
(DG) is my cup of tea.
Why are you choosing Logical Standby (LSB)? It has quite some restrictions, and IMHO this is not reliable enough for High Availability (HA) purposes. LSB takes more resources on the primary, because additional logging has to be written to enable the standby to reconstruct the SQL. One wrong transaction or data type will break the SQL Apply process, and creates the need to manually fix the problem (if possible at all) before you can continue. Another thing is you mention 'one of our servers'. I presume this doesn't mean that you are going to run both instances/databases on the same server, do you? That wouldn't add too much to your redundancy/availability. If you want HA, go for Physical Standby (PSB). LSB consumes far more resources on your standby server, it has to reverse engineer SQL from the redo information and the execute it, generating redo and all the overhead of updating indexes again. No problem if your LSB server is just there in case of, but people tend to make it useful by loading other tasks on the server.
Bottom line:
- RMAN: go for it
- Data Guard: fine, but for HA use PSB, not LSB
Best regards,
Carel-Jan Engel
===
If you think education is expensive, try ignorance. (Derek Bok)
===
On Wed, 2004-09-01 at 17:37, Manjula Krishnan wrote:
> Hi:
>
> I want to implement both 9i Data Guard and RMAN on one of our servers (AIX 5.2, Oracle 9.2.0.4 64 bit). This server is in the process of being tested. It will go into production sometime in October. Hot backups are currently being performed nightly (just with scripts no RMAN).
> 1. I want to setup RMAN. How easy or difficult is it to switch from these scripts to using RMAN?
> 2. I also want to implement logical standby for max availability.
> -- When the data is refreshed for going live, will it affect the logical standy in any way. I think I will have to recreate it.
> -- What about RMAN? How will the backups using either RMAN or the scripts affect the standby?
>
> I am reading the Oracle DataGuard (rel 9.2) on technet and other related metalink documents.
>
> What else do I need to be aware of? Please point me to anything else you think I should read before getting started.
>
> Thanks,
>
> Manjula
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Mail - 50x more storage than other providers!
>
> ----------------------------------------------------------------
> 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
> -----------------------------------------------------------------
-- 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 Wed Sep 01 2004 - 21:48:34 CDT
 |
 |