NMDA Oracle: How to Configure Auxiliary Database for Oracle Cross System Restore using NMC Wizard

Summary: To create an auxiliary instance for Oracle Cross System restore using NMC Wizard, follow the instructions listed in this article.

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Instructions

oraprd = Source (ORCL1)
oratst = Destination (ORCL1AUX)

Step 1: Connect to Source DB

[oracle@oraprd ~]$ export ORACLE_SID=ORCL1
[oracle@oraprd ~]$ sqlplus / as sysdba

Step 2: Find the Server Parameter File name

SQL> show parameter spfile

Step 3: Create the Parameter File for Auxiliary Oracle Instance

SQL> create pfile='/u01/app/oracle/product/19.3.0/dbhome_1/dbs/initORCL1AUX.ora' from spfile;

Step 4: Replace Source Instance Name(ORCL1) with Auxiliary Instance Name(ORCL1AUX) in initORCL1AUX.ora

PWD = /u01/app/oracle/product/19.3.0/dbhome_1/dbs
[oracle@oraprd dbs]$ cat initORCL1AUX.ora

Step 5: Copy the initORCL1AUX.ora to the Remote Destination host

[oracle@oraprd dbs]$ scp initORCL1AUX.ora oracle@oratst:/u01/app/oracle/product/19.3.0/dbhome_1/dbs/

Step 6: On the Remote Destination node, create all the folder structure as per initORCL1AUX.ora file

[oracle@oratst dbs]$ mkdir -p /u01/app/oracle/admin/ORCL1AUX/adump /u02/oradata/ORCL1AUX/ /u01/app/oracle/recovery_area/ORCL1AUX/ /u01/app/oracle/recovery_area

Step 7: Create Oracle Password file

[oracle@oratst dbs]$ orapwd file=orapwORCL1AUX password=oracle entries=5 format=12

Step 8: Add Auxiliary SID (ORCL1AUX) in listener.ora file

[oracle@oratst admin]$ cat listener.ora

Step 9: Add Auxiliary SID (ORCL1AUX) and Source SID (ORCL1) in tnsnames.ora on both Source and Destination nodes

[oracle@oratst admin]$ cat tnsnames.ora

Step 10: Restart Listner on both the nodes

[oracle@oratst dbs] lsnrctl reload
[oracle@oraprd dbs] lsnrctl reload

Step 11: Export the new ORACLE_SID

[oracle@oratst dbs]$ export ORACLE_SID=ORCL1AUX

Step 12: Connect to Auxiliary Instance

[oracle@oratst dbs]$ sqlplus / as sysdba

Step 13: Startup DB in NOMOUNT mode using PFILE

SQL> startup nomount pfile=/u01/app/oracle/product/19.3.0/dbhome_1/dbs/initORCL1AUX.ora

Step 14: Startup DB in NOMOUNT mode using SPFILE

SQL> create spfile from pfile='/u01/app/oracle/product/19.3.0/dbhome_1/dbs/initORCL1AUX.ora';
SQL> startup force nomount;

Step 15: Connect RMAN from both the nodes to verify if connections are working properly

[oracle@oratst dbs] rman target sys/oracle@ORCL1 auxiliary sys/oracle@ORCL1AUX
[oracle@oraprd dbs] rman target sys/oracle@ORCL1 auxiliary sys/oracle@ORCL1AUX

Affected Products

NetWorker Module for Databases and Applications
Article Properties
Article Number: 000261454
Article Type: How To
Last Modified: 19 Dec 2024
Version:  2
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.