Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Adding a datafile to a standby database

Re: Adding a datafile to a standby database

From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Mon, 17 Sep 2001 14:38:55 -0400
Message-ID: <9o5g0h$b7i4b$1@ID-85580.news.dfncis.de>


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
>
>


Received on Mon Sep 17 2001 - 13:38:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US