RE: Data Guard Follow-up
- From: Scott Canaan <srcdco@xxxxxxx>
- To: "Christopher.Taylor2@xxxxxxxxxxxx" <Christopher.Taylor2@xxxxxxxxxxxx>, "cichomitiko@xxxxxxxxx" <cichomitiko@xxxxxxxxx>
- Date: Mon, 03 Jun 2013 16:34:11 -0400
All I did was to shutdown the primary and physically copy the files from there
to the standby. Since all of the directions that I've found and been given use
some kind of magic to do this step (typically rman), I assume that's all that's
happening. If there's something else going on, I don't know what it is.
The only reason that I can think of to explain why the standby database keeps
trying to use the primary database's physical files is because the controlfile
is a copy of the primary's and is pointing to those files. Is there something
that needs to be done to tell the controlfile that the files are in a different
location (other than what's posted below as that isn't doing anything)?
Scott Canaan '88 (srcdco@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.
-----Original Message-----
From: Christopher.Taylor2@xxxxxxxxxxxx
[mailto:Christopher.Taylor2@xxxxxxxxxxxx]
Sent: Monday, June 03, 2013 4:30 PM
To: Scott Canaan; cichomitiko@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: Data Guard Follow-up
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:
