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@xxxxxxxxxxxxx on behalf of Klonicki, Stephen A
Sent: Wed 04/02/2009 17:00
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of SHEEHAN, JEREMY
Sent: Wednesday, February 04, 2009 11:56 AM
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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
>



--
Howard A. Latham


m     ? l  ?   j      ?i????X???n?{?i? 

Other related posts: