DB_FILE_NAME_CONVERT datafiles from 1 path on primary to multiple paths on standby


Can I use DB_FILE_NAME_CONVERT to convert from 1 primary path to multiple paths on the standby?  If yes please provide the syntax.  is this valid:

db_file_name_convert=/oracle/oradata/ to /dup/oracle/oradata/ and /dup1/oracle/oradata

Who is Participating?
MikeOM_DBAConnect With a Mentor Commented:

You would need to list ALL the files separately like this:


Open in new window

issa7860Author Commented:
just to clarify the question.  I want to convert the datafiles from 1 location to multiple locations on the standby since the space is limited on 1 location.
issa7860Author Commented:
Any one there to answer this question?
Richard OlutolaConnect With a Mentor ConsultantCommented:
The short answer to your question is NO.

You can convert multiple locations to multiple locations or multiple locations to single location.

To convert multiple locations to multiple locations, you need to pair the source and target locations in a list:
db_file_name_convert=(/oracle/oradata/orcl/,/dup/oracle/oradata/orcl/,/oracle/oradata/orcl2/,/dup/oracle/oradata/orcl2/... You get the idea.
Alternatively, you'll need to specify file by file like MikeOM_DBA suggests above.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.