1 2 Previous Next 25 Replies Latest reply: Feb 13, 2013 1:43 PM by 864103 Go to original post RSS
      • 15. Re: background dump
        [oracle@ccbs01 bin]$ ./adrci
        ADRCI: Release - 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
          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
            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
              Read this
              • 19. Re: background dump
                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
                  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
                    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
                      do you have any errors in alert ?
                      • 23. Re: background dump
                        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
                          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
                            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