recover standby database ORA-01110 ORA-01194 ORA-01547 warning: RECOVER succeeded but OPEN RESETLOGS would get error below

Error:

SQL> recover standby database;

ORA-00279: change 10133160396101 generated at 04/05/2017 20:43:03 needed for

thread 1

ORA-00289: suggestion : /u02/archive/arch_1_3801_869915362.arc

ORA-00280: change 10133160396101 for thread 1 is in sequence #3801

 

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

/u02/archive/arch_1_3801_869915362.arc

ORA-16145: archival for thread# 1 sequence# 3801 in progress

 

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/u03/oracle/proddb/db/apps_st/data/system01.dbf'

SQL>

Solution:

Copy the archive logs from the prod to the standby then recover the database until datafile headers and controlfile are in sync.