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 max(sequence#) from v$log_history;
MAX(SEQUENCE#)
————–
76969
SQL> exit
=========================================
ON STANDBY SERVER:
$ ps -ef|grep pmon
oratst 2978 1 0 Sep 08 ? 147:34 ora_pmon_amantst
oracle 3039 1 0 Sep 08 ? 137:34 ora_pmon_airman
e460269 16109 16104 0 18:54:44 pts/1 0:00 grep pmon
$ su – oracle
Password:
mesg: cannot change mode
$ sqlplus
SQL*Plus: Release 10.2.0.3.0 – Production on Thu May 17 18:55:10 2012
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Enter user-name: /as sysdba
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> select max(sequence#) from v$log_history;
MAX(SEQUENCE#)
————–
8548
SQL> select max(sequence#) from v$log_history;
MAX(SEQUENCE#)
————–
8549
SQL> select * from v$archive_gap;
SQL> select sequence#, archived, applied, status from v$archived_log;