SYNC ARCHIVES if HUGE archives get not in SYNC with PRIMARY

SYNC ARCHIVES if HUGE archives get not in SYNC on STANDBY with PRIMARY

SB> Startup mount;
--------------archive log list


check last applied archive log
--------------select max(sequence#) from v$archived_log;

check cuuecnt SCN
--------------select current_SCN from v$database;

try to recover without backup
--------------Recover standby database;

PB> select sequence#, name from v$archived_log where sequence# > 9052;


PB> RMAN target /
RUN {
ALLOCATE CHANNEL C1 TYPE DISK FORMAT '/home/oracle/BACKUP/FOR_STANDBY_%U';
ALLOCATE CHANNEL C2 TYPE DISK FORMAT '/home/oracle/BACKUP/FOR_STANDBY_%U';
ALLOCATE CHANNEL C3 TYPE DISK FORMAT '/home/oracle/BACKUP/FOR_STANDBY_%U';
ALLOCATE CHANNEL C4 TYPE DISK FORMAT '/home/oracle/BACKUP/FOR_STANDBY_%U';
backup incremental from scn 3192439481 database tag 'FORSTANDBY' format '/home/oracle/SYNC_back_%d_%t_%s_%p';
RELEASE CHANNEL C1;
RELEASE CHANNEL C2;
RELEASE CHANNEL C3;
RELEASE CHANNEL C4;
}


RMAN >backup current controlfile for standby format '/home/oracle/FORSTDBYCTRL.bck';
PB> ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/home/oracle/standby_control.ctl';


scp the backup files from PRIMARY to STANDBY (same location in PRIMARY)

PB> scp oracle@qpdb201:/home/oracle/backup_control_file oracle@qpdb101:/home/oracle/backup_control_file

PB> scp oracle@qpdb201:/home/oracle/backup_file oracle@qpdb101:/home/oracle/backup_file

SB> SHUT immediate
SB> startup nomount
SB> rman target /

RMAN> restore stabdby controlfile from '/home/oracle/FORSTDBYCTRL.bck';
RMAN> alter database mount;
RMAN> catalog start with '/home/oracle/';
RMAN> catalog backuppiece  '/home/oracle/DG01_830395300_22_1';
RMAN> Recover database noredo;

SB> sqlplus / as sysdba
--------alter database flashback off;
--------alter database flashback on;
--------alter database recover managed standby database disconnect from session;

PB> and SB> archive log list
PB> and SB> select current_SCN from v$database;

check the CURRENT_SCN is very near comparision(not equal, it should be very near similar to PRIMARY)
check the ARCH sequence in both PRIMARY and STANDBY