This discussion is archived
1 2 Previous Next 25 Replies Latest reply: Feb 13, 2013 11:43 AM by 864103 Go to original post RSS
  • 15. Re: background dump
    864103 Newbie
    Currently Being Moderated
    [oracle@ccbs01 bin]$ ./adrci
    
    ADRCI: Release 11.2.0.2.0 - Production on Tue Feb 12 23:07:11 2013
    
    Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.
    
    ADR base = "/home/app/oracle"
    adrci> show control
    DIA-48448: This command does not support multiple ADR homes
  • 16. Re: background dump
    864103 Newbie
    Currently Being Moderated
    adrci> set homepath diag/rdbms/absnl/ABSNL1
    adrci> purge -age 8640 -type TRACE
    adrci> show control
    
    ADR Home = /home/app/oracle/diag/rdbms/absnl/ABSNL1:
    *************************************************************************
    ADRID                SHORTP_POLICY        LONGP_POLICY         LAST_MOD_TIME                            LAST_AUTOPRG_TIME                        LAST_MANUPRG_TIME                        ADRDIR_VERSION       ADRSCHM_VERSION      ADRSCHMV_SUMMARY     ADRALERT_VERSION     CREATE_TIME
    -------------------- -------------------- -------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- -------------------- -------------------- -------------------- -------------------- ----------------------------------------
    2900013389           720                  8760                 2012-03-15 20:00:19.223051 +03:00        2013-02-05 02:32:12.833854 +03:00        2013-02-12 23:20:01.844467 +03:00        1                    2                    80                   1                    2012-03-15 20:00:19.223051 +03:00
    1 rows fetched
    
    adrci> exit
    [oracle@ccbs01 bin]$ df -h
    Filesystem            Size  Used Avail Use% Mounted on
    /dev/cciss/c0d0p9      48G   45G     0 100% /home
    
    [oracle@ccbs01 bin]$
    why it's not work .
  • 17. Re: background dump
    sb92075 Guru
    Currently Being Moderated
    Your disk is full so you blindly decide that ADRCI is the solution.
    This is like picking up a hammer when you find your basement full of water.
    It appears that you need to different solution to free up disk space.

    If you actually knew which files caused the disk to fill up in the first place,
    you might be able to determine how to stop the disk from filling up in the first place;
    instead of just hoping to delete them after they get created.
  • 18. Re: background dump
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Read this
    http://www.databasejournal.com/features/oracle/article.php/3875896/Purging-Oracle-Databases-Alert-Log-with-ADRCI---Usage-and-Warning.htm
  • 19. Re: background dump
    864103 Newbie
    Currently Being Moderated
    now it's working , but i don't know til know why it's writing more data in alert log file .
  • 20. Re: background dump
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    861100 wrote:
    now it's working , but i don't know til know why it's writing more data in alert log file .
    What you mean by More Data , Oracle will Recreate Alert log even you deleted .
  • 21. Re: background dump
    864103 Newbie
    Currently Being Moderated
    i have 2 nodes , i check the first node where is no issue i mena when i check the /home which contain the alert and trace is 40% and after 8 hour
    it's same but the second node it is full in 2 hour also i delete the trace file and alert log file and oracle generate new alert its full
    in 2 hour the /home is full .
  • 22. Re: background dump
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    do you have any errors in alert ?
  • 23. Re: background dump
    Dropbear67 Newbie
    Currently Being Moderated
    change diagnostic_dest parameter to a file system with more space.. This will give you some more time to sort out the errors, and apply the patch that has been recommended.

    a 25GB alert log file is ridiculous.
  • 24. Re: background dump
    864103 Newbie
    Currently Being Moderated
    no there is no error in alert log it's just wroring

    can i retention the alert log and trace file

    ex: if the alert log and trace file reach 1GB overwrite so i can avoid any issue and the alert and trace file not more than 1 GB ???
  • 25. Re: background dump
    864103 Newbie
    Currently Being Moderated
    thanks for all expert here i check with oracle support this is bug must upgrade my database ,
    this is will be good exercise to me.
1 2 Previous Next

Legend

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