Re: rename data file on standby database

From: Jose Luis Delgado <joseluis_delgado_at_yahoo.com>
Date: Thu, 04 Sep 2003 07:25:07 -0800
Message-ID: <F001.005CEC84.20030904072507@fatcity.com>

Hi Kader...

you do not need to do the same on the standby database...

That logical changes are reflected automatically... The only thing is that your physical datafile remain as initially, but your controlfile has the changes.

Was I clear?

note that the only changes that you need to do at your standby database is when you add tablespaces/datafiles to your primary database, then you need to add them to your standby database.

HTH
JL

• Kader Ben <kaderb_at_yahoo.com> wrote:
  > Hi Listers,
  >
  > I have standby database working fine (until now!). I
  > have renamed one datafile on the primary database
  > and
  > I'm wondering if I have to do the same thing on the
  > standby database to reflect the structure change.
  > I have renamed the file yesterday and the standby
  > database stil recovering incoming archives without
  > any
  > error but the data file renamed on the primary
  > database is on the its original location on the
  > standby database.
  >
  > Many thanks for your help,
  >
  > Kader
  >
  >
  >
  > __________________________________
  > Do you Yahoo!?
  > Yahoo! SiteBuilder - Free, easy-to-use web site
  > design software
  > http://sitebuilder.yahoo.com
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.net
  > --
  > Author: Kader Ben
  > INET: kaderb_at_yahoo.com
  >
  > Fat City Network Services -- 858-538-5051
  > http://www.fatcity.com
  > San Diego, California -- Mailing list and web
  > hosting services
  >
  

  ---

  
  > To REMOVE yourself from this mailing list, send an
  > E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of
  > 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB
  > ORACLE-L
  > (or the name of mailing list you want to be removed
  > from). You may
  > also send the HELP command for other information
  > (like subscribing).
  

  ---

Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jose Luis Delgado
  INET: joseluis_delgado_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Sep 04 2003 - 10:25:07 CDT