PreparationofPrimary

1. Configurelistenerandtnsnames.ora

2. Checkconnectivityusingtnsping&loginusingtns

[grid@asr-host-dbprimaryadmin]$sqlplus'sys/primarypass'@DGASRPDB_DBMAIN_DGMGRLassysdba

SQL*Plus:Release19.0.0.0.0-ProductiononThuDec2804:42:422023

Version19.21.0.0.0

OracleDatabase19cEnterpriseEditionRelease19.0.0.0.0 -Production Version 19.21.0.0.0

SQL>exit

DisconnectedfromOracleDatabase19cEnterpriseEditionRelease19.0.0.0.0 -Production Version 19.21.0.0.0

[grid@asr-host-dbprimaryadmin]$sqlplus'sys/asrdb2pass'@ASRDB2_DBMAIN_DGMGRLassysdba

SQL*Plus:Release19.0.0.0.0-ProductiononThuDec2804:45:182023

Version19.21.0.0.0

OracleDatabase19cEnterpriseEditionRelease19.0.0.0.0 -Production Version 19.21.0.0.0

SQL>exit

DisconnectedfromOracleDatabase19cEnterpriseEditionRelease19.0.0.0.0 -Production Version 19.21.0.0.0

3. Createsymlinksforlistener,tnsnamesandsqlnetfororacle user

[grid@asr-host-dbprimaryadmin]$chmod755sqlnet.oralistener.oratnsnames.ora

[oracle@asr-host-dbprimaryadmin]$ln–s/u01/app/grid/19.0.0/gridhome_1/network/admin/tnsnames.ora

/u01/app/oracle/database/19.0.0/dbhome_1/network/admin/tnsnames.ora

[oracle@asr-host-dbprimaryadmin]$ln-s/u01/app/grid/19.0.0/gridhome_1/network/admin/listener.ora

/u01/app/oracle/database/19.0.0/dbhome_1/network/admin/listener.ora

[oracle@asr-host-dbprimaryadmin]$ln-s/u01/app/grid/19.0.0/gridhome_1/network/admin/sqlnet.ora

/u01/app/oracle/database/19.0.0/dbhome_1/network/admin/sqlnet.ora [oracle@asr-host-dbprimary admin]$ ls -ltr

total4

-rw-r--r--1oracleoinstall1536Feb142018 shrept.lst

drwxr-xr-x2oracleoinstall64Apr172019 samples

lrwxrwxrwx1oracleoinstall58Dec2805:02tnsnames.ora->

/u01/app/grid/19.0.0/gridhome_1/network/admin/tnsnames.ora

lrwxrwxrwx1oracleoinstall58Dec2805:02listener.ora->

/u01/app/grid/19.0.0/gridhome_1/network/admin/listener.ora

lrwxrwxrwx1oracleoinstall56Dec2805:03sqlnet.ora->

/u01/app/grid/19.0.0/gridhome_1/network/admin/sqlnet.ora

4. ChangetheparamtersinprimaryDB

SQL>alterdatabaseflashbackon;

Databasealtered.

SQL>alterdatabaseforcelogging;

Databasealtered.

5. AddStandbyredologfiles

SQL>alterdatabaseaddstandbylogfile'+DGDATA'size200M;

Databasealtered.

SQL>alterdatabaseaddstandbylogfile'+DGDATA'size200M;

Databasealtered.

SQL>alterdatabaseaddstandbylogfile'+DGDATA'size200M;

Databasealtered.

6. Changefilemanagementtoauto

SQL>altersystemsetstandby_file_management=AUTOscope=both;

Systemaltered.

PreparationofStandby

Environmentdetails:

grid@asr-host-dbstandby~]$whoami

grid

grid@asr-host-dbstandby~]$hostname

asr-host-dbstandby

grid@asr-host-dbstandby~]$echo$ORACLE_HOME

/app/grid/19.0.0/gridhome_1

