Re: Adding datafiles to standby database with Data Guard

From: Richard Foote <richard.foote_at_bigpond.nospam.com>
Date: Thu, 10 Feb 2005 12:37:10 GMT
Message-ID: <WzIOd.155195$K7.90145@news-server.bigpond.net.au>

"arwel" <arwel.owen_at_princes.co.uk> wrote in message news:52e178a609f6a5fbde59e30e0f7ffd25_at_localhost.talkaboutdatabases.com...
> We currently run SAP over Oracle 8.1.7 and use an offiste standby database
> for our Disaster Recovery mechanism. We run the standby database manually,
> using xcopy to copy archive logs to the standby server and SAP's BRARCHVIE
> tool to apply, backup and then delete archive logs. When we add new
> datafiles to the primary database, we have to manually do the same on the
> standby side.
>
> We plan on upgrading to Oracle 9.2 and are interested in replacing the
> existing manual standby mechanism with Oracle Data Guard. My question is -
> does ODG automate/synchronise storage management between the primary and
> standby databases. If datafiles are added to the primary database, will
> ODG synchronise these additions onto the standby database, negating our
> current overhead of having to manually do this?
>

Hi Arwel.

Yes.

If you set the parameter STANDBY_FILE_MANAGEMENT = AUTO, adding and dropping files are done for you automatically by Oracle.

I would recommend reading up a tab on DataGuard before proceeding though ...

Cheers

Richard Received on Thu Feb 10 2005 - 06:37:10 CST