13 Replies Latest reply: Jan 18, 2013 2:46 AM by stee1rat RSS

    Archive Process error.

    969526
      Hi Exports,

      I am getting the following Error Under the Application event log in the server manager windows. As i am the only DBA in this company i have the solve the server issue also.

      *"archive process. error oracle instance prod. archival error. archiver continuing"*

      My database is running in Windows O/S.

      I checked the archive location as there is only 4 GB space free

      Please Suggest Some solution for this.


      Thanks In Advance...
      Asmit Das
        • 1. Re: Archive Process error.
          Osama_Mustafa
          Post Alert log , Mention DB version , OS version
          • 2. Re: Archive Process error.
            CKPT
            Hi Exports,
            Exports ;)
            I am getting the following Error Under the Application event log in the server manager windows. As i am the only DBA in this company i have the solve the server issue also.
            *"archive process. error oracle instance prod. archival error. archiver continuing"*
            My database is running in Windows O/S.
            I checked the archive location as there is only 4 GB space free
            Do you have configured more than one destination? Or remote destinations(Data Guard) ?
            I think these are informational/waring messages and you database will be functioning normally. Can you check what is the status of all the redo log group members?
            Is there any huge load and there are no more INACTIVE redo groups to serve? I guess it is more issue with availability of INACTIVE redo groups.

            1) Share Alert log information.
            2) Get ASH report for that duration (Max 10 minutes)
            -- see any issues during logswitch/archiving?
            3) Check log history, How many archives been generated
            4) check redo log file size
            5) what is the status of redo log groups if issue still persists.

            HTH.
            • 3. Re: Archive Process error.
              Rob_J
              Hi,

              I'm running on Windows as well and we see these alerts when there are no issues. I believe it could be down to having Data Guard installed, too. We ignore them and monitor space on the archived REDO log drive and any alerts from the Enterprise Manager.

              If you are receiving the [url http://www.ora00600.com/scripts/databaseconfig/ORA-00257.html]ORA-00257 error that is a different matter, and you need to resolve that straight away.

              Is the database functioning without any problems apart from those alerts in the event viewer?
              • 4. Re: Archive Process error.
                969526
                My Database is 10.2.0.4 and OS version is Windows server 2008
                • 5. Re: Archive Process error.
                  969526
                  Hi,


                  The following is my Log Status

                  SQL> set lines 180 pages 180
                  SQL> select * from v$log;

                  GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM
                  ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ---------
                  8 1 110613 134217728 2 YES INACTIVE 6321698498 17-JAN-13
                  9 1 110614 134217728 2 YES INACTIVE 6321887433 17-JAN-13
                  10 1 110615 134217728 2 NO CURRENT 6322057373 17-JAN-13



                  This is my Alert Log




                  FAL[server, ARC3]: FAL archive failed, see trace file.
                  Thu Jan 17 10:53:57 2013
                  Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_arc3_8664.trc:
                  ORA-16055: FAL request rejected

                  ARCH: FAL archive failed. Archiver continuing
                  Thu Jan 17 10:57:02 2013
                  Thread 1 advanced to log sequence 110579 (LGWR switch)
                  Current log# 10 seq# 110579 mem# 0: G:\ORADATA\REDO10A.LOG
                  Current log# 10 seq# 110579 mem# 1: H:\ORADATA\REDO10B.LOG
                  Thu Jan 17 10:57:02 2013
                  ARC0: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 10:58:57 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 11:01:58 2013
                  Thread 1 advanced to log sequence 110580 (LGWR switch)
                  Current log# 8 seq# 110580 mem# 0: G:\ORADATA\REDO08A.LOG
                  Current log# 8 seq# 110580 mem# 1: H:\ORADATA\REDO08B.LOG
                  Thu Jan 17 11:01:58 2013
                  ARC1: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 11:04:18 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 11:04:34 2013
                  Thread 1 advanced to log sequence 110581 (LGWR switch)
                  Current log# 9 seq# 110581 mem# 0: G:\ORADATA\REDO09A.LOG
                  Current log# 9 seq# 110581 mem# 1: H:\ORADATA\REDO09B.LOG
                  Thu Jan 17 11:04:34 2013
                  ARC2: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 11:09:40 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 11:09:49 2013
                  Thread 1 advanced to log sequence 110582 (LGWR switch)
                  Current log# 10 seq# 110582 mem# 0: G:\ORADATA\REDO10A.LOG
                  Current log# 10 seq# 110582 mem# 1: H:\ORADATA\REDO10B.LOG
                  Thu Jan 17 11:09:49 2013
                  ARC3: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 11:12:42 2013
                  Thread 1 advanced to log sequence 110583 (LGWR switch)
                  Current log# 8 seq# 110583 mem# 0: G:\ORADATA\REDO08A.LOG
                  Current log# 8 seq# 110583 mem# 1: H:\ORADATA\REDO08B.LOG
                  Thu Jan 17 11:12:42 2013
                  ARC0: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 11:13:58 2013
                  Process J001 died, see its trace file
                  Thu Jan 17 11:13:58 2013
                  kkjcre1p: unable to spawn jobq slave process
                  Thu Jan 17 11:13:58 2013
                  Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_cjq0_8124.trc:


                  Thu Jan 17 11:15:01 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 11:20:07 2013
                  *************************************************************
                  Unable to allocate flashback log of 1946 blocks from
                  current recovery area of size 2147483648 bytes.
                  Current Flashback database retention is less than target
                  because of insufficient space in the flash recovery area.
                  Flashback will continue to use available space, but the
                  size of the flash recovery area must be increased to meet
                  the Flashback database retention target
                  Use ALTER SYSTEM SET db_recovery_file_dest_size command
                  to add space. DO NOT manually remove flashback log files
                  to create space.
                  *************************************************************
                  Thu Jan 17 11:20:10 2013
                  Thread 1 advanced to log sequence 110584 (LGWR switch)
                  Current log# 9 seq# 110584 mem# 0: G:\ORADATA\REDO09A.LOG
                  Current log# 9 seq# 110584 mem# 1: H:\ORADATA\REDO09B.LOG
                  Thu Jan 17 11:20:10 2013
                  ARC1: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 11:20:22 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 11:20:34 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 11:20:34 2013
                  Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_arc2_12612.trc:
                  ORA-12170: TNS:Connect timeout occurred

                  FAL[server, ARC2]: FAL archive failed, see trace file.
                  Thu Jan 17 11:20:34 2013
                  Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_arc2_12612.trc:
                  ORA-16055: FAL request rejected

                  ARCH: FAL archive failed. Archiver continuing
                  Thu Jan 17 11:24:00 2013
                  Process J001 died, see its trace file
                  Thu Jan 17 11:24:00 2013
                  kkjcre1p: unable to spawn jobq slave process
                  Thu Jan 17 11:24:00 2013
                  Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_cjq0_8124.trc:


                  Thu Jan 17 11:24:06 2013
                  Thread 1 advanced to log sequence 110585 (LGWR switch)
                  Current log# 10 seq# 110585 mem# 0: G:\ORADATA\REDO10A.LOG
                  Current log# 10 seq# 110585 mem# 1: H:\ORADATA\REDO10B.LOG
                  Thu Jan 17 11:24:06 2013
                  ARC3: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 11:25:43 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 11:27:19 2013
                  Thread 1 advanced to log sequence 110586 (LGWR switch)
                  Current log# 8 seq# 110586 mem# 0: G:\ORADATA\REDO08A.LOG
                  Current log# 8 seq# 110586 mem# 1: H:\ORADATA\REDO08B.LOG
                  Thu Jan 17 11:27:19 2013
                  ARC0: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 11:30:05 2013
                  Process m000 died, see its trace file
                  Thu Jan 17 11:30:05 2013
                  ksvcreate: Process(m000) creation failed
                  Thu Jan 17 11:30:06 2013
                  Thread 1 advanced to log sequence 110587 (LGWR switch)
                  Current log# 9 seq# 110587 mem# 0: G:\ORADATA\REDO09A.LOG
                  Current log# 9 seq# 110587 mem# 1: H:\ORADATA\REDO09B.LOG
                  Thu Jan 17 11:30:06 2013
                  ARC1: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 11:31:04 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 11:31:06 2013
                  Process m000 died, see its trace file
                  Thu Jan 17 11:31:06 2013
                  ksvcreate: Process(m000) creation failed
                  Thu Jan 17 11:32:07 2013
                  Process m000 died, see its trace file
                  Thu Jan 17 11:32:07 2013
                  ksvcreate: Process(m000) creation failed
                  Thu Jan 17 11:33:09 2013
                  Process m000 died, see its trace file
                  Thu Jan 17 11:33:09 2013
                  ksvcreate: Process(m000) creation failed
                  Thu Jan 17 11:36:26 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 11:41:47 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 11:44:02 2013
                  Process J001 died, see its trace file
                  Thu Jan 17 11:44:02 2013
                  kkjcre1p: unable to spawn jobq slave process
                  Thu Jan 17 11:44:02 2013
                  Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_cjq0_8124.trc:


                  Thu Jan 17 11:47:06 2013
                  Thread 1 advanced to log sequence 110588 (LGWR switch)
                  Current log# 10 seq# 110588 mem# 0: G:\ORADATA\REDO10A.LOG
                  Current log# 10 seq# 110588 mem# 1: H:\ORADATA\REDO10B.LOG
                  Thu Jan 17 11:47:06 2013
                  ARC2: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 11:47:08 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 11:47:33 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 11:47:33 2013
                  Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_arc3_8664.trc:
                  ORA-12170: TNS:Connect timeout occurred

                  FAL[server, ARC3]: FAL archive failed, see trace file.
                  Thu Jan 17 11:47:33 2013
                  Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_arc3_8664.trc:
                  ORA-16055: FAL request rejected

                  ARCH: FAL archive failed. Archiver continuing
                  Thu Jan 17 11:50:42 2013
                  *************************************************************
                  Unable to allocate flashback log of 1946 blocks from
                  current recovery area of size 2147483648 bytes.
                  Current Flashback database retention is less than target
                  because of insufficient space in the flash recovery area.
                  Flashback will continue to use available space, but the
                  size of the flash recovery area must be increased to meet
                  the Flashback database retention target
                  Use ALTER SYSTEM SET db_recovery_file_dest_size command
                  to add space. DO NOT manually remove flashback log files
                  to create space.
                  *************************************************************
                  Thu Jan 17 11:53:29 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 11:53:44 2013
                  Thread 1 advanced to log sequence 110589 (LGWR switch)
                  Current log# 8 seq# 110589 mem# 0: G:\ORADATA\REDO08A.LOG
                  Current log# 8 seq# 110589 mem# 1: H:\ORADATA\REDO08B.LOG
                  Thu Jan 17 11:53:44 2013
                  ARC0: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 11:54:04 2013
                  Process J001 died, see its trace file
                  Thu Jan 17 11:54:04 2013
                  kkjcre1p: unable to spawn jobq slave process
                  Thu Jan 17 11:54:04 2013
                  Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_cjq0_8124.trc:


                  Thu Jan 17 11:55:01 2013
                  Thread 1 advanced to log sequence 110590 (LGWR switch)
                  Current log# 9 seq# 110590 mem# 0: G:\ORADATA\REDO09A.LOG
                  Current log# 9 seq# 110590 mem# 1: H:\ORADATA\REDO09B.LOG
                  Thu Jan 17 11:55:01 2013
                  ARC1: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 11:58:50 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 12:04:12 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 12:09:33 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 12:14:07 2013
                  Process J001 died, see its trace file
                  Thu Jan 17 12:14:07 2013
                  kkjcre1p: unable to spawn jobq slave process
                  Thu Jan 17 12:14:07 2013
                  Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_cjq0_8124.trc:


                  Thu Jan 17 12:14:54 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 12:20:15 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 12:20:43 2013
                  *************************************************************
                  Unable to allocate flashback log of 1946 blocks from
                  current recovery area of size 2147483648 bytes.
                  Current Flashback database retention is less than target
                  because of insufficient space in the flash recovery area.
                  Flashback will continue to use available space, but the
                  size of the flash recovery area must be increased to meet
                  the Flashback database retention target
                  Use ALTER SYSTEM SET db_recovery_file_dest_size command
                  to add space. DO NOT manually remove flashback log files
                  to create space.
                  *************************************************************
                  Thu Jan 17 12:25:36 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 12:26:13 2013
                  Thread 1 advanced to log sequence 110591 (LGWR switch)
                  Current log# 10 seq# 110591 mem# 0: G:\ORADATA\REDO10A.LOG
                  Current log# 10 seq# 110591 mem# 1: H:\ORADATA\REDO10B.LOG
                  Thu Jan 17 12:26:13 2013
                  ARC2: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 12:30:26 2013
                  Process m001 died, see its trace file
                  Thu Jan 17 12:30:26 2013
                  ksvcreate: Process(m001) creation failed
                  Thu Jan 17 12:30:58 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 12:36:19 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 12:39:10 2013
                  Process J001 died, see its trace file
                  Thu Jan 17 12:39:10 2013
                  kkjcre1p: unable to spawn jobq slave process
                  Thu Jan 17 12:39:10 2013
                  Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_cjq0_8124.trc:


                  Thu Jan 17 12:41:40 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 12:46:56 2013
                  Thread 1 advanced to log sequence 110592 (LGWR switch)
                  Current log# 8 seq# 110592 mem# 0: G:\ORADATA\REDO08A.LOG
                  Current log# 8 seq# 110592 mem# 1: H:\ORADATA\REDO08B.LOG
                  Thu Jan 17 12:46:56 2013
                  ARC3: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 12:47:01 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 12:47:23 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 12:47:23 2013
                  Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_arc0_7588.trc:
                  ORA-12170: TNS:Connect timeout occurred

                  FAL[server, ARC0]: FAL archive failed, see trace file.
                  Thu Jan 17 12:47:23 2013
                  Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_arc0_7588.trc:
                  ORA-16055: FAL request rejected

                  ARCH: FAL archive failed. Archiver continuing
                  Thu Jan 17 12:48:18 2013
                  Thread 1 advanced to log sequence 110593 (LGWR switch)
                  Current log# 9 seq# 110593 mem# 0: G:\ORADATA\REDO09A.LOG
                  Current log# 9 seq# 110593 mem# 1: H:\ORADATA\REDO09B.LOG
                  Thu Jan 17 12:48:18 2013
                  ARC3: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 12:51:04 2013
                  *************************************************************
                  Unable to allocate flashback log of 1946 blocks from
                  current recovery area of size 2147483648 bytes.
                  Current Flashback database retention is less than target
                  because of insufficient space in the flash recovery area.
                  Flashback will continue to use available space, but the
                  size of the flash recovery area must be increased to meet
                  the Flashback database retention target
                  Use ALTER SYSTEM SET db_recovery_file_dest_size command
                  to add space. DO NOT manually remove flashback log files
                  to create space.
                  *************************************************************

                  Thu Jan 17 13:01:36 2013
                  ARC0: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 13:03:20 2013
                  Thread 1 advanced to log sequence 110601 (LGWR switch)
                  Current log# 8 seq# 110601 mem# 0: G:\ORADATA\REDO08A.LOG
                  Current log# 8 seq# 110601 mem# 1: H:\ORADATA\REDO08B.LOG
                  Thu Jan 17 13:03:20 2013
                  ARC1: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 13:03:44 2013
                  Thread 1 advanced to log sequence 110602 (LGWR switch)
                  Current log# 9 seq# 110602 mem# 0: G:\ORADATA\REDO09A.LOG
                  Current log# 9 seq# 110602 mem# 1: H:\ORADATA\REDO09B.LOG
                  Thu Jan 17 13:03:44 2013
                  ARC2: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 13:04:05 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 13:04:09 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 13:04:09 2013
                  Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_arc3_8664.trc:
                  ORA-12170: TNS:Connect timeout occurred

                  FAL[server, ARC3]: FAL archive failed, see trace file.
                  Thu Jan 17 13:04:09 2013
                  Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_arc3_8664.trc:
                  ORA-16055: FAL request rejected

                  ARCH: FAL archive failed. Archiver continuing
                  Thu Jan 17 13:09:15 2013
                  Process J001 died, see its trace file
                  Thu Jan 17 13:09:15 2013
                  kkjcre1p: unable to spawn jobq slave process
                  Thu Jan 17 13:09:15 2013
                  Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_cjq0_8124.trc:


                  Thu Jan 17 13:09:26 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 13:11:00 2013
                  Thread 1 advanced to log sequence 110603 (LGWR switch)
                  Current log# 10 seq# 110603 mem# 0: G:\ORADATA\REDO10A.LOG
                  Current log# 10 seq# 110603 mem# 1: H:\ORADATA\REDO10B.LOG
                  Thu Jan 17 13:11:00 2013
                  ARC0: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 13:14:47 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 13:15:26 2013
                  Thread 1 advanced to log sequence 110604 (LGWR switch)
                  Current log# 8 seq# 110604 mem# 0: G:\ORADATA\REDO08A.LOG
                  Current log# 8 seq# 110604 mem# 1: H:\ORADATA\REDO08B.LOG
                  Thu Jan 17 13:15:27 2013
                  ARC1: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 13:19:17 2013
                  Process J001 died, see its trace file
                  Thu Jan 17 13:19:17 2013
                  kkjcre1p: unable to spawn jobq slave process
                  Thu Jan 17 13:19:17 2013
                  Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_cjq0_8124.trc:


                  Thu Jan 17 13:20:08 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 13:21:07 2013
                  *************************************************************
                  Unable to allocate flashback log of 1946 blocks from
                  current recovery area of size 2147483648 bytes.
                  Current Flashback database retention is less than target
                  because of insufficient space in the flash recovery area.
                  Flashback will continue to use available space, but the
                  size of the flash recovery area must be increased to meet
                  the Flashback database retention target
                  Use ALTER SYSTEM SET db_recovery_file_dest_size command
                  to add space. DO NOT manually remove flashback log files
                  to create space.
                  *************************************************************
                  Thu Jan 17 13:25:29 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 13:30:51 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 13:35:21 2013
                  Thread 1 advanced to log sequence 110605 (LGWR switch)
                  Current log# 9 seq# 110605 mem# 0: G:\ORADATA\REDO09A.LOG
                  Current log# 9 seq# 110605 mem# 1: H:\ORADATA\REDO09B.LOG
                  Thu Jan 17 13:35:21 2013
                  ARC2: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 13:36:12 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 13:41:33 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 13:46:54 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 13:51:34 2013
                  *************************************************************
                  Unable to allocate flashback log of 1946 blocks from
                  current recovery area of size 2147483648 bytes.
                  Current Flashback database retention is less than target
                  because of insufficient space in the flash recovery area.
                  Flashback will continue to use available space, but the
                  size of the flash recovery area must be increased to meet
                  the Flashback database retention target
                  Use ALTER SYSTEM SET db_recovery_file_dest_size command
                  to add space. DO NOT manually remove flashback log files
                  to create space.
                  *************************************************************
                  Thu Jan 17 13:52:15 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 13:54:46 2013
                  Thread 1 advanced to log sequence 110606 (LGWR switch)
                  Current log# 10 seq# 110606 mem# 0: G:\ORADATA\REDO10A.LOG
                  Current log# 10 seq# 110606 mem# 1: H:\ORADATA\REDO10B.LOG
                  Thu Jan 17 13:54:46 2013
                  ARC3: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 13:55:12 2013
                  Thread 1 advanced to log sequence 110607 (LGWR switch)
                  Current log# 8 seq# 110607 mem# 0: G:\ORADATA\REDO08A.LOG
                  Current log# 8 seq# 110607 mem# 1: H:\ORADATA\REDO08B.LOG
                  Thu Jan 17 13:55:12 2013
                  ARC0: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 13:57:37 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 13:57:52 2013
                  Thread 1 advanced to log sequence 110608 (LGWR switch)
                  Current log# 9 seq# 110608 mem# 0: G:\ORADATA\REDO09A.LOG
                  Current log# 9 seq# 110608 mem# 1: H:\ORADATA\REDO09B.LOG
                  Thu Jan 17 13:57:52 2013
                  ARC1: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 14:02:58 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 14:04:19 2013
                  Thread 1 advanced to log sequence 110609 (LGWR switch)
                  Current log# 10 seq# 110609 mem# 0: G:\ORADATA\REDO10A.LOG
                  Current log# 10 seq# 110609 mem# 1: H:\ORADATA\REDO10B.LOG
                  Thu Jan 17 14:04:19 2013
                  ARC2: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 14:05:33 2013
                  Thread 1 advanced to log sequence 110610 (LGWR switch)
                  Current log# 8 seq# 110610 mem# 0: G:\ORADATA\REDO08A.LOG
                  Current log# 8 seq# 110610 mem# 1: H:\ORADATA\REDO08B.LOG
                  Thu Jan 17 14:05:33 2013
                  ARC3: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 14:06:54 2013
                  Thread 1 advanced to log sequence 110611 (LGWR switch)
                  Current log# 9 seq# 110611 mem# 0: G:\ORADATA\REDO09A.LOG
                  Current log# 9 seq# 110611 mem# 1: H:\ORADATA\REDO09B.LOG
                  Thu Jan 17 14:06:54 2013
                  ARC0: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 14:08:19 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 14:12:07 2013
                  Thread 1 advanced to log sequence 110612 (LGWR switch)
                  Current log# 10 seq# 110612 mem# 0: G:\ORADATA\REDO10A.LOG
                  Current log# 10 seq# 110612 mem# 1: H:\ORADATA\REDO10B.LOG
                  Thu Jan 17 14:12:07 2013
                  ARC1: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 14:13:40 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 14:17:35 2013
                  Thread 1 advanced to log sequence 110613 (LGWR switch)
                  Current log# 8 seq# 110613 mem# 0: G:\ORADATA\REDO08A.LOG
                  Current log# 8 seq# 110613 mem# 1: H:\ORADATA\REDO08B.LOG
                  Thu Jan 17 14:17:35 2013
                  ARC2: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 14:19:01 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 14:22:44 2013
                  *************************************************************
                  Unable to allocate flashback log of 1946 blocks from
                  current recovery area of size 2147483648 bytes.
                  Current Flashback database retention is less than target
                  because of insufficient space in the flash recovery area.
                  Flashback will continue to use available space, but the
                  size of the flash recovery area must be increased to meet
                  the Flashback database retention target
                  Use ALTER SYSTEM SET db_recovery_file_dest_size command
                  to add space. DO NOT manually remove flashback log files
                  to create space.
                  *************************************************************
                  Thu Jan 17 14:24:23 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 14:29:44 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 14:35:05 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 14:40:26 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 14:42:53 2013
                  Thread 1 advanced to log sequence 110614 (LGWR switch)
                  Current log# 9 seq# 110614 mem# 0: G:\ORADATA\REDO09A.LOG
                  Current log# 9 seq# 110614 mem# 1: H:\ORADATA\REDO09B.LOG
                  Thu Jan 17 14:42:53 2013
                  ARC3: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 14:45:47 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 14:49:26 2013
                  Process J001 died, see its trace file
                  Thu Jan 17 14:49:26 2013
                  kkjcre1p: unable to spawn jobq slave process
                  Thu Jan 17 14:49:26 2013
                  Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_cjq0_8124.trc:


                  Thu Jan 17 14:51:09 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 14:53:01 2013
                  *************************************************************
                  Unable to allocate flashback log of 1946 blocks from
                  current recovery area of size 2147483648 bytes.
                  Current Flashback database retention is less than target
                  because of insufficient space in the flash recovery area.
                  Flashback will continue to use available space, but the
                  size of the flash recovery area must be increased to meet
                  the Flashback database retention target
                  Use ALTER SYSTEM SET db_recovery_file_dest_size command
                  to add space. DO NOT manually remove flashback log files
                  to create space.
                  *************************************************************
                  Thu Jan 17 14:56:30 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 14:59:28 2013
                  Process J001 died, see its trace file
                  Thu Jan 17 14:59:28 2013
                  kkjcre1p: unable to spawn jobq slave process
                  Thu Jan 17 14:59:28 2013
                  Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_cjq0_8124.trc:


                  Thu Jan 17 15:00:36 2013
                  Thread 1 advanced to log sequence 110615 (LGWR switch)
                  Current log# 10 seq# 110615 mem# 0: G:\ORADATA\REDO10A.LOG
                  Current log# 10 seq# 110615 mem# 1: H:\ORADATA\REDO10B.LOG
                  Thu Jan 17 15:00:36 2013
                  ARC0: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 15:01:51 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 15:07:13 2013
                  Error 12170 received logging on to the standby
                  Thu Jan 17 15:09:30 2013
                  Process J001 died, see its trace file
                  Thu Jan 17 15:09:30 2013
                  kkjcre1p: unable to spawn jobq slave process
                  Thu Jan 17 15:09:30 2013
                  Errors in file d:\oracle\product\10.2.0\admin\orcl\bdump\orcl_cjq0_8124.trc:


                  Thu Jan 17 15:10:02 2013
                  Thread 1 advanced to log sequence 110616 (LGWR switch)
                  Current log# 8 seq# 110616 mem# 0: G:\ORADATA\REDO08A.LOG
                  Current log# 8 seq# 110616 mem# 1: H:\ORADATA\REDO08B.LOG
                  Thu Jan 17 15:10:02 2013
                  ARC1: Warning. Log sequence in archive filename wrapped
                  to fix length as indicated by %S in LOG_ARCHIVE_FORMAT.
                  Old log archive with same name might be overwritten.
                  Thu Jan 17 15:12:34 2013
                  Error 12170 received logging on to the standby
                  • 6. Re: Archive Process error.
                    CKPT
                    You have not provided all the required information on ASH report.
                    Then only we can see feasible impact and possible reason. Because these can be with many possible reasons Huge log switches, any mount point issues including space, so on...
                    Thu Jan 17 10:58:57 2013
                    Error 12170 received logging on to the standby
                    You have standby database(s) also.

                    Are you using FRA? can you check available and free space?
                    set lines 100
                    col name format a60
                    select     name
                    ,     floor(space_limit / 1024 / 1024) "Size MB"
                    ,     ceil(space_used  / 1024 / 1024) "Used MB"
                    from     v$recovery_file_dest
                    order by name
                    /
                    SQL> show parameter dest_2
                    SQL> archive log list
                    provide all the requested information next time. Thanks.
                    • 7. Re: Archive Process error.
                      969526
                      Yes we are using Standby Database using Dataguard. Ans also using FRA.


                      NAME Size MB Used MB
                      ------------------------------------------------------------ ---------- ----------
                      D:\oracle\product\10.2.0\flash_recovery_area 2048 2044



                      SQL> archive log list
                      Database log mode Archive Mode
                      Automatic archival Enabled
                      Archive destination I:\archive_log
                      Oldest online log sequence 110620
                      Next log sequence to archive 110622
                      Current log sequence 110622



                      SQL> show parameter dest_2

                      NAME_COL_PLUS_SHOW_PARAM TYPE
                      -------------------------------------------------------------------------------- -----------
                      VALUE_COL_PLUS_SHOW_PARAM
                      ----------------------------------------------------------------------------------------------------

                      log_archive_dest_2 string
                      SERVICE=stdby VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=stdby



                      The ASH REPORT AS FOLLOWS


                      ASH Report For ORCL/orcl
                      DB Name     DB Id     Instance     Inst num     Release     RAC     Host
                      ORCL     1235117800     orcl     1     10.2.0.4.0     NO     IGRDB1
                      CPUs     SGA Size     Buffer Cache     Shared Pool     ASH Buffer Size
                      16     10,240M (100%)     6,064M (59.2%)     2,064M (20.2%)     29.0M (0.3%)
                      Sample Time     Data Source
                      Analysis Begin Time:     17-Jan-13 10:09:48     V$ACTIVE_SESSION_HISTORY
                      Analysis End Time:     17-Jan-13 16:10:04     V$ACTIVE_SESSION_HISTORY
                      Elapsed Time:     360.3 (mins)     
                      Sample Count:     94,713     
                      Average Active Sessions:     4.38     
                      Avg. Active Session per CPU:     0.27     
                      Report Target:     None specified     

                      ASH Report
                      Top Events
                      Load Profile
                      Top SQL
                      Top PL/SQL
                      Top Sessions
                      Top Objects/Files/Latches
                      Activity Over Time

                      Back to Top

                      Top Events
                      Top User Events
                      Top Background Events
                      Top Event P1/P2/P3 Values
                      Back to Top

                      Top User Events
                      Event     Event Class     % Activity     Avg Active Sessions
                      CPU + Wait for CPU     CPU     57.29     2.51
                      direct path read     User I/O     29.52     1.29
                      Datapump dump file I/O     User I/O     4.43     0.19
                      db file sequential read     User I/O     2.58     0.11
                      db file scattered read     User I/O     1.08     0.05
                      Back to Top Events
                      Back to Top


                      Top Background Events
                      Event     Event Class     % Activity     Avg Active Sessions
                      ARCH wait on ATTACH     Network     1.60     0.07
                      log file parallel write     System I/O     1.12     0.05
                      Back to Top Events
                      Back to Top


                      Top Event P1/P2/P3 Values
                      Event     % Event     P1 Value, P2 Value, P3 Value     % Activity     Parameter 1     Parameter 2     Parameter 3
                      direct path read     29.52     "7","9734590","1"     0.00     file number     first dba     block cnt
                      Datapump dump file I/O     4.43     "1","256","4294967295"     4.43     count     intr     timeout
                      db file sequential read     2.60     "2","84646","1"     0.00     file#     block#     blocks
                      log file parallel write     1.12     "2","2","2"     0.30     files     blocks     requests
                      db file scattered read     1.08     "7","2558639","16"     0.00     file#     block#     blocks
                      Back to Top Events
                      Back to Top


                      Load Profile
                      Top Service/Module
                      Top Client IDs
                      Top SQL Command Types
                      Back to Top

                      Top Service/Module
                      Service     Module     % Activity     Action     % Action
                      orcl     w3wp.exe     58.26     UNNAMED     58.26
                      SYS$USERS     Data Pump Worker     34.12     SYS_EXPORT_TABLE_14     22.50
                                     SYS_EXPORT_SCHEMA_26     11.62
                      SYS$BACKGROUND     UNNAMED     4.14     UNNAMED     4.14
                      SYS$USERS     UNNAMED     1.65     UNNAMED     1.65
                      Back to Load Profile
                      Back to Top


                      Top Client IDs
                      No data exists for this section of the report.

                      Back to Load Profile
                      Back to Top


                      Top SQL Command Types
                      'Distinct SQLIDs' is the count of the distinct number of SQLIDs with the given SQL Command Type found over all the ASH samples in the analysis period
                      SQL Command Type     Distinct SQLIDs     % Activity     Avg Active Sessions
                      SELECT     2,209     55.67     2.44
                      INSERT     64     1.29     0.06
                      UPDATE     85     1.28     0.06
                      PL/SQL EXECUTE     130     1.07     0.05
                      Back to Load Profile
                      Back to Top


                      Top SQL
                      Top SQL Statements
                      Top SQL using literals
                      Complete List of SQL Text
                      Back to Top

                      Top SQL Statements
                      SQL ID     Planhash     % Activity     Event     % Event     SQL Text
                      14ukbtxkhcfp4     3178165737     11.46     CPU + Wait for CPU     11.42     SELECT * FROM BUYER_TBL BT WHE...
                      0m3jz8zv7a8gg     1396993632     6.12     CPU + Wait for CPU     6.12     SELECT D.DOC_TITLE || DECODE(D...
                      g9xj0sqnbn7rn     1022084864     5.15     CPU + Wait for CPU     5.13     SELECT * FROM DOCUMENT_TBL D W...
                      b6hpmd63xjjg5     267000234     4.62     CPU + Wait for CPU     4.62     SELECT * FROM DOCUMENT_TBL D W...
                      fqn74a2bp1n2u     3551315659     2.13     CPU + Wait for CPU     2.13     select v.doc_id, v.DOC_PRESENT...
                      Back to Top SQL
                      Back to Top


                      Top SQL using literals
                      Plan Hash     % Activity     # of Sampled SQL Versions     Example SQL 1     Example SQL TEXT 1     Example SQL 2     Example SQL TEXT 2
                      3551315659     4.92     4659     0kvd9jp23a9zv     select v.doc_id, v.DOC_PRESENT...     gzy913v1adk87     select v.doc_id, v.DOC_PRESENT...
                      Back to Top SQL
                      Back to Top


                      Complete List of SQL Text
                      SQL Id     SQL Text
                      0kvd9jp23a9zv     select v.doc_id, v.DOC_PRESENT_DATE, v.doc_type, v.doc_status_desc, regoff_name, v.Reg_No, to_char(dt.DOC_EXECUT_DATE, 'dd-mon-yyyy') DOC_EXECUT_DATE, to_char(dt.DOC_VALID_DATE, 'dd-mon-yyyy') DOC_VALID_DATE, (to_date(dt.DOC_VALID_DATE, 'dd-mm-yyyy')-to_date(sysdate, 'dd-mm-yyyy'))ValidLeft from Doc_status_vw v, document_tbl dt, deed_tbl dd, subdeed_tbl sdt where v.DOC_ID=dt.doc_id and dt.DOC_SDEED_I D=sdt.sdeed_id and dd.deed_id=sdt.sdeed_deed_id and dt.DOC_RO_ID=113 and v.DOC_PRESENT_DATE >= to_date('05/01/2013', 'dd/mm/yyyy') and v.DOC_PRESENT_DATE <= to_date('13/01/2013', 'dd/mm/yyyy') and dt.DOC_RO_ID=113 order by DOC_PRESENT_DATE desc, Reg_No, dt.doc_id, regoff_name, doc_status_desc, doc_type
                      0m3jz8zv7a8gg     SELECT D.DOC_TITLE || DECODE(D.DOC_ID, 2, (SELECT COUNT(D.DOC_ID) FROM DOCUMENT_TBL D WHERE D.DOC_STATUS IN ('DS', 'SC', 'CM') AND D.DOC_IS_SYSGEN IN (1, 2)), NULL) DOC_TITLE FROM DOCUMENT_UPLOAD D WHERE D.DOC_TYPE = 'News & Updates' ORDER BY D.DOC_PBL_DATE DESC
                      14ukbtxkhcfp4     SELECT * FROM BUYER_TBL BT WHERE BUYER_ID = :B1
                      b6hpmd63xjjg5     SELECT * FROM DOCUMENT_TBL D WHERE TRIM(DOC_STATUS) = :B2 AND DOC_RO_ID = :B1 AND D.DOC_ID NOT IN (SELECT E.DOC_ID FROM APPID_ENTRY_ACCESS_TBL E) ORDER BY D.INSERTED_ON DESC
                      fqn74a2bp1n2u     select v.doc_id, v.DOC_PRESENT_DATE, v.doc_type, v.doc_status_desc, regoff_name, v.Reg_No, to_char(dt.DOC_EXECUT_DATE, 'dd-mon-yyyy') DOC_EXECUT_DATE, to_char(dt.DOC_VALID_DATE, 'dd-mon-yyyy') DOC_VALID_DATE, (to_date(dt.DOC_VALID_DATE, 'dd-mm-yyyy')-to_date(sysdate, 'dd-mm-yyyy'))ValidLeft from Doc_status_vw v, document_tbl dt, deed_tbl dd, subdeed_tbl sdt where v.DOC_ID=dt.doc_id and dt.DOC_SDEED_I D=sdt.sdeed_id and dd.deed_id=sdt.sdeed_deed_id and dt.DOC_RO_ID=108 and v.DOC_PRESENT_DATE >= to_date('10/01/2013', 'dd/mm/yyyy') and v.DOC_PRESENT_DATE <= to_date('18/01/2013', 'dd/mm/yyyy') and dt.DOC_RO_ID=108 order by DOC_PRESENT_DATE desc, Reg_No, dt.doc_id, regoff_name, doc_status_desc, doc_type
                      g9xj0sqnbn7rn     SELECT * FROM DOCUMENT_TBL D WHERE TRIM(DOC_STATUS) = :B2 AND DOC_RO_ID = :B1 ORDER BY D.INSERTED_ON DESC
                      gzy913v1adk87     select v.doc_id, v.DOC_PRESENT_DATE, v.doc_type, v.doc_status_desc, regoff_name, v.Reg_No, to_char(dt.DOC_EXECUT_DATE, 'dd-mon-yyyy') DOC_EXECUT_DATE, to_char(dt.DOC_VALID_DATE, 'dd-mon-yyyy') DOC_VALID_DATE, (to_date(dt.DOC_VALID_DATE, 'dd-mm-yyyy')-to_date(sysdate, 'dd-mm-yyyy'))ValidLeft from Doc_status_vw v, document_tbl dt, deed_tbl dd, subdeed_tbl sdt where v.DOC_ID=dt.doc_id and dt.DOC_SDEED_I D=sdt.sdeed_id and dd.deed_id=sdt.sdeed_deed_id and dt.DOC_RO_ID=5 and v.DOC_PRESENT_DATE >= to_date('10/01/2013', 'dd/mm/yyyy') and v.DOC_PRESENT_DATE <= to_date('18/01/2013', 'dd/mm/yyyy') and dt.DOC_RO_ID=5 order by DOC_PRESENT_DATE desc, Reg_No, dt.doc_id, regoff_name, doc_status_desc, doc_type
                      Back to Top SQL
                      Back to Top


                      Top PL/SQL Procedures
                      'PL/SQL entry subprogram' represents the application's top-level entry-point(procedure, function, trigger, package initialization or RPC call) into PL/SQL.
                      'PL/SQL current subprogram' is the pl/sql subprogram being executed at the point of sampling . If the value is 'SQL', it represents the percentage of time spent executing SQL for the particular plsql entry subprogram
                      PLSQL Entry Subprogram     % Activity     PLSQL Current Subprogram     % Current
                      SYS.KUPW$WORKER.MAIN     34.12     SQL     29.65
                                SYS.KUPD$DATA_INT.UNLOAD_DATA     4.47
                      ORISSA_SYNC_FINAL.UPDATE_LOGIN_STATUS     1.64     SQL     1.64
                      ORISSA_SYNC_FINAL.TEST_ATTENDANCE_PKG.RPT_ATTENDANCE_SP     1.01     SQL     1.00

                      Back to Top


                      Top Sessions
                      Top Sessions
                      Top Blocking Sessions
                      Top Sessions running PQs
                      Back to Top

                      Top Sessions
                      '# Samples Active' shows the number of ASH samples in which the session was found waiting for that particular event. The percentage shown in this column is calculated with respect to wall clock time and not total database activity.
                      'XIDs' shows the number of distinct transaction IDs sampled in ASH when the session was waiting for that particular event
                      For sessions running Parallel Queries, this section will NOT aggregate the PQ slave activity into the session issuing the PQ. Refer to the 'Top Sessions running PQs' section for such statistics.
                      Sid, Serial#     % Activity     Event     % Event     User     Program     # Samples Active     XIDs
                      155,54417     22.50     direct path read     19.15     ORISSA_TRANSACTION     ORACLE.EXE (DW03)     18K/22K [ 84%]     2
                                Datapump dump file I/O     2.56               2,423/22K [ 11%]     2
                      224,47377     11.62     direct path read     9.02     ORISSA_TRANSACTION     ORACLE.EXE (DW01)     8,543/22K [ 40%]     79
                                Datapump dump file I/O     1.88               1,776/22K [ 8%]     83
                      856, 3     1.55     ARCH wait on ATTACH     1.49     SYS     ORACLE.EXE (ARC0)     1,415/22K [ 7%]     0
                      880, 1     1.33     log file parallel write     1.12     SYS     ORACLE.EXE (LGWR)     1,060/22K [ 5%]     0
                      Back to Top Sessions
                      Back to Top


                      Top Blocking Sessions
                      No data exists for this section of the report.

                      Back to Top Sessions
                      Back to Top


                      Top Sessions running PQs
                      No data exists for this section of the report.

                      Back to Top Sessions
                      Back to Top


                      Top Objects/Files/Latches
                      Top DB Objects
                      Top DB Files
                      Top Latches
                      Back to Top

                      Top DB Objects
                      With respect to Application, Cluster, User I/O and buffer busy waits only.
                      Object ID     % Activity     Event     % Event     Object Name (Type)     Tablespace
                      52326     7.93     direct path read     7.03     ORISSA_TRANSACTION.SYS_LOB0000052317C00010$$ (LOB)     ORISSA_TRANSACTION
                      52328     7.38     direct path read     6.52     ORISSA_TRANSACTION.SYS_LOB0000052317C00011$$ (LOB)     ORISSA_TRANSACTION
                      52330     3.48     direct path read     3.33     ORISSA_TRANSACTION.SYS_LOB0000052317C00012$$ (LOB)     ORISSA_TRANSACTION
                      76295     1.83     direct path read     1.55     ORISSA_TRANSACTION.SYS_LOB0000076294C00003$$ (LOB)     ORISSA_TRANSACTION
                      52056     1.74     direct path read     1.41     ORISSA_TRANSACTION.SYS_LOB0000052053C00007$$ (LOB)     ORISSA_TRANSACTION
                      Back to Top Objects/Files/Latches
                      Back to Top


                      Top DB Files
                      With respect to Cluster and User I/O events only.
                      File ID     % Activity     Event     % Event     File Name     Tablespace
                      7     36.11     direct path read     29.43     J:\ORADATA\ORISSA_TRANSACTION.DBF     ORISSA_TRANSACTION
                                Datapump dump file I/O     4.43          
                                db file sequential read     1.13          
                      2     1.37     db file sequential read     1.36     G:\ORADATA\UNDOTBS01.DBF     UNDOTBS1
                      Back to Top Objects/Files/Latches
                      Back to Top


                      Top Latches
                      No data exists for this section of the report.

                      Back to Top Objects/Files/Latches
                      Back to Top


                      Activity Over Time
                      Analysis period is divided into smaller time slots
                      Top 3 events are reported in each of those slots
                      'Slot Count' shows the number of ASH samples in that slot
                      'Event Count' shows the number of ASH samples waiting for that event in that slot
                      '% Event' is 'Event Count' over all ASH samples in the analysis period
                      Slot Time (Duration)     Slot Count     Event     Event Count     % Event
                      10:09:48 (2.2 min)     674     CPU + Wait for CPU     365     0.39
                                direct path read     231     0.24
                                Datapump dump file I/O     32     0.03
                      10:12:00 (36.0 min)     9,697     CPU + Wait for CPU     4,771     5.04
                                direct path read     3,876     4.09
                                Datapump dump file I/O     410     0.43
                      10:48:00 (36.0 min)     9,347     CPU + Wait for CPU     4,316     4.56
                                direct path read     3,594     3.79
                                Datapump dump file I/O     610     0.64
                      11:24:00 (36.0 min)     9,705     CPU + Wait for CPU     4,736     5.00
                                direct path read     3,725     3.93
                                Datapump dump file I/O     506     0.53
                      12:00:00 (36.0 min)     10,223     CPU + Wait for CPU     5,332     5.63
                                direct path read     3,756     3.97
                                Datapump dump file I/O     514     0.54
                      12:36:00 (36.0 min)     12,143     CPU + Wait for CPU     6,996     7.39
                                direct path read     3,210     3.39
                                Datapump dump file I/O     750     0.79
                      13:12:00 (36.0 min)     9,550     CPU + Wait for CPU     6,336     6.69
                                direct path read     2,104     2.22
                                db file scattered read     296     0.31
                      13:48:00 (36.0 min)     7,935     CPU + Wait for CPU     5,117     5.40
                                direct path read     1,933     2.04
                                db file sequential read     239     0.25
                      14:24:00 (36.0 min)     8,118     CPU + Wait for CPU     5,520     5.83
                                direct path read     1,890     2.00
                                Datapump dump file I/O     249     0.26
                      15:00:00 (36.0 min)     8,532     CPU + Wait for CPU     5,702     6.02
                                direct path read     1,933     2.04
                                Datapump dump file I/O     286     0.30
                      15:36:00 (34.1 min)     8,789     CPU + Wait for CPU     5,933     6.26
                                direct path read     1,712     1.81
                                Datapump dump file I/O     363     0.38
                      • 8. Re: Archive Process error.
                        Niket Kumar
                        increase the fra size

                        Unable to allocate flashback log of 1946 blocks from
                        current recovery area of size 2147483648 bytes.
                        Current Flashback database retention is less than target
                        because of insufficient space in the flash recovery area.
                        Flashback will continue to use available space, but the
                        size of the flash recovery area must be increased to meet
                        the Flashback database retention target
                        Use ALTER SYSTEM SET db_recovery_file_dest_size command
                        to add space. DO NOT manually remove flashback log files
                        to create space.

                        alter system set db_recovery_file_dest_size=10G; or you can increase the size according to your requirement.
                        • 9. Re: Archive Process error.
                          Osama_Mustafa
                          Please provide output for query that given by CKPT
                          • 10. Re: Archive Process error.
                            stee1rat
                            What error were you talking about in your original post?

                            Error 12170 in your alert log is clearly says that your primary database couldn't connect to one of your standby databases. Check the output of 'show parameter dest' (you can post it here) and check connection to each SERVICE in each destination.

                            If you don't need this standby database you can just disable it by setting LOG_ARCHIVE_DEST_STATE_n=defer.
                            • 11. Re: Archive Process error.
                              969526
                              The following is the Parameters For LOG_ARCHIVE_


                              Now we are not using Standby Server.




                              NAME TYPE VALUE
                              ------------------------------------ ----------- ------------------------------
                              log_archive_config string DG_CONFIG=(orcl,stdby)
                              log_archive_dest string
                              log_archive_dest_1 string LOCATION=I:\archive_log VALID_
                              FOR=(ALL_LOGFILES,ALL_ROLES) D
                              B_UNIQUE_NAME=orcl
                              log_archive_dest_10 string
                              log_archive_dest_2 string SERVICE=stdby VALID_FOR=(ONLIN
                              E_LOGFILES,PRIMARY_ROLE) DB_UN
                              IQUE_NAME=stdby
                              log_archive_dest_3 string
                              log_archive_dest_4 string
                              log_archive_dest_5 string
                              log_archive_dest_6 string
                              log_archive_dest_7 string
                              log_archive_dest_8 string
                              log_archive_dest_9 string
                              log_archive_dest_state_1 string enable
                              log_archive_dest_state_10 string enable
                              log_archive_dest_state_2 string enable
                              log_archive_dest_state_3 string enable
                              log_archive_dest_state_4 string enable
                              log_archive_dest_state_5 string enable
                              log_archive_dest_state_6 string enable
                              log_archive_dest_state_7 string enable
                              log_archive_dest_state_8 string enable
                              log_archive_dest_state_9 string enable
                              log_archive_duplex_dest string
                              log_archive_format string ARC%D_%S_%R.%T
                              log_archive_local_first boolean TRUE
                              log_archive_max_processes integer 4
                              log_archive_min_succeed_dest integer 1
                              log_archive_start boolean FALSE
                              log_archive_trace integer 0



                              Can i use LOG_ARCHIVE_DEST_STATE_n=defer...
                              • 12. Re: Archive Process error.
                                969526
                                SQL> show parameter LOG_ARCHIVE_DEST_STATE

                                NAME TYPE VALUE
                                ------------------------------------ ----------- ------------------------------
                                log_archive_dest_state_1 string enable
                                log_archive_dest_state_10 string enable
                                log_archive_dest_state_2 string enable
                                log_archive_dest_state_3 string enable
                                log_archive_dest_state_4 string enable
                                log_archive_dest_state_5 string enable
                                log_archive_dest_state_6 string enable
                                log_archive_dest_state_7 string enable
                                log_archive_dest_state_8 string enable
                                log_archive_dest_state_9 string enable
                                SQL>
                                • 13. Re: Archive Process error.
                                  stee1rat
                                  966523 wrote:
                                  Can i use LOG_ARCHIVE_DEST_STATE_n=defer...
                                  Sure, if you don't need this standby anymore just execute 'alter system set log_archive_dest_state_2=defer' (this is the dynamic parameter) and errors 12170 in your alert log will disappear.

                                  Or, if you still need this standby database, you need to fix it: check its' state. It's probably down or its' listener is down .