Re: adding datafile to prod and standby issues

Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message news:<tqof50pglvdgvkgf5hnbr9p97b5u04ne8d_at_4ax.com>...
> On 16 Mar 2004 20:56:30 -0800, yls177_at_hotmail.com (yls177) wrote:
>
> >hi, wanted to confirm my analysis
> >
> >1) add datafile in prod
> >standby cant add have to wait.. cos
> >ORA-01156: recovery in progress may need access to files
> >
> >am i right?
>
> Adding datafiles to a production/standby situation is described in the
> standby manual. IIRC you need to get the standby database out of
> managed recovery, create an empty datafile, and apply any logs created
> at the production since you stopped manage recovery. Please review the
> standby documentation instead of experimenting on-the-fly.
> 228 datafiles for a database looks like sheer madness to me.

really? :P

if i mentioned that my datafiles are a whole 40gb size, what will be your response? :D

my applications are on sap. Received on Wed Mar 17 2004 - 23:10:11 CST