Tag Archives: Primary and Standby archive crosscheck

Oracle best practice: Primary and Standby archive crosscheck

Primary: STEP -1 ======== LOGIN TO THE PRIMARY SERVER $ su – orapr1 Password: STEP -2 ======= GET THE SEQUENCE MAX FROM V$LOG_HISTORY SQL> select max(sequence#) from v$log_history; MAX(SEQUENCE#) ————– 76968 SQL> alter system switch logfile; System altered. SQL> select … Continue reading

Posted in Uncategorized | Tagged , , , | Leave a comment