DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Archive Log Creation Creating Trace File

  1. #1
    Join Date
    Jan 2001
    Posts
    515

    Archive Log Creation Creating Trace File

    I have a 9.2.0.3 database on Solaris and I noticed that everytime an archive log is created it is creating a trace file in my bdump directory just saying that the logs were created. Why does it do that?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    and the contents are?

  3. #3
    Join Date
    Jan 2001
    Posts
    515

    Here is a sample

    This is the contents of one of the files. I have changed the name of the database:

    $ cat mydb01_arc0_28718.trc
    /AML/oradata/MYDB01/TRACE/bdump/mydb01_arc0_28718.trc
    Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release 9.2.0.3.0 - Production
    ORACLE_HOME = /prodora01/app2/product/9.2.0
    System name: SunOS
    Node name: cmmpds051
    Release: 5.9
    Version: Generic_118558-38
    Machine: sun4u
    Instance name: MYDB01
    Redo thread mounted by this instance: 1
    Oracle process number: 10
    Unix process pid: 28718, image: oracle@cmmpds051 (ARC0)

    *** SESSION ID:(9.1) 2008-04-28 01:24:27.100
    - Created archivelog as '/AML/oradata/MYDB01/arch/ARCH_MYDB0126925_1.arc'
    - Created archivelog as '/AML/oradata/MYDB01/arch/ARCH_MYDB0126927_1.arc'
    - Created archivelog as '/AML/oradata/MYDB01/arch/ARCH_MYDB0126929_1.arc'
    - Created archivelog as '/AML/oradata/MYDB01/arch/ARCH_MYDB0126931_1.arc'
    - Created archivelog as '/AML/oradata/MYDB01/arch/ARCH_MYDB0126933_1.arc'

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width