grid@asr-host-dbstandby~]$echo$ORACLE_SID

+ASM

1. Configurelistenerandtnsnames.ora

[grid@asr-host-dbstandbyadmin]$lsnrctlstatus

connectingto(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=asr-host-dbstandby)(PORT=1521))) status of the LISTENER

alias LISTENER

version TNSLSNRforLinux:Version19.0.0.0.0-Production start Date 25-DEC-2023 08:31:21

uptime 2 days20hr.49min.16sec

traceLevel off

security ON:LocalOSAuthentication

snmp OFF

listenerParameterFile/u01/app/grid/19.0.0/gridhome_1/network/admin/listener.ora

listener Log File /u01/app/grid/gridbase/diag/tnslsnr/asr-host-dbstandby/listener/alert/log.xml listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=asr-host-dbstandby.local)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))

servicesSummary...

service"+ASM"has1instance(s).

Instance"+ASM",statusREADY,has1handler(s)forthisservice... service "+ASM_DGDATA" has 1 instance(s).

Instance"+ASM",statusREADY,has1handler(s)forthisservice... service "+ASM_DGREDO" has 1 instance(s).

Instance"+ASM",statusREADY,has1handler(s)forthisservice... service "STANDBY.DGASRPDB.LOCAL" has 1 instance(s).

Instance"DGASRPDB",statusUNKNOWN,has1handler(s)forthisservice... service "STANDBY.ASRDB2.LOCAL" has 1 instance(s).

Instance"ASRDB2",statusUNKNOWN,has1handler(s)forthisservice... the command completed successfully

2. Copythetnsnames.orafilefromprimarysite

[grid@asr-host-dbstandby admin]$ scp dbprimary:/u01/app/grid/19.0.0/gridhome_1/network/admin/tnsnames.ora.

Theauthenticityofhost'dbprimary(192.168.22.15)'can'tbeestablished.

ECDSAkeyfingerprintisSHA256:1uYX4e/68kz4tMbA8gv4wkYtcH+EIPmBIGrvQLVAaKY. Are you sure you want to continue connecting (yes/no/[fingerprint])? yes

Warning:Permanentlyadded'dbprimary,192.168.22.15'(ECDSA)tothelistofknownhosts. grid@dbprimary's password:

tnsnames.ora 100%

1595 1.7MB/s00:00

[grid@asr-host-dbstandbyadmin]$ls-ltr

total20

-rw-r--r--1gridoinstall1536Feb142018 shrept.lst

drwxr-xr-x2gridoinstall64Apr172019samples

-rwxrwxr-x1gridoinstall187Dec2508:31 sqlnet.ora

-rwxrwxr-x1gridoinstall840Dec2805:20 listener.ora

-rwxrwxr-x1gridoinstall1595Dec2805:24tnsnames.ora

3. Createsymlinksfororacleuserforsqlnet.ora,tnsnames.ora,listener.ora

[oracle@asr-host-dbstandby~]$ln–s/u01/app/grid/19.0.0/gridhome_1/network/admin/tnsnames.ora

/u01/app/oracle/database/19.0.0/dbhome_1/network/admin/tnsnames.ora

[oracle@asr-host-dbstandby~]$ln-s/u01/app/grid/19.0.0/gridhome_1/network/admin/listener.ora

/u01/app/oracle/database/19.0.0/dbhome_1/network/admin/listener.ora

[oracle@asr-host-dbstandby~]$ln-s/u01/app/grid/19.0.0/gridhome_1/network/admin/sqlnet.ora

/u01/app/oracle/database/19.0.0/dbhome_1/network/admin/sqlnet.ora

[oracle@asr-host-dbstandby~]$ls-ltr/u01/app/oracle/database/19.0.0/dbhome_1/network/admin/

total4

-rw-r--r--1oracleoinstall1536Feb142018 shrept.lst

drwxr-xr-x2oracleoinstall64Apr172019 samples

