5 Replies Latest reply: Apr 10, 2014 2:00 PM by mseberg RSS

    ORA-00254 - ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE;

    873410

      Hello,

       

      I created the logical standby database.

      I used the document "http://docs.oracle.com/cd/B19306_01/server.102/b14239/create_ls.htm"

       

      So, after a I open with resetlogs the logical standby, I try to start the Log apply with:

       

      ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE;

       

      But this command returns:

       

      ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE

      *

      ERROR at line 1:

      ORA-00254: error in archive control string ''

      ORA-06512: at "SYS.DBMS_INTERNAL_LOGSTDBY", line 625

      ORA-06512: at line 1

       

      My configuration of log archive is:

       

      NAME                                 TYPE        VALUE

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

      log_archive_config                   string      DG_CONFIG=(PROD, STBY)

      log_archive_dest_1                   string      LOCATION=+ORAFRA VALID_FOR=(ONLINE_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=STBY

      log_archive_dest_2                   string      SERVICE=PROD LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=PROD

      log_archive_dest_3                   string      LOCATION=+ORADATA VALID_FOR=(STANDBY_LOGFILES,STANDBY_ROLE) DB_UNIQUE_NAME=STBY

       

      log_archive_dest_state_1             string      ENABLE

      log_archive_dest_state_2             string      ENABLE

      log_archive_dest_state_3             string      ENABLE

       

      fal_client                           string      STBY

      fal_server                           string      PROD

       

      The db_name is correct. I updated this parameter with:

       

      ALTER DATABASE RECOVER TO LOGICAL STANDBY STBY; (the Oracle document).

       

       

      Somebody can help me?

       

      Thank you very much!!!!

        • 1. Re: ORA-00254 - ALTER DATABASE RECOVER TO LOGICAL STANDBY STBY
          mseberg

          Hello;

           

          Oracle thinks your archive log location is invalid.

           

          Double check and try again.

           

          Best Regards

           

          mseberg

          • 2. Re: ORA-00254 - ALTER DATABASE RECOVER TO LOGICAL STANDBY STBY
            873410

            Hello mseberg,

             

            Well, I checked the destination. Its everything OK.

            There is space into diskgroups. The diskgroups are mounted.

            The problem continues....

             

            Thank you!

            • 3. Re: ORA-00254 - ALTER DATABASE RECOVER TO LOGICAL STANDBY STBY
              mseberg

              Any chance that STANDBY_ARCHIVE_DEST is set?

               

              Are the redo and standby redo the same size?

               

              Best Regards

               

              mseberg

              • 4. Re: ORA-00254 - ALTER DATABASE RECOVER TO LOGICAL STANDBY STBY
                873410

                Hello,

                 

                Yes, Its set:

                 

                SQL> show parameter standby

                 

                NAME                                 TYPE        VALUE

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

                standby_archive_dest                 string      LOCATION=USE_DB_RECOVERY_FILE_DEST

                standby_file_management              string      AUTO

                 

                The redo logs and standby logs are the same size:

                 

                 

                SQL> select * from v$log order by 1;

                 

                GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS  FIRST_CHANGE# FIRST_TIM

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

                     1          1          1   52428800          1 NO  CURRENT        638986 09-APR-14

                     2          1          0   52428800          1 YES UNUSED              0

                     3          2          1   52428800          1 YES ACTIVE         638986 09-APR-14

                     4          2          0   52428800          1 YES UNUSED              0

                 

                SQL> select * from v$standby_log;

                 

                GROUP# DBID          THREAD#  SEQUENCE#    BYTES USED ARC STATUS     FIRST_CHANGE# FIRST_TIM LAST_CHANGE# LAST_TIME

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

                     5 1409006138          1          8 52428800 7680 YES ACTIVE            638995 09-APR-14            0 10-APR-14

                     6 UNASSIGNED          1          0 52428800  512 NO  UNASSIGNED             0                      0

                     7 UNASSIGNED          1          0 52428800  512 YES UNASSIGNED             0                      0

                     8 UNASSIGNED          1          0 52428800  512 YES UNASSIGNED             0                      0

                     9 UNASSIGNED          1          0 52428800  512 YES UNASSIGNED             0                      0

                    10 1409006138          2          8 52428800 8704 YES ACTIVE            638993 09-APR-14            0 10-APR-14

                    11 UNASSIGNED          2          0 52428800  512 NO  UNASSIGNED             0                      0

                    12 UNASSIGNED          2          0 52428800  512 YES UNASSIGNED             0                      0

                    13 UNASSIGNED          2          0 52428800  512 YES UNASSIGNED             0                      0

                    14 UNASSIGNED          2          0 52428800  512 YES UNASSIGNED             0                      0

                 

                Thank you!

                • 5. Re: ORA-00254 - ALTER DATABASE RECOVER TO LOGICAL STANDBY STBY
                  mseberg

                  I hope I did not miss this, but what is "DB_RECOVERY_FILE_DEST" set to?

                   

                  Does V$ARCHIVE_DEST offer any clue?

                   

                  Best Regards

                   

                  mseberg