Implementing Data Guard - Expert Consolidation in Oracle Database 12c - page 338

The diagnostic destination introduced with Oracle 11g is a great help in simplifying the creation of auxiliary
directories. The only remaining directory required for Oracle is the audit_file_dest . This can be created in a
small script:
[oracle@server2 dbs]$ ADUMP=`grep audit_file_dest init${ORACLE_SID}.ora \
> | cut -d= -f2 | tr -d "'"` ; mkdir -p $ADUMP
This example assumes that the directory structure is the same on the standby host with the exception of the
top-level directory containing the database files. This directory is CDBFSDCB instead of CDBFSDCA. The directory
structure to be put into place on the standby host to support the duplicate database command can easily be scripted
on the primary database:
SQL> select distinct 'mkdir -p ' ||
2 replace(substr(name,1,instr(name,'/',-1)),'DCA','DCB') cmd
3 from v$datafile;
CMD
--------------------------------------------------------------------------------
mkdir -p /u01/oradata/CDBFSDCB/PDB1/
mkdir -p /u01/oradata/CDBFSDCB/pdbseed/
mkdir -p /u01/oradata/CDBFSDCB/
You can “union all” additional locations such as log file members, temp files, and so on should they not all be in
the CDBFSDCA mount point. These commands are then to be executed on the standby host. If you are multiplexing
the control files in the Fast Recovery Area (FRA) then the full path needs to be created too. The resulting initialization
file for the standby database with the unique name “CDBFSDCB” is shown here:
*.audit_file_dest='/u01/app/oracle/admin/CDBFSDCB/adump'
*.audit_trail='db'
*.compatible='12.1.0.0.0'
*.control_files='/u01/oradata/CDBFSDCB/control01.ctl',
'/u01/fast_recovery_area/CDBFSDCB/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='CDBFS'
*.db_unique_name='CDBFSDCB'
*.db_recovery_file_dest='/u01/fast_recovery_area'
*.db_recovery_file_dest_size=4800m
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=CDBFSDCBXDB)'
*.enable_pluggable_database=true
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=300
*.pga_aggregate_target=512m
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=1024m
*.undo_tablespace='UNDOTBS1'
*.db_file_name_convert='/u01/oradata/CDBFSDCA','/u01/oradata/CDBFSDCB'
*.log_file_name_convert='/u01/oradata/CDBFSDCA','/u01/oradata/CDBFSDCB'