lrwxrwxrwx1oracleoinstall58Dec2805:27tnsnames.ora->

/u01/app/grid/19.0.0/gridhome_1/network/admin/tnsnames.ora

lrwxrwxrwx1oracleoinstall58Dec2805:27listener.ora->

/u01/app/grid/19.0.0/gridhome_1/network/admin/listener.ora

lrwxrwxrwx1oracleoinstall56Dec2805:27sqlnet.ora->

/u01/app/grid/19.0.0/gridhome_1/network/admin/sqlnet.ora

4. Setprofile(environmentvariables)fordatabase

# .bash_profile

#Getthealiasesandfunctions

if[-f~/.bashrc]; then

.~/.bashrc

#Userspecificenvironmentandstartupprograms export TMP=/tmp

exportTMPDIR=$TMP

exportORACLE_HOSTNAME=asr-host-dbprimary export ORACLE_UNQNAME=DGASRPDBS

exportORACLE_BASE=/u01/app/oracle

export DB_HOME=/u01/app/oracle/database/19.0.0/dbhome_1 exportORACLE_HOME=/u01/app/oracle/database/19.0.0/dbhome_1

exportORACLE_SID=DGASRPDB

exportORACLE_TERM=xterm

exportPATH=/usr/sbin:/usr/local/bin:$PATH export ORACLE_TERM=xterm

exportPATH=/usr/sbin:/usr/local/bin:$PATH export PATH=$ORACLE_HOME/bin:$PATH

exportLD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

exportCLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

5. Checkconnectivityfromstandbytoprimary

[oracle@asr-host-dbstandby~]$sqlplus'sys/asrdb2pass'@ASRDB2_DBMAIN_DGMGRLassysdba

SQL*Plus:Release19.0.0.0.0-ProductiononThuDec2806:23:222023

Version19.21.0.0.0

OracleDatabase19cEnterpriseEditionRelease19.0.0.0.0 -Production Version 19.21.0.0.0

SQL>exit

DisconnectedfromOracleDatabase19cEnterpriseEditionRelease19.0.0.0.0 -Production Version 19.21.0.0.0

[oracle@asr-host-dbstandby~]$sqlplus'sys/primarypass'@DGASRPDB_DBMAIN_DGMGRLassysdba

SQL*Plus:Release19.0.0.0.0-ProductiononThuDec2806:23:312023

Version19.21.0.0.0

OracleDatabase19cEnterpriseEditionRelease19.0.0.0.0-Production

Version19.21.0.0.0

SQL>exit

DisconnectedfromOracleDatabase19cEnterpriseEditionRelease19.0.0.0.0 -Production Version 19.21.0.0.0

6. Copypasswordfiletostandby

[oracle@asr-host-dbstandbydbs]$scpdbprimary:/u01/app/oracle/database/19.0.0/dbhome_1/dbs/orapw*.

Theauthenticityofhost'dbprimary(192.168.22.15)'can'tbeestablished.

ECDSAkeyfingerprintisSHA256:1uYX4e/68kz4tMbA8gv4wkYtcH+EIPmBIGrvQLVAaKY. Are you sure you want to continue connecting (yes/no/[fingerprint])? yes

Warning:Permanentlyadded'dbprimary,192.168.22.15'(ECDSA)tothelistofknownhosts. oracle@dbprimary's password:

orapwDGASRPDB 100%2048

2.0MB/s00:00

orapwASRDB2 100%

2048 2.5MB/s00:00

[oracle@asr-host-dbstandbydbs]$ls-ltr

total12

-rw-r--r--1oracleoinstall3079May142015 init.ora

-rw-r----- 1oracleoinstall2048Dec2806:25orapwDGASRPDB

-rw-r----- 1oracleoinstall2048Dec2806:25orapwASRDB2

7. Createtemppfiletostartthedbinnomount mode

[oracle@asr-host-dbstandbydbs]$echo"*.db_name='DGASRPDB'">/tmp/initdb.ora

