Re: Data Guard Follow-up

From: Marcin Przepiorowski <pioro1_at_gmail.com>
Date: Tue, 4 Jun 2013 15:42:32 +0100
Message-ID: <CAGdek=x-vfd6OZadN=4cOAo12OYnxuvxXip42WLAhMBcsGu7ZQ_at_mail.gmail.com>

Yep - db_file_name_convert and log_file_name_convert are wrong general format is xxxx_file_name_convert = 'source_path','target path'

where source path is a string you want to convert from and target path is a string you want to convert into.

in your case

db_file_name_convert = 'LNX8TEST','LNX9TEST'

should do a trick.

It will change directory from primary to standby files

regards,
Marcin

On Tue, Jun 4, 2013 at 3:36 PM, Gerald Cunningham < gcunningham_at_proteuseng.com> wrote:

> 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
>
>
>

-- 
Marcin Przepiorowski
http://oracleprof.blogspot.com


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

Received on Tue Jun 04 2013 - 16:42:32 CEST