Wednesday, December 31, 2008

NEW option in ADRCI purge acommand - UTSCDMP

NEW option in ADRCI purge acommand - UTSCDMP
There is new option in ADRCI for purge command - UTSCDMP


adrci> help purge

Usage: PURGE [[-i ]
[-age [-type ALERT INCIDENT TRACE CDUMP HM UTSCDMP]]]:

Purpose: Purge the diagnostic data in the current ADR home. If no
option is specified, the default purging policy will be used.

Options:
[-i id1 id1 id2]: Users can input a single incident ID, or a range of incidents to purge.
[-age ]: Users can specify the purging policy either to all the diagnostic data or the specified type. The data older than ago will be purged

[-type ALERT INCIDENT TRACE CDUMP HM UTSCDMP]:

Users can specify what type of data to be purged.
Examples:

purge
purge -i 123 456
purge -age 60 -type incident


There where some issue that directories cdmp_* in repositories (=$diagnostic_dest/Diag/rdbms/database_name/instance_name/bdump ) are not purging automatically. When you run following command, it remove cdmp_* directories, which is older the 3600 Minutes

adrci> purge -age 3600 -type UTSCDMP

3 comments:

  1. I am Amane Matsumoto. I am from Japan.
    I am makie-shi (Japanese lacquer artist) and shoka(Japanese calligrapher).
    I have spent my life working on traditional Japanese lacquer(urushi).
    I am the Kyoto style artist and I have samurai soul.
    I can make samurai maetate of Japanese helmets ,inro ,saya of Japanese sword ,gold Japanese lacquer boxes and so on.I have the highest skill in Japan.

    Japanese lacquer art is made with gold ,silver ,platinum and so on.
    The subjects I pick are very often nature.

    I admire Mr.Lawrence Joseph Ellison in every way.
    I am very happy that he research and learn
    about Japanese culture and arts like Zen.I think he is a true samurai.

    I'd like to ask him to become my patron.
    He must have been extra busy , but if he would not mind helping me get through this tough competition, that would be tremendously appreciated.
    I sent my work(sho) and the photograph of my work(urushi)to Oracle head office. But I hardly ever get back his reply.
    It may be that he doesn't get my photos and works.

    Could you help me?
    I'm at a loss. But I can not want to give up.
    I would like to contact him.
    I would like to go to America to meet him.
    I'd like to ask him to become my patron.
    I wish I could contact him somehow or other.
    Could you help me? My Email Address is spkv9xz9@yahoo.co.jp .

    Thank you so much for your kind reply.

    ReplyDelete
  2. Script for Purging ADR log and trace files automatically post as comment , script look good. I haven't tried yet. Here is script link

    http://jhdba.wordpress.com/2009/05/13/purging-adr-log-and-trace-files-automatically/


    Thanks jhdba

    ReplyDelete
  3. I am regular follower of your blog and I really like your posts. I like this post also. This is great achievement. I really appreciate your work. Thanks for sharing your experience with us. Keep it up. I am looking forward to see your work.
    sap support packs

    ReplyDelete

Google