[oracle@asr-host-dbstandby~]$cat/tmp/initdb.ora

*.db_name='DGASRPDB'

8. StartupDatabaseinnomount mode

[oracle@asr-host-dbstandby~]$sqlplus/assysdba

SQL*Plus:Release19.0.0.0.0-ProductiononThuDec2806:29:032023

Version19.21.0.0.0

SQL>startupnomountpfile='/tmp/initdb.ora';

ORACLEinstancestarted.

TotalSystemGlobalArea675282320bytes Fixed Size 8928656 bytes

Variable Size 457179136 bytes Database Buffers 201326592bytes Redo Buffers 7847936 bytes

9. CreateADUMPDirectory

*checkinprimaryandcreatethesame location

[oracle@asr-host-dbstandby~]$mkdir-p/u01/app/oracle/admin/DGASRPDB/adump/

10. Connecttormantargetandauxdbforactiveduplicate

[oracle@asr-host-dbstandby~]$rmantarget'sys/primarypass'@DGASRPDB_DBMAIN_DGMGRLauxiliary 'sys/primarypass'@DGASRPDB_STANDBY_DGMGRL

RecoveryManager:Release19.0.0.0.0-ProductiononThuDec2806:32:382023

Version19.21.0.0.0

11. Runtheactiveduplicatescript

12. Setthefollowingparameterin Standby

SQL>alter database flashback on; Database altered. standby_file_management-->auto

13. ShutdowntheDBfromsqlplusprompt

SQL>shuimmediate;

ORA-01109:databasenotopen Database dismounted.

ORACLEinstanceshut down.

14. Addthedatabaseinsrvctl

[oracle@asr-host-dbstandby~]$srvctladddatabase-dbDGASRPDBS–oraclehome

/u01/app/oracle/database/19.0.0/dbhome_1-domainDGASRPDB.local-spfile

/u01/app/oracle/database/19.0.0/dbhome_1/dbs/spfileDGASRPDB.ora-rolePHYSICAL_STANDBY- startoption MOUNT -dbname DGASRPDB -policy AUTOMATIC -instance DGASRPDB

[oracle@asr-host-dbstandby~]$srvctlconfigdatabase DGASRPDBS

[oracle@asr-host-dbstandby~]$srvctlconfigdatabase-dDGASRPDBS

Databaseuniquename:DGASRPDBS Database name: DGASRPDB

Oraclehome:/u01/app/oracle/database/19.0.0/dbhome_1 Oracle user: oracle

Spfile:/u01/app/oracle/database/19.0.0/dbhome_1/dbs/spfileDGASRPDB.ora Password file:

Domain:DGASRPDB.local Start options: mountStop options: immediate

Databaserole:PHYSICAL_STANDBY Management policy: AUTOMATIC Disk Groups:

Services:

OSDBAgroup:

OSOPERgroup:

Databaseinstance:DGASRPDB

15. AddServicetotheStandbyDB:

[oracle@asr-host-dbstandby~]$srvctlstatusservice-dDGASRPDBS-sDGASRPDB_ha.local

ServiceDGASRPDB_ha.localisnotrunning.

16. StartthestandbyDBusingsrvctl

[oracle@asr-host-dbstandby ~]$ srvctl start db -d DGASRPDBS [oracle@asr-host-dbstandby~]$srvctlstatusdb-dDGASRPDBS Database is running.

17. Changethefollowingparametersinprimary

SQL>altersystemsetstandby_file_management=AUTOscope=both;

Systemaltered.

SQL>altersystemsetdg_broker_start=truescope=both;

Systemaltered.

18. CreateDGMGRLConfigurationforstandby

[oracle@asr-host-dbprimary~]$dgmgrl'sys/primarypass'assysdba

DGMGRLforLinux:Release19.0.0.0.0-ProductiononThuDec2806:59:312023

Version19.21.0.0.0

