STEPS to SYNC PRIMARY DB and STANDBY DB

STEPS to SYNC PRIMARY DB and STANDBY DB

sync primary database and standby database if archive gap is very less

1.check the alert log from PRIMARY side and STANDBY side for problem
sqlplus / as sysdba
archive log list
show parameter alert
! or host
cd /u01/app/oracle/diag/rdbms/test/TEST/trace/alertlog.log

2. check on what sequence of archive its got problem
3.copy the particular archive from PRIMARY to standby
cd /u04/oracle/test/oraarch/
scp oracle@test:/u04/oracle/test/oraarch/twest_01.arc oracle@testsb:/u04/oracle/test/oraarch/test_01.arc

4.start STANDBY database in mount mode
startup nomount
alter database mount;

5.stop the MRP process on STANDBY
6.recover the database using the archive log which is copied from PRIMARY
alter database recover managed standby database cancel;
recover database;
copy the path of archive log

7.Then bring up the MRP process
alter database recover managed standby database disconnect from session;

8.Check the archive logs are in sync in both PRIMARY and STANDBY
archive log list
select thread#,sequence#,applied,archived from v$archived_log;