Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Backup & Recovery/Standby Server Question
I would think
#2 Re-create the control file for the standby database.
#3 alter database rename datafile from x to x
But what do I know?
Barry
the Alter Database command should occur at the primary server, then the dat
file copied over to the stand by server
"Jeff" <jeff_at_work.com> wrote in message
news:a3ca8h$qn4$1_at_cronkite.cc.uga.edu...
> This is from Oracle's 8i Backup & Recovery course book. It's talking
about
> adding datafiles to your standby database.
>
> It says to:
> 1) Copy the datafile from the primary to the standby database. I
understand
> this step.
>
> 2) Add the datafile to the standby database with the ALTER DATABASE CREATE
> DATAFILE command.
>
> 3) Re-create the control file for the standby database.
>
> What I'm confused on is why step #2 (or #3, depending on which you choose)
is
> necessary. If step #2 only creates an entry in the control file for the
added
> datafile, wouldn't this be made moot by recreating the control file in
step
> #3?? What is step #2 doing that step #3 doesn't?
>
> <pause>
>
> Searching Oracle's online docs seems to bear this out here:
> http://otn.oracle.com/doc/server.815/a67773/standby.htm#2524
> in that they don't do step #3 at all, which makes step #2 (they do this)
make
> some sense then.
>
> Now I'm wondering if this is just another error in the course book?
> If anyone at Oracle was ever wondering how some of those RMAN myths got
> started, per the metalink document on RMAN myths... *shaking course book*
> .. here you go.
Received on Fri Feb 01 2002 - 08:32:40 CST
![]() |
![]() |