RE: Data Guard Follow-up
- From: <Christopher.Taylor2@xxxxxxxxxxxx>
- To: <srcdco@xxxxxxx>, <cichomitiko@xxxxxxxxx>
- Date: Mon, 3 Jun 2013 15:29:48 -0500
Scott,
I haven't followed this entire thread so I apologize if this has been covered
but how did you build the standby copy? Did you do a duplicate or what?
If you did a duplicate you need to make sure it did a SET NEWNAME for the
datafiles (as it sounds like that step did not happen). Also on a duplicate
you can run the duplicate where the duplicate is automatically configured as a
standby.
http://docs.oracle.com/cd/B28359_01/server.111/b28294/rcmbackp.htm#SBYDB01500
Also, if I'm not mistaken you could mount your instance and rename the
datafiles as necessary to get it to open as a standby?
(Of course if this is Active Dataguard we're talking about, then maybe none of
this applies as I haven't set one of those up yet).
Chris
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Scott Canaan
Sent: Monday, June 03, 2013 2:51 PM
To: Radoulov, Dimitre
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Data Guard Follow-up
It's still trying to open the primary data files. Here are the
initLNX8TEST.ora entries:
log_file_name_convert='/oracle/data/LNX8TEST/','/oracle/data/LNX9TEST/','/oracle/data/LNX8TEST/mirror_files/','/oracle/data/LNX9TEST/mirror_files/'
db_file_name_convert='/oracle/data/LNX8TEST/','/oracle/data/LNX9TEST/'
Here are the initLNX9TEST.ora entries:
log_file_name_convert='/oracle/data/LNX9TEST/','/oracle/data/LNX8TEST/','/oracle/data/LNX9TEST/mirror_files/','/oracle/data/LNX8TEST/mirror_files/'
db_file_name_convert='/oracle/data/LNX9TEST/','/oracle/data/LNX8TEST/'
The timestamps for all of the files, except the control files, is not changing
in LNX9TEST.
Scott Canaan '88 (srcdco@xxxxxxx<mailto:Scott.Canaan@xxxxxxx>)
(585) 475-7886 - work (585) 339-8659 - cell
"Life is like a sewer, what you get out of it depends on what you put into it."
- Tom Lehrer.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
