11 Replies Latest reply: Aug 3, 2012 6:41 AM by DB RSS

    Log shipping from primary to DR had alternate Archive-log gap.

    DB
      Hi all,

      Still the same problem exists.

      <font color="red">DB : Oracle 9i
      OS : HP-UX</font>


      1.Alternate logs are ships automatically to DR DB.for say(1,3,5,7 archive logs).

      2.Others are ships manually to DR DB .for say(2,4,6).

      3.i got an error in primary DB.while issue this query
      SQL> select error,status from v$archive_dest where dest_id=2;

      ERROR                                                                             STATUS
      ORA-12154: TNS:could not resolve service name ERROR

      (this the only clue i got,but the alternate logs are ships automatically)

      4.i checked the tnsnames.ora,sqlnet.ora,listener.ora no problem in configuration.

      5.Tnsping standby db on primary db ......also pinging

      6.sqlplus 'sys@standby as sysdba' on primary also connecting well.

      7.i checked on LSNRCTL>STATUS ...

      Service "ovsd" has 2 instance(s).
      Instance "ovsd", status UNKNOWN, has 1 handler(s) for this service...
      Instance "ovsd", status READY, has 1 handler(s) for this service...

      Before i discussed with CKPT the same issue
      log shipping from primary to DR had archive-log gap.

      Any suggestion to solve this :-)

      thanks in advance,

      Regards,
      Db.

      Edited by: DB on Aug 1, 2012 10:04 AM
        • 1. Re: Log shipping from primary to DR had alternate Archive-log gap.
          CKPT
          1.Alternate logs are applying automatically to DR DB.for say(1,3,5,7 archive logs).
          2.Others are applying manually to DR DB .for say(2,4,6).
          No, Automatic archives cant be applied on standby database, Archives must apply by in sequence order such as 1,2,3,4...
          or
          you saying it is transferring but not applying ?


          3.i got an error in primary DB.while issue this query
          SQL> select error,status from v$archive_dest where dest_id=2;

          ERROR                                                                             STATUS
          ORA-12154: TNS:could not resolve service name ERROR
          Can you post Your Listener.ora file & tnsnames.ora file? if not possible then refer below link.

          http://edstevensdba.wordpress.com/2011/02/26/ora-12154tns-03505/

          (this the only clue i got,but the alternate logs are applying automatically)
          Again, i wont agree. it wont apply.
          4.i checked the tnsnames.ora,sqlnet.ora,listener.ora no problem in configuration.

          5.Tnsping standby db on primary db ......also pinging

          6.sqlplus 'sys@standby as sysdba' on primary also connecting well.

          7.i checked on LSNRCTL>STATUS ...

          Service "ovsd" has 2 instance(s).
          Instance "ovsd", status UNKNOWN, has 1 handler(s) for this service...
          Instance "ovsd", status READY, has 1 handler(s) for this service...

          Before i discussed with CKPT the same issue
          log shipping from primary to DR had archive-log gap.
          :-) Let's see now.
          • 2. Re: Log shipping from primary to DR had alternate Archive-log gap.
            DB
            hi ckpt,

            sorry you are correct it not applying ,it log shipping.

            regards,
            Db.
            • 3. Re: Log shipping from primary to DR had alternate Archive-log gap.
              Shivananda Rao
              Please post listener.ora file of primary

              Primary:
              select severity,error_code,message from v$dataguard_status where dest_id=2;
              select max(sequence#) from v$archived_log;
              Standby:
              select max(sequence#) from v$archived_log where applied='YES';
              • 4. Re: Log shipping from primary to DR had alternate Archive-log gap.
                DB
                primary:

                select severity,error_code,message from v$dataguard_status where dest_id=2;
                no rows selected

                select max(sequence#) from v$archived_log;
                MAX(SEQUENCE#)
                --------------
                7270


                secondary:
                select max(sequence#) from v$archived_log where applied='YES';
                MAX(SEQUENCE#)
                --------------
                7266

                Regards,
                Db.
                • 5. Re: Log shipping from primary to DR had alternate Archive-log gap.
                  Seberg
                  Action Item:

                  Post last 100 lines of Standby alert log.
                  • 6. Re: Log shipping from primary to DR had alternate Archive-log gap.
                    DB
                    hi,

                    ovsd@drsrv1$tail -f -b 300 /oracle/admin/ovsd/bdump/alert*
                    ed during: alter database register logfile '/archive/standby/...
                    Tue Jul 31 14:42:05 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 14:47:03 2012
                    alter database register logfile '/archive/standby/ovsd/archive-ovsd_1_7264.arc'
                    Tue Jul 31 14:47:03 2012
                    There are 1 logfiles specified.
                    ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
                    Completed: alter database register logfile '/archive/standby/
                    Tue Jul 31 14:47:10 2012
                    alter database register logfile '/archive/standby/ovsd/archive-ovsd_1_7265.arc'
                    There are 1 logfiles specified.
                    ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
                    Register archivelog /archive/standby/ovsd/archive-ovsd_1_7265.arc already exists
                    ORA-16089 signalled during: alter database register logfile '/archive/standby...
                    Tue Jul 31 14:47:21 2012
                    alter database register logfile '/archive/standby/ovsd/archive-ovsd_1_7266.arc'
                    Tue Jul 31 14:47:21 2012
                    There are 1 logfiles specified.
                    ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
                    Register archivelog /archive/standby/ovsd/archive-ovsd_1_7266.arc already exists
                    ORA-16089 signalled during: alter database register logfile '/archive/standby/...
                    Tue Jul 31 14:47:26 2012
                    alter database register logfile '/archive/standby/ovsd/archive-ovsd_1_7267.arc'
                    There are 1 logfiles specified.
                    ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
                    Error locating archivelog filename '/archive/standby/ovsd/archive-ovsd_1_7267.arc': 308
                    ORA-308 signalled during: alter database register logfile '/archive/standby/...
                    Tue Jul 31 14:48:09 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 14:48:33 2012
                    alter database recover managed standby database disconnect from session
                    Tue Jul 31 14:48:33 2012
                    Attempt to start background Managed Standby Recovery process
                    MRP0 started with pid=14
                    MRP0: Background Managed Standby Recovery process started
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7250.arc
                    Tue Jul 31 14:48:40 2012
                    Completed: alter database recover managed standby database di
                    Tue Jul 31 14:49:46 2012
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7251.arc
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7252.arc
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7253.arc
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7254.arc
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7255.arc
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7256.arc
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7257.arc
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7258.arc
                    Tue Jul 31 14:54:12 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 14:54:27 2012
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7259.arc
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7260.arc
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7261.arc
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7262.arc
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7263.arc
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7264.arc
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7265.arc
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7266.arc
                    Tue Jul 31 15:00:16 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 15:00:47 2012
                    Media Recovery Waiting for thread 1 seq# 7267
                    Fetching gap sequence for thread 1, gap sequence 7267-7268
                    Trying FAL server:
                    Error fetching gap sequence, no FAL server specified
                    Tue Jul 31 15:01:02 2012
                    Failed to request gap sequence. Thread #: 1, gap sequence: 7267-7268
                    All FAL server has been attempted.
                    Tue Jul 31 15:06:21 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 15:12:25 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 15:18:28 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 15:24:31 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 15:30:35 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 15:36:38 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 15:42:40 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 15:48:43 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 15:54:47 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 16:00:50 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 16:06:54 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 16:12:57 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 16:19:01 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 16:25:04 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 16:31:05 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 16:37:08 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 16:43:14 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 16:49:17 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 16:55:20 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 17:01:24 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 17:07:27 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 17:13:31 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 17:19:34 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 17:25:38 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 17:31:42 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 17:37:46 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 17:43:49 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 17:49:53 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 17:55:56 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 18:02:01 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 18:08:04 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 18:14:05 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 18:20:08 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 18:26:12 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 18:32:15 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 18:38:19 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 18:44:22 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 18:50:26 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 18:56:30 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 19:02:33 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 19:08:37 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 19:14:37 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 19:20:40 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 19:26:44 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 19:32:47 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 19:38:51 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 19:44:55 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 19:50:58 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 19:51:23 2012
                    RFS: Possible network disconnect with primary database
                    Tue Jul 31 19:57:02 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 20:03:05 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 20:09:09 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 20:15:12 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 20:21:16 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 20:27:19 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 20:33:23 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 20:39:26 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 20:45:27 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 20:51:30 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 20:57:34 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 21:03:37 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 21:09:41 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 21:15:45 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 21:21:49 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 21:27:53 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 21:33:57 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 21:40:00 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 21:46:02 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 21:52:06 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 21:58:09 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 22:04:13 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 22:10:16 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 22:16:20 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 22:22:23 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 22:28:27 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 22:34:30 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 22:40:34 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 22:46:36 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 22:52:39 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 22:58:42 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 23:04:47 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 23:10:50 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 23:16:54 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 23:22:57 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 23:29:01 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 23:35:05 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 23:41:09 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 23:47:09 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 23:53:14 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 23:59:18 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 00:05:22 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 00:11:27 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 00:17:31 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 00:23:35 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 00:29:40 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 00:35:44 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 00:41:48 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 00:47:52 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 00:53:56 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 01:00:01 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 01:06:06 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 01:12:11 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 01:18:17 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 01:24:21 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 01:30:25 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 01:36:26 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 01:42:34 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 01:48:38 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 01:54:42 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 02:00:47 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 02:06:51 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 02:12:55 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 02:18:58 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 02:25:02 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 02:31:05 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 02:37:06 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 02:43:13 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 02:49:17 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 02:55:20 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 02:56:48 2012
                    RFS: Possible network disconnect with primary database
                    Wed Aug 1 03:01:25 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 03:07:28 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 03:13:32 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 03:19:35 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 03:25:39 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 03:31:43 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 03:37:46 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 03:43:50 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 03:49:54 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 03:55:54 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 04:00:57 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 04:07:01 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 04:13:04 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 04:19:08 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 04:25:09 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 04:31:13 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 04:37:17 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 04:43:25 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 04:49:29 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 04:55:30 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 05:01:34 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 05:07:37 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 05:13:41 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 05:19:44 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 05:25:45 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 05:31:49 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 05:37:52 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 05:43:56 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 05:50:00 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 05:56:00 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 06:02:04 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 06:08:08 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 06:14:11 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 06:20:15 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 06:26:18 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 06:32:22 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 06:38:25 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 06:44:30 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 06:50:33 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 06:56:34 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 07:02:38 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 07:08:42 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 07:14:45 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 07:20:49 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 07:26:53 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 07:32:56 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 07:38:59 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 07:45:03 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 07:51:06 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 07:57:07 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 08:03:10 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 08:09:14 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 08:15:17 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 08:21:21 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 08:27:24 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 08:33:28 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 08:39:31 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 08:45:35 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 08:51:38 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 08:57:39 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 09:03:42 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 09:09:45 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 09:15:49 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 09:21:52 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 09:27:56 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 09:33:59 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 09:40:03 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 09:46:07 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 09:52:11 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 09:58:14 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Wed Aug 1 10:04:18 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9



                    These below are after manually appllied to the DR database.
                    ---------------------------------

                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7250.arc
                    Tue Jul 31 14:48:40 2012
                    Completed: alter database recover managed standby database di
                    Tue Jul 31 14:49:46 2012
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7251.arc
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7252.arc
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7253.arc
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7254.arc
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7255.arc
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7256.arc
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7257.arc
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7258.arc
                    Tue Jul 31 14:54:12 2012
                    Restarting dead background process QMN0
                    QMN0 started with pid=9
                    Tue Jul 31 14:54:27 2012
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7259.arc
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7260.arc
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7261.arc
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7262.arc
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7263.arc
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7264.arc
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7265.arc
                    Media Recovery Log /archive/standby/ovsd/archive-ovsd_1_7266.arc
                    -----------------------------------------------------------------------

                    These above are after manually appllied to the DR database.


                    Regards,
                    Db.

                    Edited by: DB on Aug 1, 2012 12:35 PM

                    Edited by: DB on Aug 1, 2012 12:38 PM
                    • 7. Re: Log shipping from primary to DR had alternate Archive-log gap.
                      CKPT
                      Use this below script and post in coded format

                      http://www.oracle-ckpt.com/dataguard_troubleshoot_snapper/
                      • 8. Re: Log shipping from primary to DR had alternate Archive-log gap.
                        Seberg
                        This part:
                        alter database register logfile '/archive/standby/ovsd/archive-ovsd_1_7267.arc'
                        There are 1 logfiles specified.
                        ALTER DATABASE REGISTER [PHYSICAL] LOGFILE
                        Error locating archivelog filename '/archive/standby/ovsd/archive-ovsd_1_7267.arc': 308
                        ORA-308 signalled during: alter database register logfile '/archive/standby/...
                        Tue Jul 31 14:48:09 2012
                        Restarting dead background process QMN0
                        I believe that "archive-ovsd_1_7267.arc" is not on your standby system.

                        Cause and effect.
                        • 9. Re: Log shipping from primary to DR had alternate Archive-log gap.
                          DB
                          hi ckpt,

                          on primary DB:

                          My Db is 9i.so here display_value ,db_unique_name identifier is not viewed.
                          SELECT name FROM v$parameter WHERE name IN ('db_name','db_unique_name','log_archive_config','log_archive_dest_2','log_archive_dest_state_2','fal_client','fal_server','standby_file_management','standby_archive_dest','db_file_name_convert','log_file_name_convert','remote_login_passwordfile','local_listener','dg_broker_start','dg_broker_config_file1','dg_broker_config_file2','log_archive_max_processes') order by name
                          
                          NAME
                          ------------------------------------------------------------
                          db_file_name_convert
                          db_name
                          dg_broker_config_file1
                          dg_broker_config_file2
                          dg_broker_start
                          fal_client
                          fal_server
                          local_listener
                          log_archive_dest_2
                          log_archive_dest_state_2
                          log_archive_max_processes
                          log_file_name_convert
                          remote_login_passwordfile
                          standby_archive_dest
                          standby_file_management
                          
                          SELECT name,protection_mode,DATABASE_ROLE,OPEN_MODE,switchover_status from v$database;
                          
                          NAME   PROTECTION_MODE      DATABASE_R OPEN_MODE      SWITCHOVER_STATUS
                          -----  -------------------- ---------- ---------- ------------------
                          OVSD   MAXIMUM PERFORMANCE  PRIMARY    READ WRITE     SESSIONS ACTIVE
                          
                             THREAD# MAX(SEQUENCE#)
                          ---------- --------------
                                   1           7281
                          
                              Thread Last Sequence Received Last Sequence Applied Difference
                          ---------- ---------------------- --------------------- ----------
                                   1                   7281                  7281          0
                                   1                   7281                  7281          0
                          
                           ID STATUS    DB_MODE         TYPE RECOVERY_MODE        PROTECTION_MODE      SRLs ACTIVE ARCHIVED_SEQ#
                          --- --------- --------------- ---- -------------------- -------------------- ---- ------ -------------
                            1 VALID     OPEN            ARCH IDLE                 MAXIMUM PERFORMANCE     0      0          7281
                            2 ERROR     MOUNTED-STANDBY ARCH MANAGED              MAXIMUM PERFORMANCE     0      0          7252
                          on standby DB:
                          SELECT name FROM v$parameter WHERE name IN ('db_name','db_unique_name','log_archive_config','log_archive_dest_2','log_archive_dest_state_2','fal_client','fal_server','standby_file_management','standby_archive_dest','db_file_name_convert','log_file_name_convert','remote_login_passwordfile','local_listener','dg_broker_start','dg_broker_config_file1','dg_broker_config_file2','log_archive_max_processes') order by name;
                          NAME
                          ----------------------------------------------------------------
                          db_file_name_convert
                          db_name
                          dg_broker_config_file1
                          dg_broker_config_file2
                          dg_broker_start
                          fal_client
                          fal_server
                          local_listener
                          log_archive_dest_2
                          log_archive_dest_state_2
                          log_archive_max_processes
                          log_file_name_convert
                          remote_login_passwordfile
                          standby_archive_dest
                          standby_file_management
                          
                          SQL> SELECT name,protection_mode,DATABASE_ROLE,OPEN_MODE from v$database;
                          
                          NAME       PROTECTION_MODE      DATABASE_R             OPEN_MODE
                          ---------- -------------------- ----------             ----------
                          OVSD       MAXIMUM PERFORMANCE  PHYSICAL STANDBY         MOUNTED
                                                          
                          SQL>  select thread#,max(sequence#) from v$archived_log where applied='YES' group by thread#;
                          
                             THREAD# MAX(SEQUENCE#)
                          ---------- --------------
                                   1           7279
                                     
                          SQL> select process, status,thread#,sequence# from v$managed_standby;
                          
                          PROCESS   STATUS          THREAD#  SEQUENCE#
                          --------- ------------ ---------- ----------
                          ARCH      CONNECTED             0          0
                          ARCH      CONNECTED             0          0
                          MRP0      WAIT_FOR_GAP          1       7280
                          
                          SQL> select * from v$archive_gap;
                          
                             THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#
                          ---------- ------------- --------------
                                   1          7280           7280
                          
                          SQL> select    name ,floor(space_limit / 1024 / 1024) "Size MB" ,ceil(space_used  / 1024 / 1024) "Used MB"
                          from    v$recovery_file_dest order by name; 
                          from    v$recovery_file_dest
                                  *
                          ERROR at line 4:
                          ORA-01219: database not open: queries allowed on fixed tables/views only
                          here v$recovery_file_dest not in 9i.

                          Regards,
                          DB.
                          • 10. Re: Log shipping from primary to DR had alternate Archive-log gap.
                            CKPT
                            Hello,

                            I cant see values of standby configuration parameters, such FAL client , server, destination, archive_config & so on..
                             ID STATUS    DB_MODE         TYPE RECOVERY_MODE        PROTECTION_MODE      SRLs ACTIVE ARCHIVED_SEQ#
                            --- --------- --------------- ---- -------------------- -------------------- ---- ------ -------------
                              1 VALID     OPEN            ARCH IDLE                 MAXIMUM PERFORMANCE     0      0          7281
                              2 ERROR     MOUNTED-STANDBY ARCH MANAGED              MAXIMUM PERFORMANCE     0      0          7252
                            Here remote destination has Error to find out the error either you have to consult 1) primary alert log file (or) 2) views v$dataguard_status.

                            do as follows and post as is and soon.
                            1) SQL> alter system set log_archive_dest_state_2='defer';
                            2) shutdown standby and put in mount status
                            3) Perform couple of log switches on primary
                            4) enable archive transport
                            SQL> alter system set log_archive_dest_state_2='enable';
                            5) Perform couple of log switches on primary
                            6) check alert log file
                            &
                            SQL> select message, error_code,to_char(timestamp,'DD-MON-YYYY HH24:MI:SS') from v$dataguard_status where dest_id=2;

                            7) post below query output as well
                            select     ds.dest_id id
                            ,     ad.status
                            ,     ds.database_mode db_mode
                            ,     ad.archiver type
                            ,     ds.recovery_mode
                            ,     ds.protection_mode
                            ,     ds.standby_logfile_count "SRLs"
                            ,     ds.standby_logfile_active active
                            ,     ds.archived_seq#
                            from     v$archive_dest_status     ds
                            ,     v$archive_dest          ad
                            where     ds.dest_id = ad.dest_id
                            and     ad.status != 'INACTIVE'
                            order by
                                 ds.dest_id
                            /
                            Hope you are not missing even one step.. and post exact output. Thanks.
                            • 11. Re: Log shipping from primary to DR had alternate Archive-log gap.
                              DB
                              From Primary:
                                      ID STATUS    DB_MODE         TYPE       RECOVER PROTECTION_MODE
                              ---------- --------- --------------- ---------- ------- --------------------
                                    SRLs     ACTIVE ARCHIVED_SEQ#
                              ---------- ---------- -------------
                                       1 VALID     OPEN            ARCH       IDLE    MAXIMUM PERFORMANCE
                                       0          0          7291
                              
                                       2 ERROR     MOUNTED-STANDBY ARCH       MANAGED MAXIMUM PERFORMANCE
                                       0          0          7291
                              On Standby:
                                      ID STATUS    DB_MODE         TYPE       RECOVER PROTECTION_MODE       SRLs     ACTIVE ARCHIVED_SEQ#
                              ---------- --------- --------------- ---------- ------- --------------- ---------- ---------- -------------
                                       1 VALID     MOUNTED-STANDBY ARCH       MANAGED MAXIMUM PERFORM          0          0             0
                                                                                      ANCE
                              
                                       2 VALID     MOUNTED-STANDBY ARCH       MANAGED MAXIMUM PERFORM          0          0             0
                                                                                      ANCE
                              
                                      11 VALID     MOUNTED-STANDBY ARCH       MANAGED MAXIMUM PERFORM          0          0          7291
                                                                                      ANCE
                              Regards,
                              Db.