RE: Standy database / RMAN
- From: "Mark W. Farnham" <mwf@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 2 Sep 2004 18:16:42 -0400
For 1x extra alloquot of disk you can do both physical standby and copy it
to something to rename and open once a day or once a week.
At the end of some logical business process you cancel recovery, shut down
(keep receiving logs, just don't apply them), then copy, rename and open the
reporting database. Now, it is frozen in time, but that can be a good thing
if Finance folks want as of data stuff, plus generation of aggregates to
drastically speed up many reports becomes a legitimate option. I'm not sure
whether my paper on this has aged off the oaug.org site. You can basically
make this work from 6.0.33 or so on. It has the side benefit of actually
opening the copy of the standby so you get a repeated test that there are no
surprises.
It is also a good use of the horsepower of the standby machine, which is
probably coasting otherwise.
-- just another way to skin that cat
mwf
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Manjula Krishnan
Sent: Thursday, September 02, 2004 10:34 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Standy database / RMAN
Our users run huge reports all day. I plan to offload the reports to the
standy and that is why logical standby. Also, the drives are fully striped
and mirrored, so we should have good protection.
We will be using Tivoli for backup. Once TDP for Oracle is setup I will just
have to modify the scripts to use dsmc instead. I will know more once I
finish reading the Tivoli docs.
What happens if I have to apply patches? I just shutdown both the primary
and the standby, apply patches and bring them up again?
Thanks for the link... I will read that too.
Manjula
GovindanK <gkatteri@xxxxxxxxxxx> wrote:
Setting up RMAN is not that difficult ; You need to setup Media Manager
for Oracle. RMAN is quite robust for backup. Some DBAs are of the
openion that they will use RMAN for Restoring and use svrmgrl / sysdba
for recovery related stuff. Depends on various factors. Are you sure
you want Logical Standby and not Physical. Anyway it is better to have a
Standby setup just in case ...;
Backup Recovery 101 is good for RMAN though there is one by Robert
Freeman.
For Standby i suggest you read books/manuals and test it out.
In both the above cases, there is no substitute for trying out all
possibel combinations you can think of prior to implementing.
HTH
GovindanK
On Wed, 1 Sep 2004 08:37:56 -0700 (PDT), "Manjula Krishnan"
said:
> 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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
---
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe
To read recent messages - //freelists.org/archives/oracle-l/09-2004
---
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe
To read recent messages - //freelists.org/archives/oracle-l/09-2004
Other related posts:
