Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Adding datafiles to standby database with Data Guard
"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