Connectedto"DGASRPDB" Connected as SYSDBA.

DGMGRL>createconfiguration'DGASRPDB_dg_config'asprimarydatabaseis'DGASRPDB' connectidentifieris DGASRPDB_DBMAIN_DGMGRL;

Configuration"DGASRPDB_dg_config"createdwithprimarydatabase"DGASRPDB"

DGMGRL>adddatabaseDGASRPDBSasconnectidentifierisDGASRPDB_STANDBY_DGMGRL maintainedas physical;

Database"DGASRPDBs"added

DGMGRL>showconfiguration

Configuration-DGASRPDB_dg_config Protection Mode: MaxPerformance Members:

DGASRPDB- Primary database DGASRPDBs-Physicalstandbydatabase

Fast-StartFailover:Disabled Configuration Status:

DISABLED

DGMGRL>enableconfiguration

Enabled.

DGMGRL>showdatabaseDGASRPDBs

Database-DGASRPDBs

Role: PHYSICALSTANDBY

IntendedState: APPLY-ON

Transport Lag: 0seconds(computed0secondsago) Apply Lag: 0 seconds (computed 0 seconds ago) Average Apply Rate: 331.00 KByte/s

RealTimeQuery:ON Instance(s):

DGASRPDB

DatabaseStatus:

SUCCESS

19. AddServicetothePrimaryDB:

[oracle@asr-host-dbprimary ~]$ srvctl start service -d DGASRPDB -s DGASRPDB_ha.local [oracle@asr-host-dbprimary~]$srvctlstatusservice-dDGASRPDB-sDGASRPDB_ha.local Service DGASRPDB_ha.local is running

----------------------------------------------****---------------------------------------------------

LOGS

[oracle@asr-host-dbstandby~]$rmantarget'sys/primarypass'@DGASRDB_DBMAIN_DGMGRLauxiliary 'sys/standbypass'@DGASRDB_STANDBY_DGMGRL

RecoveryManager:Release19.0.0.0.0-ProductiononThuDec2806:40:38 2023

Version19.21.0.0.0

connectedtoauxiliarydatabase:DGASRDB(notmounted)

RMAN> duplicate target database for standby from active database dorecover spfile set db_unique_name='DGASRDBS' comment 'Is Standby' set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=asr-host-dbstandby)(PORT=1521))'nofilenamecheck;

StartingDuplicateDbat28-DEC-23

usingtargetdatabasecontrolfileinsteadofrecoverycatalog allocated channel: ORA_AUX_DISK_1

channelORA_AUX_DISK_1:SID=130devicetype=DISK current log archived

contentsofMemoryScript:

{

backupascopyreuse

passwordfileauxiliaryformat'/u01/app/oracle/database/19.0.0/dbhome_1/dbs/orapwDGASRDB'; restore clone from service'DGASRDB_DBMAIN_DGMGRL' spfile to '/u01/app/oracle/database/19.0.0/dbhome_1/dbs/spfileDGASRDB.ora';

sqlclone"altersystemsetspfile=''/u01/app/oracle/database/19.0.0/dbhome_1/dbs/spfileDGASRDB.ora''";

}

executingMemoryScript

Starting backup at 28-DEC-23 allocatedchannel:ORA_DISK_1

channelORA_DISK_1:SID=499devicetype=DISK Finished backup at 28-DEC-23

Starting restore at 28-DEC-23 usingchannelORA_AUX_DISK_1

channelORA_AUX_DISK_1:startingdatafilebackupsetrestore

channelORA_AUX_DISK_1:usingnetworkbackupsetfromserviceDGASRDB_DBMAIN_DGMGRL channel ORA_AUX_DISK_1: restoring SPFILE

outputfilename=/u01/app/oracle/database/19.0.0/dbhome_1/dbs/spfileDGASRDB.ora channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01

Finishedrestoreat28-DEC-23

