Data Guard Question
Date: Wed, 28 Jul 2021 15:44:58 +0000
Message-ID: <04d91db9a6f54436bc6d47e829888270_at_ex04test91a.ad.rit.edu>
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_at_rit.edu<mailto:srcdco_at_rit.edu> | 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.
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 28 2021 - 17:44:58 CEST