RE: Data Guard Follow-up

From: Gerald Cunningham <gcunningham_at_proteuseng.com>
Date: Tue, 4 Jun 2013 10:36:22 -0400
Message-ID: <68F9DD51BF61E943BFA45D744048A7A73108D0D6E5_at_nbp-ex01.proteus-technologies.com>

It looks like the convert entries are backwards.

---

From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On Behalf Of Scott Canaan [srcdco_at_rit.edu] Sent: Monday, June 03, 2013 3:50 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.

From: Radoulov, Dimitre [mailto:cichomitiko_at_gmail.com] Sent: Monday, June 03, 2013 3:03 PM
To: Scott Canaan
Cc: oracle-l_at_freelists.org
Subject: Re: Data Guard Follow-up

Hi Scott,

On 03/06/2013 19:44, Scott Canaan wrote:

I started with nothing and created the primary database from scratch - LNX8TEST. By default, it is not in archivelog mode and does not have a password file.

[...]

log_file_name_convert='/oracle/data/LNX8TEST/','/oracle/data/LNX8TEST/','/oracle/data/LNX8TEST/mirror_files/','/oracle/data/LNX8TEST/mirror_files/'

I would start by adjusting the *name_convert_* parameters.

LOG_FILE_NAME_CONVERT = 'string1' , 'string2' , 'string3' , 'string4' , ...

Where:

• string1 is the pattern of the primary database filename
• string2 is the pattern of the standby database filename

Unless I'm missing something, it should be:

primary (s)pfile:

log_file_name_convert='/LNX9TEST/', '/LNX8TEST/' standby:

log_file_name_convert='/LNX8TEST/', '/LNX9TEST/'

And you need the same values for db_file_name_convert.

Regards
Dimitre

--
http://www.freelists.org/webpage/oracle-l--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jun 04 2013 - 16:36:22 CEST