Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help! Oracle server clustering
"Chuck" <chuckh_at_softhome.net> wrote in message
news:afhn3n$efnlt$1_at_ID-85580.news.dfncis.de...
>
> "Saikat Chakraborty" <saikatchak_at_hotmail.com> wrote in message
> news:2c24cdd695a0172b417e6aea2c72dd1f.16981_at_mygate.mailgate.org...
> > Howard,
> [snipped]
> > Adding a datafile is a problem. It stops the recovery process from
> > happening. You need to *cold* copy the datafile from primary
> > to standby and add it to your standby database by the command
> > ALTER DATABASE CREATE DATAFILE '<datafile name>' AS '<datafile name>';
> > After that, recovery can proceed as normal.
>
> Not true. I routinely add datafiles to my standby by a hot backup. I put
the
> tablespace into backup mode, ftp the new file to the standby, then take
the
> tablespace out of backup mode. This has never caused a problem on the
> standby in versions 8.1.5 or 8.1.7.
>
>
Oh yeah. Forgot to mention. The only action necessary on the standby is to restart the recovery if it has already failed. The recovery adds the datafile to the controlfile for me. Received on Fri Jun 28 2002 - 08:13:54 CDT