RE: Data Guard Follow-up
- From: Scott Canaan <srcdco@xxxxxxx>
- To: "Radoulov, Dimitre" <cichomitiko@xxxxxxxxx>
- Date: Mon, 03 Jun 2013 15:50:32 -0400
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.
From: Radoulov, Dimitre [mailto:cichomitiko@xxxxxxxxx]
Sent: Monday, June 03, 2013 3:03 PM
To: Scott Canaan
Cc: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
