Rolling Forward a Physical Standby || DR database is out of sync || archivelog are missing

Steps to perform for Rolling Forward a Physical Standby Database using RMAN Incremental Backup. (Doc ID 836986.1)

Rolling Forward a Physical Standby Using Recover From Service Command in 12c (Doc ID 1987763.1)

Follow Below Blog for more details:
https://mallik034.blogspot.com/2022/0...

PROD Environment :
DB: ORCL
Server: oracledb.localdomain.com
Oracle Home: /u01/app/oracle/product/19.0.0.0/dbhome_1

DR Environment :
DB: ORCLSB
Server: oraclesb.localdomain.com
Oracle Home: /u01/app/oracle/product/19.0.0.0/dbhome_1


STEP 1: CHECK PRIMARY & STANDBY DATABASE STATUS:
STEP 2: CHECK ARCHIVE SEQUENCES on PRIMARY & STANDBY:
STEP 3: CANCEL RECOVERY ON STANDBY:
STEP 4: START STANDBY DB IN MOUNT STATE( IF it is ACTIVE DATAGUARD):
STEP 5: RECOVER STANDBY USING SERVICE:
STEP 8: RUN RECOVER DATABASE(IN STANDBY - NOT Mandatory):
STEP 9: OPEN THE DATABASE and START MEDIA RECOVERY:

#Roleforward #Sync #DR #DataGuard #Standby #PhysicalStandby #LogicalStandby #SnapshotStandby #Database #Exadata #RAC #ASM #Oracle

Regards,
Mallikarjun Ramadurg
Mobile: +91 9880616848
WhatsApp: +91 9880616848