Re: Standy database / RMAN

I was thinking of logical standby because I wanted to offload running reports to the standby. But, on reading the docs further, I will not be able to use logical standy because of the datatype restrictions etc.

By 'one of our servers' I meant I have several Oracle d/s servers and I was trying on one of them first. And no, the standby will not be on the same server as primary.
And since DG is your speciality, I will ask this question again: what happens when I have to apply patches. Is it as simple as shutdown primary & standby, applying the patches and startup again?

Thanks,

Manjula
Carel-Jan Engel <cjpengel.dbalert_at_xs4all.nl> wrote:
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

> 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> -----------------------------------------------------------------

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.