Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Adding a datafile to a standby database
"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 Received on Sat Sep 15 2001 - 21:42:20 CDT