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/01/rolling-forward-physical-standby-using.html
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