Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Adding a datafile to a standby database
The easiest way is to make a hot backup of the datafile in question and copy
it to the appropriate location on the standby system. Then restart the
automatic recovery. It's worked for me.
"Night Shade Books" <jasonw_at_nightshadebooks.com> wrote in message
news:7FFD13AABA2BD95B.3E9F9C5C6F962885.D1FF5AB44A0316E6_at_lp.airnews.net...
> "Night Shade Books" <jasonw_at_nightshadebooks.com> wrote in message
> news:2E60981B73DF1346.1B32BAFF898B299E.14013B4FB67902A0_at_lp.airnews.net...
> > I've added a datafile to my existing production db, and am now trying to
> > create it on my standby database. The last time I did this, I looked it
> up
> > on Metalink, but the site has been down (or at least unreachable to me)
> for
> > several hours now.
> >
> > I was trying :
> >
> > alter tablespace INDX03A
> > add datafile '/u03/oradata/EBPRDS1/indx03a_03.dbf'
> > size 501M;
> >
> > but I get an error that the database is not open. I'm not really sure
how
> > to go about this, and I don't have any documentation handy, as I'm at
home
> > and my docs are at the office.
> >
>
> Ok, I figured it out. I took the standby out of managed recovery mode,
and
> then did a
>
> alter database create datafile '/u03/oradata/EBPRDS1/indx03a_03.dbf' as
> '/u03/oradata/EBPRDS1/indx03a_03.dbf'
>
> and then put it back in managed recovery mode. I did a logfile switch on
> the primary, and the standby started humming through the backed-up
logfiles,
> and is working perfectly.
>
> Jason
>
>