RE: standby
- From: "Mathias Zarick" <Mathias.Zarick@xxxxxxxxxxxx>
- To: <JEREMY.SHEEHAN@xxxxxxx>, "Howard Latham" <howard.latham@xxxxxxxxx>
- Date: Wed, 4 Feb 2009 18:12:30 +0100
Hi jeremy, howard
use parameters db_file_name_convert and/or log_file_name_convert to
accomplish that.
They can map the actual controlfile contents ...
Example:
map /u00 to /u01
on standby site:
alter system set db_file_name_convert = '/u00','/u01' scope=spfile;
on primary site vice versa.
alter system set db_file_name_convert = '/u01','/u00' scope=spfile;
HTH Mathias
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of SHEEHAN, JEREMY
Sent: Wednesday, February 04, 2009 5:56 PM
To: Howard Latham
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx]
Sent: Wednesday, February 04, 2009 11:52 AM
To: SHEEHAN, JEREMY
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxx>:
> 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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Howard Latham
> Sent: Wednesday, February 04, 2009 11:41 AM
> To: oracle-l@xxxxxxxxxxxxx
> 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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
>
>
--
Howard A. Latham
zn{i
--
//www.freelists.org/webpage/oracle-l
Other related posts:
