How to change the location of a standby datafile.

Read our docs This article describes how to change the location of some Standby database datafiles.

Problem Details

Problem Statement

How to change the location of some Standby database datafiles

Applicable Error Code

N/A

Affected Versions

Standby v9

Affected Platforms

All

Note:

The following is set to change the location of standby datafile.
db_file_name_convert = C:\oradata, C:\data, c:\oradata1, c:\data, c:\oradata2, c:\data

However, it is created as follows during CSD.

 C:\DATA1\DEV\SYSTEM01.DBF
 C:\DATA2\DEV\USERS01.DBF

The convert parameters you sent are incorrectly set and work as intended.

db_file_name_convert = C:\oradata, C:\data, c:\oradata1, c:\data, c:\oradata2, c:\data

The first parameter is a substring of the next 2 pairs.

So all filenames like C:\oradataXXX are handled by the first convert pair: C:\oradata, C:\data
So the result is then C:\dataXXX

Set the db_file_name_convert parameter following – see the slash at the end.

db_file_name_convert = C:\oradata\, C:\data\, c:\oradata1\, c:\data\, c:\oradata2\, c:\data\

This will result in :

 C:\DATA\DEV\SYSTEM01.DBF
 C:\DATA\DEV\USERS01.DBF

We're here to help!

Comments