Run the following commands on PROD database host to get configuration information for the oraprd12 database.
[grid@sn1-r720-e03-03 ~]$ srvctl config asm
ASM home: <CRS home>
Password file: +DATA/orapwasm
Backup of Password file:
ASM listener: LISTENER
Spfile: +DATA/ASM/ASMPARAMETERFILE/registry.253.1032470389
ASM diskgroup discovery string: /dev/mapper/*,AFD:*
[oracle@sn1-r720-e03-03 ~]$ srvctl config database -db oraprd12
Database unique name: oraprd12
Database name: oraprd12
Oracle home: /u01/app/oracle/product/19.0.0/dbhome_1
Oracle user: oracle
Spfile: +ORAPRD12_DATA/ORAPRD12/PARAMETERFILE/spfile.265.1042658127
Password file:
Domain: puretec.purestorage.com
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Disk Groups: ORAPRD12_DATA,ORAPRD12_FRA
Services:
OSDBA group:
OSOPER group:
Database instance: oraprd12
As the PROD and DR volumes are copies, we use the spfile name and path from the above listing to register the oraprd12 database on the DR site.
[oracle@sn1-r720-e03-05 ~]$ srvctl add database -db oraprd12 -oraclehome /u01/app/oracle/product/19.0.0/dbhome_1 \
-spfile +ORAPRD12_DATA/ORAPRD12/PARAMETERFILE/spfile.265.1042658127
Create audit directories for oraprd12 if they do not exist.
[oracle@sn1-r720-e03-05 ~]$ mkdir $ORACLE_BASE/audit/oraprd12
[oracle@sn1-r720-e03-05 ~]$ mkdir $ORACLE_BASE/admin/oraprd12/adump