Oracle9i Database Reference
Release 1 (9.0.1)

Part Number A90190-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Initialization Parameters, 98 of 220


LOG_FILE_NAME_CONVERT

Parameter type 

String 

Syntax 
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

    string3 is the pattern of the primary database filename

    string4 is the pattern of the standby database filename

You can use as many pairs of primary and standby replacement strings as required. You can use single or double quotation marks. The parentheses are optional.

Following are example settings that are acceptable:

LOG_FILE_NAME_CONVERT=('/dbs/t1/','/dbs/t1/s_
','dbs/t2/ ','dbs/t2/s_')
 
Default value 

None 

Parameter class 

Static 

Range of values 

Character strings 

LOG_FILE_NAME_CONVERT converts the filename of a new log file on the primary database to the filename of a log file on the standby database. If you add a log file to the primary database, you must add a corresponding file to the standby database.

If you specify an odd number of strings (the last string has no corresponding replacement string), an error is signalled during startup. If the filename being converted matches more than one pattern in the pattern/replace string list, the first matched pattern takes effect. There is no limit on the number of pairs that you can specify in this parameter (other than the hard limit of the maximum length of multivalue parameters).

When the standby database is updated, this parameter converts the log file name on the primary database to the log file name on the standby database. The file must exist on the standby database and must be writable or the recovery process will halt with an error.

The first string is the pattern found in the log file names on the primary database. The second string is the pattern found in the log file names on the standby database.

You should also use LOG_FILE_NAME_CONVERT to rename the logfiles in the clone controlfile when setting up the clone database during tablespace point-in-time recovery.

See Also:

Oracle9i User-Managed Backup and Recovery Guide and Oracle9i Data Guard Concepts and Administration 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback