RE: standby

From: Klonicki, Stephen A <SKLONICK_at_tycoelectronics.com>
Date: Wed, 4 Feb 2009 13:40:59 -0500
Message-ID: <D00A9309AEEDEC4387F2751F859B210104AFFB6C75_at_us194mx002.tycoelectronics.net>

That is true that DB_FILE_NAME_CONVERT is for standby datafile, rather than standby controlfiles.

However, The Original Poster (OP) said 'Thanks - That only works if the files are in the same place on the primary database. What if the layout if different.?'

So Howard is saying that the layout is different, that would include standby datafiles. So he needed a way to rebuild the standby controlfile and be able to address the layout differences between production and standby.

That is why I included information regarding DB_FILE_NAME_CONVERT.

Regards,
Steve

---

From: Vishal Gupta [mailto:vishal_at_vishalgupta.com] Sent: Wednesday, February 04, 2009 1:33 PM To: Klonicki, Stephen A; oracle-l_at_freelists.org Subject: RE: standby

Stephen,

DB_FILE_NAME_CONVERT is only valid for standby datafile, not standby controlfile. But you have answer the question in your original post. ie. create the control for standby on production and copy across to standby database.

Regards,
Vishal Gupta
http://www.vishalgupta.com

---

From: oracle-l-bounce_at_freelists.org on behalf of Klonicki, Stephen A Sent: Wed 04/02/2009 17:00
To: oracle-l_at_freelists.org
Subject: RE: standby

Option 1.

DB_FILE_NAME_CONVERT: Syntax:

DB_FILE_NAME_CONVERT: = 'oldstring1', 'newstring1', 'oldstring2', 'newstring2', ...

Specify the location of the primary database datafiles followed by the standby location of the datafiles. It will convert datafile name of primary database to datafile name of the standby datafile. If the primary and standby database are on the same system or if the directory structure of primary and standby database is different then this parameter is required.

Option 2.
Rename the database on the standby while it is in MOUNT mode.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of SHEEHAN, JEREMY Sent: Wednesday, February 04, 2009 11:56 AM To: Howard Latham
Cc: oracle-l_at_freelists.org
Subject: RE: standby

That's a good question.... I've never had to do that before. All my standby db's were in the same format as my prod. I did a quick check on google, but couldn't find anything relevant... Sorry!

Jeremy
P Consider the environment. Please don't print this e-mail unless you really need to.

-----Original Message-----
From: Howard Latham [mailto:howard.latham_at_gmail.com] Sent: Wednesday, February 04, 2009 11:52 AM To: SHEEHAN, JEREMY
Cc: oracle-l_at_freelists.org
Subject: Re: standby

Thanks - That only works if the files are in the same place on the primary database. What if the layout if different.?

2009/2/4 SHEEHAN, JEREMY <JEREMY.SHEEHAN_at_fpl.com>:
> Google = Good
>
> http://www.tiplib.com/138/create-standby-controlfile
>
> Jeremy
> P Consider the environment. Please don't print this e-mail unless you really need to.
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Howard Latham
> Sent: Wednesday, February 04, 2009 11:41 AM
> To: oracle-l_at_freelists.org
> Subject: standby
>
> Oracle 11g
> Redhat Linux,
> We lost the controlfile from a standby its not THAT important but
> whats the simplest way to rebuild it?
> We can backup the primary control file to trace;
>
>
> --
> Howard A. Latham
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
>

--
Howard A. Latham

m  祊 l ? j 嗃i?龙込X?凕n枲{?i蒦

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 04 2009 - 12:40:59 CST