NMDA-Oracle: Sådan konfigureres hjælpedatabase til Oracle Cross System Restore ved hjælp af NMC Wizard

Summary: Hvis du vil oprette en ekstra forekomst til Oracle Cross System-gendannelse ved hjælp af NMC Wizard, skal du følge instruktionerne i denne artikel.

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 = Kilde (ORCL1)
oratst = Destination (ORCL1AUX)

Trin 1: Opret forbindelse til kilde-DB

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

Trin 2: Find navnet på serverparameteren

SQL> show parameter spfile

Trin 3: Opret parameterfilen til Auxiliary Oracle Instance

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

Trin 4: Erstat Source Instance Name (ORCL1) med Auxiliary Instance Name (ORCL1AUX) i initORCL1AUX.ora

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

Trin 5: Kopiér initORCL1AUX.ora til værten for fjerndestinationen

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

Trin 6: På noden Fjerndestination skal du oprette hele mappestrukturen i henhold til filen initORCL1AUX.ora

[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

Trin 7: Opret Oracle Password-fil

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

Trin 8: Tilføj ekstra SID (ORCL1AUX) i filen listener.ora

[oracle@oratst admin]$ cat listener.ora

Trin 9: Tilføj hjælpe-SID (ORCL1AUX) og kilde-SID (ORCL1) i tnsnames.ora på både kilde- og destinationsnoder

[oracle@oratst admin]$ cat tnsnames.ora

Trin 10: Genstart Listner på begge noder

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

Trin 11: Eksportér den nye ORACLE_SID

[oracle@oratst dbs]$ export ORACLE_SID=ORCL1AUX

Trin 12: Opret forbindelse til ekstra forekomst

[oracle@oratst dbs]$ sqlplus / as sysdba

Trin 13: Start DB i NOMOUNT-tilstand ved hjælp af PFILE

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

Trin 14: Start DB i NOMOUNT-tilstand ved hjælp af SPFILE

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

Trin 15: Tilslut RMAN fra begge noder for at kontrollere, om forbindelserne fungerer korrekt

[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.