5 Replies Latest reply: Jan 6, 2014 6:28 AM by Eduardo Legatti RSS

    standby instance throwing error

    955912

      when trying to startup standby instance , i am getting error :

       

      SQL> startup pfile='/home/oracle/dummy/admin/pfile/initdummy.ora' nomount;

      ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes

      SQL>

       

       

      db_name=org

      compatible=10.2.0

      sga_target=1000m

      control_files='/home/oracle/dummy/oradata/control1.ctl'

      background_dump_dest='/home/oracle/dummy/admin/bdump/'

      core_dump_dest='/home/oracle/dummy/admin/cdump/'

      user_dump_dest='/home/oracle/dummy/admin/udump/'

      fal_server=org

      fal_client=dummy

      db_unique_name=dummy

      standby_file_management=auto

      remote_login_passwordfile='exclusive'

      db_file_name_convert='/home/oracle/org/oradata/','/home/oracle/dummy/oradata/'

      log_file_name_convert='/home/oracle/org/oradata/','/home/oracle/dummy/oradata/'

      log_archive_dest_1='location=/home/oracle/dummy/oradata/arch/'

      log_archive_dest_2='service=org'

      ~

      ~

      ~

        • 1. Re: standby instance throwing error
          Karan Kukreja

          Hi,

           

          Is there any other entry for log_archive_dest_2 ?


          Grep and share the output


          regards

          karan

          • 2. Re: standby instance throwing error
            955912

            now i can startup my standby instance but  getting some error.

             

            SQL> startup pfile='/home/oracle/dummy/admin/pfile/initdummy.ora' nomount;

            ORACLE instance started.

             

            Total System Global Area 1048576000 bytes

            Fixed Size                  1223344 bytes

            Variable Size             255853904 bytes

            Database Buffers          784334848 bytes

            Redo Buffers                7163904 bytes

            SQL> alter database mount standby database;

             

            Database altered.

             

            SQL> alter database  recover managed standby database disconnect from session;

             

            Database altered.

             

            SQL> select sequence#,applied from v$archived_log order by 1;

             

            SEQUENCE# APP

            ---------- ---

                     9 NO

                    10 NO

                    11 NO

                    12 NO

                    13 NO

                    14 NO

                    15 NO

                    16 YES

                    17 YES

             

            9 rows selected.

             

            but stand by alert log showing following error :

             

            bash-3.2$ tail -f alert_dummy.log

            ORA-00312: online log 2 thread 1: '/home/oracle/dummy/oradata/log2.log'

            ORA-27037: unable to obtain file status

            Linux Error: 2: No such file or directory

            Additional information: 3

            Mon Jan  6 16:21:52 2014

            Completed: alter database  recover managed standby database disconnect from session

            Mon Jan  6 16:21:52 2014

            Clearing online redo logfile 2 complete

            Media Recovery Log /home/oracle/dummy/oradata/arch/1_17_836141614.dbf

            Media Recovery Waiting for thread 1 sequence 18

            Mon Jan  6 16:22:28 2014

            Errors in file /home/oracle/dummy/admin/bdump/dummy_arc1_8621.trc:

            ORA-16009: remote archive log destination must be a STANDBY database

            Mon Jan  6 16:22:28 2014

            PING[ARC1]: Heartbeat failed to connect to standby 'org'. Error is 16009.

            • 3. Re: standby instance throwing error
              Shivananda Rao

              Hello,

               

              Looks like you are on 10g. Have you set the "standby_archive_dest" parameter on the standby database ?

               

               

              Regards,
              Shivananda

              • 4. Re: standby instance throwing error
                JohnWatson

                It looks as though you are trying to set up Data Guard the way one did it back with release 8.1. You need to set a few more attributes for log_archive_dest_2. The problem you have just raised is because you haven't set the VALID_FOR attribute.

                • 5. Re: standby instance throwing error
                  Eduardo Legatti

                  Hi,

                   

                  log_archive_dest_2='service=org'

                   

                  The right way as far I know is set like below: (Just an example)

                   

                  alter system set log_archive_dest_2='service=ORG lgwr async valid_for=(online_logfiles,primary_role) db_unique_name=ORG';

                   

                   

                  Are you sure that you configure the standby correctly?

                  ORA-16009: remote archive log destination must be a STANDBY database

                   

                  Cause:     The database associated with the archive log destination service
                       name is other than the required STANDBY type database. Remote
                       archival of redo log files is not allowed to non-STANDBY database
                       instances.
                  Action:     Take the necessary steps to create the required compatible
                       STANDBY database before retrying the ARCHIVE LOG processing.

                   

                  Cheers

                   

                  Legatti