7 Replies Latest reply: May 16, 2012 2:39 AM by anand prakash - oracle RSS

    Archivelog Question on Oracle 11g

    653123
      Hi, All -

      Oracle 11g on RHEL4

      What is the difference between these two files: o1_mf_1_4343_4wsz7olb_.arc and arch1_4343_678636531.dbf

      Oracle is creating same file at two different locations with different names. One is arch***.dbf and one is ***.arc

      dallinux161 oraedw ccedw > pwd
      /orahome10/ccedwdb/flash_recovery_area/CCEDW/archivelog/2009_03_27
      dallinux161 oraedw ccedw > ls
      o1_mf_1_4343_4wsz7olb_.arc o1_mf_1_4344_4wt0h3wc_.arc
      dallinux161 oraedw ccedw >


      dallinux161 oraedw ccedw > pwd
      /orahome10/ccedwdb/11.1/dbs
      -rw-r----- 1 oraedw oinstall 47805440 Mar 27 10:21 arch1_4343_678636531.dbf
      -rw-r----- 1 oraedw oinstall 3140608 Mar 27 10:42 arch1_4344_678636531.dbf
        • 1. Re: Archivelog Question on Oracle 11g
          Lukasz Mastalerz
          I assume you are archiving into two destinations (using FRA as one of them), and using OMF? Check your archive_log_dest_n params. If so, files contain exactly the same information inside. Names are generated automatically by OMF
          • 2. Re: Archivelog Question on Oracle 11g
            653123
            I ran the following:

            SQL> select dest_id,destination from v$archive_dest;

            DEST_ID
            ----------
            DESTINATION
            --------------------------------------------------------------------------------
            1
            /orahome10/ccedwdb/11.1/dbs/arch

            DEST_ID
            ----------
            DESTINATION
            --------------------------------------------------------------------------------
            10
            USE_DB_RECOVERY_FILE_DEST


            Can I store the files in only one location? What do I need to do to get rid of the second location?
            • 3. Re: Archivelog Question on Oracle 11g
              Lukasz Mastalerz
              Disable archive 10 using parameter log_archove_dest_state_10
              • 4. Re: Archivelog Question on Oracle 11g
                EdStevens
                ORA_UMAIR wrote:
                I ran the following:

                SQL> select dest_id,destination from v$archive_dest;

                DEST_ID
                ----------
                DESTINATION
                --------------------------------------------------------------------------------
                1
                /orahome10/ccedwdb/11.1/dbs/arch

                DEST_ID
                ----------
                DESTINATION
                --------------------------------------------------------------------------------
                10
                USE_DB_RECOVERY_FILE_DEST


                Can I store the files in only one location? What do I need to do to get rid of the second location?
                Now that you see the parameters, you might want to go to The Fine Manual (Reference Manual, located with the rest of the docs at tahiti.oracle.com) and read up on what they do.

                Only one archivelog for each log sequence will be written to a given specified location. It won't write two copies of the same file to a single location. While only one location is required to run in archivelog mode, having two (or more) locations - and thus two (or more) copies of each archivelog sequence - gives you another layer of defense against loss of critical files.
                • 5. Re: Archivelog Question on Oracle 11g
                  653123
                  I ran the following to disable the Secondary Archivelog Destination.

                  SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_1=DEFER;

                  System altered.


                  Thank You for your help!
                  • 6. Re: Archivelog Question on Oracle 11g
                    937614
                    What happens If all Archive destinations are full?
                    • 7. Re: Archivelog Question on Oracle 11g
                      anand prakash - oracle
                      Hi,

                      It would be better if you open a new thread and ask your queries there. For now, if archivelog destination is full, database hangs.

                      Anand