4 Replies Latest reply: Feb 25, 2013 7:28 AM by mseberg RSS

    Reg : no rfs background processor in standby

    989969
      hai all,


      os:windows server
      oracle :10.2.0.3

      i have a problem with my standby database. i found no rfs bacckground processor in standby while siing the query

      >>> select process,status,sequence# fro mv$managed_standby;

      PROCESS STATUS SEQUENCE#
      --------- ------------ ----------
      ARCH CONNECTED 0
      ARCH CONNECTED 0
      ARCH CONNECTED 0
      ARCH CONNECTED 0
      ARCH CONNECTED 0
      ARCH CONNECTED 0
      ARCH CONNECTED 0
      ARCH CONNECTED 0
      ARCH CONNECTED 0
      ARCH CONNECTED 0
      MRP0 WAIT_FOR_LOG 5949

      i have shutdown the standby instance ,mounted and start the recovery (twice). still having the same issue. .

      MORE OVER THERE IS NO ARCHIVE GAP
      HELP ME IN THIS ...

      REGARDS

      GOLD....
        • 1. Re: Reg : no rfs background processor in standby
          saratpvv
          what your alert log saying..? can you paste last 100 line of alert log..?
          • 2. Re: Reg : no rfs background processor in standby
            989969
            my log file...............



            Mon Feb 25 07:48:05 2013
            Starting ORACLE instance (normal)
            LICENSE_MAX_SESSION = 0
            LICENSE_SESSIONS_WARNING = 0
            Picked latch-free SCN scheme 3
            Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
            Autotune of undo retention is turned on.
            IMODE=BR
            ILAT =18
            LICENSE_MAX_USERS = 0
            SYS auditing is disabled
            ksdpec: called for event 13740 prior to event group initialization
            Starting up ORACLE RDBMS Version: 10.2.0.3.0.
            System parameters with non-default values:
            processes = 150
            __shared_pool_size = 352321536
            __large_pool_size = 16777216
            __java_pool_size = 16777216
            __streams_pool_size = 0
            nls_language = ENGLISH
            nls_territory = UNITED KINGDOM
            sga_target = 1610612736
            control_files = E:\ORADATA\WPLQDM\CONTROL01.CTL, I:\ORADATA\WPLQDM\CONTROL02.CTL, J:\ORADATA\WPLQDM\CONTROL03.CTL
            db_block_size = 8192
            __db_cache_size = 1207959552
            compatible = 10.2.0.1.0
            log_archive_config = DG_CONFIG=(wplqdmp,wplqdms2)
            log_archive_dest_2 = SERVICE=wpl_qdm_pro OPTIONAL LGWR ASYNC NOAFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=wplqdms2
            log_archive_max_processes= 10
            fal_client = wpl_qdm_stb2
            fal_server = wpl_qdm_pro
            db_file_multiblock_read_count= 16
            db_recovery_file_dest = J:\flash_recovery_area
            db_recovery_file_dest_size= 31457280000
            standby_file_management = AUTO
            undo_management = AUTO
            undo_tablespace = UNDOTBS1
            remote_login_passwordfile= EXCLUSIVE
            db_domain =
            service_names = WPLQDM
            dispatchers = (PROTOCOL=TCP) (SERVICE=wplqdmXDB)
            job_queue_processes = 10
            audit_file_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\WPLQDM\ADUMP
            background_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\WPLQDM\BDUMP
            user_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\WPLQDM\UDUMP
            core_dump_dest = E:\ORACLE\PRODUCT\10.2.0\ADMIN\WPLQDM\CDUMP
            db_name = wplqdm
            db_unique_name = WPLQDMS2
            open_cursors = 300
            pga_aggregate_target = 1277165568
            PMON started with pid=2, OS id=3516
            PSP0 started with pid=3, OS id=4064
            MMAN started with pid=4, OS id=580
            DBW0 started with pid=5, OS id=4184
            LGWR started with pid=6, OS id=5032
            CKPT started with pid=7, OS id=4076
            SMON started with pid=8, OS id=3604
            RECO started with pid=9, OS id=344
            CJQ0 started with pid=10, OS id=800
            MMON started with pid=11, OS id=4200
            Mon Feb 25 07:48:05 2013
            starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
            MMNL started with pid=12, OS id=4804
            Mon Feb 25 07:48:05 2013
            starting up 1 shared server(s) ...
            Mon Feb 25 07:48:17 2013
            alter database mount standby database
            Mon Feb 25 07:48:21 2013
            Setting recovery target incarnation to 1
            ARCH: STARTING ARCH PROCESSES
            ARC0 started with pid=16, OS id=4024
            ARC1 started with pid=17, OS id=3712
            ARC2 started with pid=18, OS id=4376
            ARC3 started with pid=19, OS id=2052
            ARC4 started with pid=20, OS id=4468
            ARC5 started with pid=21, OS id=3556
            ARC6 started with pid=22, OS id=3212
            ARC7 started with pid=23, OS id=4476
            ARC8 started with pid=24, OS id=516
            Mon Feb 25 07:48:21 2013
            ARC0: Archival started
            ARC1: Archival started
            Mon Feb 25 07:48:21 2013
            ARC2: Archival started
            ARC3: Archival started
            ARC4: Archival started
            ARC5: Archival started
            ARC6: Archival started
            ARC7: Archival started
            ARC8: Archival started
            ARC9: Archival started
            ARCH: STARTING ARCH PROCESSES COMPLETE
            Mon Feb 25 07:48:21 2013
            ARC0: Becoming the 'no FAL' ARCH
            ARC0: Becoming the 'no SRL' ARCH
            Mon Feb 25 07:48:21 2013
            ARC1: Becoming the heartbeat ARCH
            Mon Feb 25 07:48:21 2013
            ARC8: Thread not mounted
            Mon Feb 25 07:48:21 2013
            Successful mount of redo thread 1, with mount id 171090433
            Mon Feb 25 07:48:21 2013
            Physical Standby Database mounted.
            Completed: alter database mount standby database
            Mon Feb 25 07:48:22 2013
            ARC7: Thread not mounted
            ARC0: Thread not mounted
            Mon Feb 25 07:48:24 2013
            ARC5: Thread not mounted
            Mon Feb 25 07:48:25 2013
            ARC2: Thread not mounted
            Mon Feb 25 07:48:26 2013
            ARC3: Thread not mounted
            ARC1: Thread not mounted
            Mon Feb 25 07:48:28 2013
            ARC6: Thread not mounted
            ARC9 started with pid=25, OS id=4384
            Mon Feb 25 07:48:30 2013
            ARC4: Thread not mounted
            Mon Feb 25 07:49:00 2013
            alter database recover managed standby database disconnect
            MRP0 started with pid=26, OS id=4768
            Managed Standby Recovery not using Real Time Apply
            parallel recovery started with 3 processes
            Mon Feb 25 07:49:07 2013
            Errors in file e:\oracle\product\10.2.0\admin\wplqdm\bdump\wplqdm_mrp0_4768.trc:
            ORA-00313: Message 313 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1]
            ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [J:\ORADATA\WPLQDM\REDO01_3.RDO]
            ORA-27041: Message 27041 not found; No message file for product=RDBMS, facility=ORA
            OSD-04002: unable to open file
            O/S-Error: (OS 2) The system cannot find the file specified.
            ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1]
            ORA-27041: Message 27041 not found; No message file for product=RDBMS, facility=ORA
            OSD-04002: unable to open file
            O/S-Error: (OS 2) The system cannot find the file specified.
            ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [E:\ORADATA\WPLQDM\REDO01_1.RDO]
            ORA-27041: Message 27041 not found; No message file for product=RDBMS, facility=ORA
            OSD-04002: unable to open file
            O/S-Error: (OS 2) The system cannot find the fil

            Mon Feb 25 07:49:07 2013
            Errors in file e:\oracle\product\10.2.0\admin\wplqdm\bdump\wplqdm_mrp0_4768.trc:
            ORA-00313: Message 313 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1]
            ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [J:\ORADATA\WPLQDM\REDO01_3.RDO]
            ORA-27041: Message 27041 not found; No message file for product=RDBMS, facility=ORA
            OSD-04002: unable to open file
            O/S-Error: (OS 2) The system cannot find the file specified.
            ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [I:]
            ORA-27041: Message 27041 not found; No message file for product=RDBMS, facility=ORA
            OSD-04002: unable to open file
            O/S-Error: (OS 2) The system cannot find the file specified.
            ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [E:\ORADATA\WPLQDM\REDO01_1.RDO]
            ORA-27041: Message 27041 not found; No message file for product=RDBMS, facility=ORA
            OSD-04002: unable to open file
            O/S-Error: (OS 2) The system cannot find the fil

            Clearing online redo logfile 1 E:\ORADATA\WPLQDM\REDO01_1.RDO
            Clearing online log 1 of thread 1 sequence number 5937
            Mon Feb 25 07:49:07 2013
            Errors in file e:\oracle\product\10.2.0\admin\wplqdm\bdump\wplqdm_mrp0_4768.trc:
            ORA-00313: Message 313 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1]
            ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [J:\ORADATA\WPLQDM\REDO01_3.RDO]
            ORA-27041: Message 27041 not found; No message file for product=RDBMS, facility=ORA
            OSD-04002: unable to open file
            O/S-Error: (OS 2) The system cannot find the file specified.
            ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [I:]
            ORA-27041: Message 27041 not found; No message file for product=RDBMS, facility=ORA
            OSD-04002: unable to open file
            O/S-Error: (OS 2) The system cannot find the file specified.
            ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [E:\ORADATA\WPLQDM\REDO01_1.RDO]
            ORA-27041: Message 27041 not found; No message file for product=RDBMS, facility=ORA
            OSD-04002: unable to open file
            O/S-Error: (OS 2) The system cannot find the fil

            Mon Feb 25 07:49:07 2013
            Errors in file e:\oracle\product\10.2.0\admin\wplqdm\bdump\wplqdm_mrp0_4768.trc:
            ORA-19527: Message 19527 not found; No message file for product=RDBMS, facility=ORA
            ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [E:\ORADATA\WPLQDM\REDO01_1.RDO]

            Clearing online redo logfile 1 complete
            Media Recovery Waiting for thread 1 sequence 5949
            Mon Feb 25 07:49:07 2013
            Completed: alter database recover managed standby database disconnect
            Mon Feb 25 08:03:11 2013
            db_recovery_file_dest_size of 30000 MB is 7.80% used. This is a
            user-specified limit on the amount of space that will be used by this
            database for recovery-related files, and does not reflect the amount of
            space available in the underlying filesystem or ASM diskgroup.
            • 3. Re: Reg : no rfs background processor in standby
              Sunny kichloo
              How did you create your standby database ??

              Also what is the value of this parameter in your standby database??

              db_file_name_convert and log_file_name_convert.


              Also check this

              open failed for members of log group

              http://osamamustafa.blogspot.in/2012/10/ora-00313-ora-00312-open-failed-for.html
              • 4. Re: Reg : no rfs background processor in standby
                mseberg
                Hello;

                Do your redo files exist here :

                J:\ORADATA\WPLQDM\

                Can you confirm this?

                Does J:\ORADATA\WPLQDM\ existing on the standby server and does the Oracle user have write permission to that location?

                Does that location have enough free space?


                Best Regards

                mseberg