Re: Standby DB & New Datafile

"Mill" <mill.h_at_ntlworld.com> wrote in message news:<SpW5c.59$%G5.1_at_newsfep3-gui.server.ntli.net>...
> 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 !
>
> Regards
>
> Mill.

The Oracle8i Standby Concepts Guide has a section entitled Adding Tablespaces or Datafiles to the Primary Database.

http://download-west.oracle.com/docs/cd/A81042_01/DOC/server.816/a76995/standbym.htm#27178

jg

--
@home.com is bogus. "He is a sex-abuse survivor, an alcoholic, a
cocaine addict and "a pawn in a racial game." He is also bipolar,
eccentric, short, pained by a toothache and given to thoughts of
suicide. Plus, he was overworked, he developed a travel phobia
(explaining why he faked out-of-town assignments), he was more
affected than his colleagues by Sept. 11, and his bosses could have
averted his self-destruction had they only paid attention. "
http://www.signonsandiego.com/uniontrib/20040318/news_1c18blair.html