DB Version 19.11
OS : RHEL 7.9
I am an intermediate user when it comes to Data guard.
I have a 19c DB which has Active data guard configured.
In the primary, I created pluggable database named PDB_UMS (cloned via DB Link) as shown below.
Output from Primary below:
SQL> create pluggable database PDB_UMS from PDB_UMS@DB_LINK_FOR_CLONE;
Pluggable database created.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
7 PDB_UMS MOUNTED
10 PDB_SALES READ WRITE NO
<snipped output>
SQL>
SQL> alter pluggable database PDB_UMS open;
Pluggable database altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
7 PDB_UMS READ WRITE NO
10 PDB_SALES READ WRITE NO
<snipped output>
SQL> select file_name from cdb_Data_Files where con_id = 7;
FILE_NAME
---------------------------------------------------------------------------------------------------
+DATA_DG/CDB_58E/F31DC8DAB92397B4E05308100B0AA3E2/DATAFILE/system.477.1127082295
+DATA_DG/CDB_58E/F31DC8DAB92397B4E05308100B0AA3E2/DATAFILE/sysaux.416.1127082295
+DATA_DG/CDB_58E/F31DC8DAB92397B4E05308100B0AA3E2/DATAFILE/undotbs1.304.1127082295
+DATA_DG/CDB_58E/F31DC8DAB92397B4E05308100B0AA3E2/DATAFILE/users.394.1127082295
+DATA_DG/CDB_58E/F31DC8DAB92397B4E05308100B0AA3E2/DATAFILE/goldengate_data_ls.390.1127082295
+DATA_DG/CDB_58E/F31DC8DAB92397B4E05308100B0AA3E2/DATAFILE/etl_jcm_data_ls.388.1127082295
+DATA_DG/CDB_58E/F31DC8DAB92397B4E05308100B0AA3E2/DATAFILE/etl_jcm_index_ls.387.1127082295
+DATA_DG/CDB_58E/F31DC8DAB92397B4E05308100B0AA3E2/DATAFILE/undotbs2.303.1127082295
+DATA_DG/CDB_58E/F31DC8DAB92397B4E05308100B0AA3E2/DATAFILE/pacs_data_ls.305.1127082295
+DATA_DG/CDB_58E/F31DC8DAB92397B4E05308100B0AA3E2/DATAFILE/pacs_data_ls.307.1127082295
+DATA_DG/CDB_58E/F31DC8DAB92397B4E05308100B0AA3E2/DATAFILE/pacs_data_ls.309.1127082295
+DATA_DG/CDB_58E/F31DC8DAB92397B4E05308100B0AA3E2/DATAFILE/ifgpreprod_data_ls.310.1127082295
+DATA_DG/CDB_58E/F31DC8DAB92397B4E05308100B0AA3E2/DATAFILE/pacs_index_ls.311.1127082295
+DATA_DG/CDB_58E/F31DC8DAB92397B4E05308100B0AA3E2/DATAFILE/tools.312.1127082295
+DATA_DG/CDB_58E/F31DC8DAB92397B4E05308100B0AA3E2/DATAFILE/goldeng_data_ls.319.1127082295
+DATA_DG/CDB_58E/F31DC8DAB92397B4E05308100B0AA3E2/DATAFILE/fxdb_data_ls.391.1127082295
+DATA_DG/CDB_58E/F31DC8DAB92397B4E05308100B0AA3E2/DATAFILE/xdb.306.1127082295
17 rows selected.
SQL> show parameter STANDBY_FILE_MANAGEMENT
PARAMETER_NAME TYPE VALUE
------------------------------------------------------------ ----------- -------------------------
standby_file_management string AUTO
But, in standby, I get the following error when I try to open this PDB in read-only mode.
I can see that none of datafiles for the newly created PDB_UMS got replicated in standby.
STANDBY_FILE_MANAGEMENT parameter is set to AUTO in both primary and standby.
Any idea what is causing this and how I can fix this ?
Another quick question: If I want all datafiles that is created in primary to get replicated in standby, should i set STANDBY_FILE_MANAGEMENT parameter to AUTO just in primary or both in primary and standby ?
Output from Standby below:
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
7 PDB_UMS MOUNTED
10 PDB_SALES READ ONLY NO
<snipped output>
SQL> select name, value from v$dataguard_Stats;
NAME VALUE
-------------------------------- ----------------------------------------------------------------
transport lag +00 00:00:00
apply lag +00 00:00:00
apply finish time +00 00:00:00.000
estimated startup time 20
SQL> alter pluggable database PDB_UMS open read only;
alter pluggable database PDB_UMS open read only
*
ERROR at line 1:
ORA-01111: name for data file 373 is unknown - rename to correct file
SQL> select file_name from cdb_Data_Files where con_id = 7;
no rows selected
SQL> select * from v$recover_file where error like '%FILE%';
FILE# ONLINE ONLINE_ ERROR CHANGE# TIME CON_ID
---------- ------- ------- ----------------------------------------------------------------- ---------- ----------------- ----------
373 OFFLINE OFFLINE FILE MISSING 0 7
374 OFFLINE OFFLINE FILE MISSING 0 7
375 OFFLINE OFFLINE FILE MISSING 0 7
376 OFFLINE OFFLINE FILE MISSING 0 7
377 OFFLINE OFFLINE FILE MISSING 0 7
378 OFFLINE OFFLINE FILE MISSING 0 7
379 OFFLINE OFFLINE FILE MISSING 0 7
380 OFFLINE OFFLINE FILE MISSING 0 7
381 OFFLINE OFFLINE FILE MISSING 0 7
382 OFFLINE OFFLINE FILE MISSING 0 7
383 OFFLINE OFFLINE FILE MISSING 0 7
384 OFFLINE OFFLINE FILE MISSING 0 7
385 OFFLINE OFFLINE FILE MISSING 0 7
386 OFFLINE OFFLINE FILE MISSING 0 7
387 OFFLINE OFFLINE FILE MISSING 0 7
388 OFFLINE OFFLINE FILE MISSING 0 7
389 OFFLINE OFFLINE FILE MISSING 0 7
17 rows selected.
SQL>
Another observation:
In standby side, the file names are listed in v$datafile view as shown below. But, these files are physically not present in /u01/app/oracle/product/19.11.0.0/dbhome_1/dbs directory though.
-- Output from standby
SQL> select file#,name from v$datafile where con_id = 7;
FILE# NAME
---------- ---------------------------------------------------------------------------
373 /u01/app/oracle/product/19.11.0.0/dbhome_1/dbs/UNNAMED00373
374 /u01/app/oracle/product/19.11.0.0/dbhome_1/dbs/UNNAMED00374
375 /u01/app/oracle/product/19.11.0.0/dbhome_1/dbs/UNNAMED00375
376 /u01/app/oracle/product/19.11.0.0/dbhome_1/dbs/UNNAMED00376
377 /u01/app/oracle/product/19.11.0.0/dbhome_1/dbs/UNNAMED00377
378 /u01/app/oracle/product/19.11.0.0/dbhome_1/dbs/UNNAMED00378
379 /u01/app/oracle/product/19.11.0.0/dbhome_1/dbs/UNNAMED00379
380 /u01/app/oracle/product/19.11.0.0/dbhome_1/dbs/UNNAMED00380
381 /u01/app/oracle/product/19.11.0.0/dbhome_1/dbs/UNNAMED00381
382 /u01/app/oracle/product/19.11.0.0/dbhome_1/dbs/UNNAMED00382
383 /u01/app/oracle/product/19.11.0.0/dbhome_1/dbs/UNNAMED00383
384 /u01/app/oracle/product/19.11.0.0/dbhome_1/dbs/UNNAMED00384
385 /u01/app/oracle/product/19.11.0.0/dbhome_1/dbs/UNNAMED00385
386 /u01/app/oracle/product/19.11.0.0/dbhome_1/dbs/UNNAMED00386
387 /u01/app/oracle/product/19.11.0.0/dbhome_1/dbs/UNNAMED00387
388 /u01/app/oracle/product/19.11.0.0/dbhome_1/dbs/UNNAMED00388
389 /u01/app/oracle/product/19.11.0.0/dbhome_1/dbs/UNNAMED00389
17 rows selected.
PS, I didn't find the Data guard community forum. Hence posted it here in the General discussions one.