Re: Standby DB & New Datafile

From: Stephan Bressler <sbresslerx_no_spam_at_arcor.de>
Date: Mon, 22 Mar 2004 15:58:44 +0100
Message-ID: <c3mutp$1hn$1@news.mch.sbs.de>

Mill wrote:

> Hi
>
> We run oracle 8i on w2k server at our site we have a production db & standby
> db,
> I have recently created a new datafile on the production system do i need to
> create the
> same on the standby machine or will it automatically create the file from
> the archive logs ?
>
> I presume i can't just create the same file on the standby db as it's only
> ever open
> in read only mode !

Hi,
8i is not capable of creating datafiles on the standby side. If you create d datafile on prod, just wait till the standby side passes by this event. After that, the standby side knows about the new datafile, although it's not created automatically. Now you can run "alter database created datafile 'your_file' as 'your_file2' size _the_same_as_on_prod;";

That's it. If you do not add the datafile soon, the standby will stop recovering as soon as a block in the new datafile is accessed for the first time.

HTH
Stephan Received on Mon Mar 22 2004 - 08:58:44 CST