RE: Data Guard Follow-up

From: <Christopher.Taylor2_at_parallon.net>
Date: Mon, 3 Jun 2013 15:29:48 -0500
Message-ID: <F05D8DF1FB25F44085DB74CB916678E887A045C77A_at_NADCWPMSGCMS10.hca.corpad.net>



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:29:48 CEST

Original text of this message