Re: Data Guard Follow-up

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