RE: standby
- From: "Vishal Gupta" <vishal@xxxxxxxxxxxxxxx>
- To: <SKLONICK@xxxxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 4 Feb 2009 18:33:20 -0000
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
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
>
>
--
Howard A. Latham
m ? l ? j ?i????X??? n?{?i?
Other related posts:
