Environment:
Oracle 11.2.0.4 EE on Solaris 10
I recently re-created my Physical Standby database by shipping all the RMAN backup files (backupsets, control files, etc.) and running a RECOVER DATABASE, RESTORE DATABASE on the Standby server.
Before I did that I stopped the log shipping from the Primary. In hindsight I should have kept the log shipping going but I don't think that's the cause of my issue since the logs came over nicely as soon as I turned log shipping back on.
My issue: The archive logs are present and registered on the Standby. MRP is running. However the MRP process seems to be stuck on a particular archive log and I can't get it to move.
I've compared the files on the Primary and Standby and they are the same size. I even scp'd the file again just to be sure I had a correct and complete version.
The status shows:
DB_UNIQUE_NAME DEST_ID STATUS DATABASE_MODE RECOVERY_MODE ARCHIVED_SEQ# GAP_STATUS ERROR
------------------------------ ---------- ------ --------------- ----------------------- ------------- ------------------------ -----------------------------------------------------------------
APSKTLP1 1 VALID OPEN IDLE 33771 NO GAP NO ERRORS
APSKTLP1 2 VALID MOUNTED-STANDBY MANAGED REAL TIME APPLY 33771 UNRESOLVABLE GAP NO ERRORS
Even though it's showing 'UNRESOLVABLE GAP' all the archivelog files that exist on the Primary also exist on the Standby.
I even tried to re-register all the log files after the log shipping was completed.
From V$ARCHIVED_LOG on the Standby I see:
NAME SEQUENCE# DEST_ID S APPLIED CDATE
-------------------------------------------------- ---------- ---------- - --------- -----------------------------
/arch/APSKTLP1/1_33700_769093790.dbf 33700 2 A YES 23-sep-2016 07:07:31
/arch/APSKTLP1/1_33701_769093790.dbf 33701 2 A YES 23-sep-2016 07:07:33
/arch/APSKTLP1/1_33702_769093790.dbf 33702 2 A YES 23-sep-2016 07:07:35
/arch/APSKTLP1/1_33703_769093790.dbf 33703 2 A YES 23-sep-2016 07:07:38
/arch/APSKTLP1/1_33704_769093790.dbf 33704 2 A YES 23-sep-2016 07:07:41
/arch/APSKTLP1/1_33705_769093790.dbf 33705 2 A YES 23-sep-2016 07:07:43
/arch/APSKTLP1/1_33706_769093790.dbf 33706 2 A YES 23-sep-2016 07:07:45
/arch/APSKTLP1/1_33707_769093790.dbf 33707 2 A YES 23-sep-2016 07:07:46
/arch/APSKTLP1/1_33708_769093790.dbf 33708 2 A NO 23-sep-2016 07:06:34
/arch/APSKTLP1/1_33709_769093790.dbf 33709 2 A NO 23-sep-2016 07:06:30
/arch/APSKTLP1/1_33710_769093790.dbf 33710 2 A NO 23-sep-2016 07:06:36
/arch/APSKTLP1/1_33711_769093790.dbf 33711 2 A NO 23-sep-2016 07:06:41
I can't get sequence number 33708 to apply.
Any suggestions are most welcome!
Thanks very much!!
-gary