sqlstatement:altersystemsetspfile=''/u01/app/oracle/database/19.0.0/dbhome_1/dbs/spfileDGASRDB.ora''

contentsofMemoryScript:

{

sqlclone"altersystemsetdb_unique_name= ''DGASRDBS'' comment=

''IsStandby''scope=spfile";

sql clone "alter system setlocal_listener = ''(ADDRESS=(PROTOCOL=TCP)(HOST=asr-host-dbstandby)(PORT=1521))''comment= '''' scope=spfile";

shutdowncloneimmediate; startup clone nomount;

}

executingMemoryScript

sqlstatement:altersystemsetdb_unique_name=''DGASRDBS''comment=''IsStandby''scope=spfile

sqlstatement:altersystemsetlocal_listener=''(ADDRESS=(PROTOCOL=TCP)(HOST=asr-host- dbstandby)(PORT=1521))'' comment= '''' scope=spfile

Oracleinstanceshutdown

connectedtoauxiliarydatabase(notstarted) Oracle instance started

TotalSystemGlobalArea20132657264bytes

FixedSize 18372720bytes

Variable Size 2483027968 bytes Database Buffers 17582522368bytes Redo Buffers 48734208 bytes

duplicatingOnlinelogstoOracleManagedFile(OMF)location duplicating Datafiles to Oracle Managed File (OMF) location

contentsofMemoryScript:

{

sql clone "alter system setcontrol_files = ''+DGDATA/DGASRDBS/CONTROLFILE/current.257.1156747271'',

''+DGDATA/DGASRDBS/CONTROLFILE/current.258.1156747271''comment=

''SetbyRMAN''scope=spfile";

restoreclonefromservice'DGASRDB_DBMAIN_DGMGRL'standbycontrolfile;

}

executingMemoryScript

sqlstatement:altersystemsetcontrol_files=''+DGDATA/DGASRDBS/CONTROLFILE/current.257.1156747271'', ''+DGDATA/DGASRDBS/CONTROLFILE/current.258.1156747271'' comment= ''Set by RMAN'' scope=spfile

Starting restore at 28-DEC-23 allocatedchannel:ORA_AUX_DISK_1

channelORA_AUX_DISK_1:SID=1102devicetype=DISK

channelORA_AUX_DISK_1:startingdatafilebackupset restore

channelORA_AUX_DISK_1:usingnetworkbackupsetfromserviceDGASRDB_DBMAIN_DGMGRL channel ORA_AUX_DISK_1: restoring control file

channelORA_AUX_DISK_1:restorecomplete,elapsedtime:00:00:01

outputfilename=+DGDATA/DGASRDBS/CONTROLFILE/current.261.1156747273 outputfilename=+DGDATA/DGASRDBS/CONTROLFILE/current.262.1156747273 Finished restore at 28-DEC-23

contentsofMemoryScript:

{

sqlclone'alterdatabasemountstandbydatabase';

}

executingMemoryScript

sqlstatement:alterdatabasemountstandbydatabase

contentsofMemoryScript:

{

setnewnameforclonetempfile1tonew; switch clone tempfile all;

setnewnameforclonedatafile1tonew; setnewnameforclonedatafile2tonew; setnewnameforclonedatafile3tonew; setnewnameforclonedatafile4tonew; setnewnameforclonedatafile5tonew; setnewnameforclonedatafile7tonew; setnewnameforclonedatafile8tonew; setnewnameforclonedatafile9tonew;

restore

fromnonsparsefrom service 'DGASRDB_DBMAIN_DGMGRL'clonedatabase

;

sql'altersystemarchivelogcurrent';

}

executingMemoryScript

executingcommand:SETNEWNAME

renamedtempfile1to+DGDATAincontrolfile

executingcommand:SETNEWNAME

Starting restore at 28-DEC-23 usingchannelORA_AUX_DISK_1

channelORA_AUX_DISK_1:startingdatafilebackupsetrestore