Those are already set. They don't seem to help when creating a data file.
Scott Canaan '88
Sr Database Administrator
Information & Technology Services
Finance & Administration
Rochester Institute of Technology
o: (585) 475-7886 | f: (585) 475-7520
srcdco@xxxxxxx<mailto:srcdco@xxxxxxx> | c: (585) 339-8659
CONFIDENTIALITY NOTE: The information transmitted, including attachments, is
intended only for the person(s) or entity to which it is addressed and may
contain confidential and/or privileged material. Any review, retransmission,
dissemination or other use of, or taking of any action in reliance upon this
information by persons or entities other than the intended recipient is
prohibited. If you received this in error, please contact the sender and
destroy any copies of this information.
From: Sweetser, Joe <JSweetser@xxxxxxxx>
Sent: Wednesday, July 28, 2021 11:50 AM
To: Scott Canaan <srcdco@xxxxxxx>; 'oracle-l@xxxxxxxxxxxxx'
<oracle-l@xxxxxxxxxxxxx>
Subject: RE: Data Guard Question
Perhaps look at db_file_name_convert and/or log_file_name_convert?
I have used those to handle filename/creation 'issues'.
Hth,
-joe
From: oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
<oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>> On Behalf
Of Scott Canaan
Sent: Wednesday, July 28, 2021 9:45 AM
To: 'oracle-l@xxxxxxxxxxxxx'
<oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>>
Subject: Data Guard Question
We've set up data guard with a primary and a secondary. The primary is
DGRDTSTD. The secondary is DGRDTSTC. We are running Oracle 19c on Linux Red
Hat 7.
If I create a new data file on the primary, it creates it on the secondary, but
in the wrong directory. It creates a new directory, called DGRDTSTD and puts
the new file there, instead of putting it in the DGRDTSTC directory. I can
move it and rename it, but I shouldn't have to.
I tried to set the db_create_file_dest parameter on both databases:
on the standby:
alter system set db_create_file_dest='/oracle/data/DGRDTSTC';
on the primary:
alter system set db_create_file_dest='/oracle/data/DGRDTSTD';
All that did was to create the new file as:
/oracle/data/DGRDTSTC/DGRDTSTC/datafile/o1_mf_test_dat_jj2xgght_.dbf
The original file name was test_data_enc03.dbf. I don't know why it changed it.
What do I have to do to get the secondary to create the new data file in the
correct directory (/oracle/data/DGRDTSTC) and do it right?
Thank you,
Scott Canaan '88
Sr Database Administrator
Information & Technology Services
Finance & Administration
Rochester Institute of Technology
o: (585) 475-7886 | f: (585) 475-7520
srcdco@xxxxxxx<mailto:srcdco@xxxxxxx> | c: (585) 339-8659
CONFIDENTIALITY NOTE: The information transmitted, including attachments, is
intended only for the person(s) or entity to which it is addressed and may
contain confidential and/or privileged material. Any review, retransmission,
dissemination or other use of, or taking of any action in reliance upon this
information by persons or entities other than the intended recipient is
prohibited. If you received this in error, please contact the sender and
destroy any copies of this information.
This e-mail transmission and any attachments that accompany it may contain
information that is privileged, confidential or otherwise exempt from
disclosure under applicable law and is intended solely for the use of the
individual's to whom it was intended to be addressed. If you have received this
e-mail by mistake, or you are not the intended recipient, any disclosure,
dissemination, distribution, copying or other use or retention of this
communication or its substance is prohibited. If you have received this
communication in error, please immediately reply to the author via e-mail that
you received this message by mistake and also permanently delete the original
and all copies of this e-mail and any attachments from your computer. Please
note that coverage cannot be bound or altered by sending an email. You must
receive written confirmation from a representative of our firm to put coverage
in force or make changes to an existing policy.
