RE: Data Guard Follow-up

From: Scott Canaan <srcdco_at_rit.edu>
Date: Mon, 03 Jun 2013 16:34:11 -0400
Message-id: <A9F069F06B325049A1D90D1F8EBEB8B6EEF6A1463E_at_ex02mail02.ad.rit.edu>



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_at_rit.edu)
(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_at_parallon.net [mailto:Christopher.Taylor2_at_parallon.net] Sent: Monday, June 03, 2013 4:30 PM
To: Scott Canaan; cichomitiko_at_gmail.com Cc: oracle-l_at_freelists.org
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Scott Canaan Sent: Monday, June 03, 2013 2:51 PM
To: Radoulov, Dimitre
Cc: oracle-l_at_freelists.org
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_at_rit.edu<mailto:Scott.Canaan_at_rit.edu>)
(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.

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Jun 03 2013 - 22:34:11 CEST

Original text of this message