This discussion is archived
7 Replies Latest reply: May 16, 2012 12:39 AM by anand prakash - oracle RSS

Archivelog Question on Oracle 11g

653123 Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    Disable archive 10 using parameter log_archove_dest_state_10
  • 4. Re: Archivelog Question on Oracle 11g
    EdStevens Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    What happens If all Archive destinations are full?
  • 7. Re: Archivelog Question on Oracle 11g
    anand prakash - oracle Pro
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points