This discussion is archived
8 Replies Latest reply: May 21, 2013 8:45 PM by 777435 RSS

delete backup

777435 Newbie
Currently Being Moderated
Hi,
Dears,
I deleted all my RMAN backup with delete backup command .but when i run query on v$rman_backup_job_details, show information, i don't know that v$rman_backup_job_details read data from where?
and how to delete complete that v$rman_backup_job_details don't show any thing?


Best Regards and thank
Hassan
  • 1. Re: delete backup
    rarain Explorer
    Currently Being Moderated
    Hi,

    RMAN delete backup command delete all backup information from controlfile repository as well as RMAN backup files physically. Can you please share what information you are getting in v$rman_backup_job_details.

    Thanks
  • 2. Re: delete backup
    777435 Newbie
    Currently Being Moderated
    select session_key,
           input_type,
           status,
           to_char(start_time,'yyyy-mm-dd hh24:mi') start_time,
           to_char(end_time,'yyyy-mm-dd hh24:mi')   end_time,
           output_bytes_display,
           time_taken_display
    from v$rman_backup_job_details
    order by session_key asc;
    
    result:
    
           SESSION_KEY     INPUT_TYPE     STATUS     START_TIME     END_TIME     OUTPUT_BYTES_DISPLAY     TIME_TAKEN_DISPLAY
    1     4       DB INCR     COMPLETED     2013-05-16 08:20     2013-05-16 10:19        22.48G     01:59:51
    2     15     DB INCR     FAILED             2013-05-19 19:54     2013-05-19 19:59       166.06M     00:04:44
    3     17     DB INCR     COMPLETED     2013-05-20 08:47     2013-05-20 10:06         4.14G     01:19:02
    4     22     DB INCR     COMPLETED     2013-05-20 10:41     2013-05-20 10:54       674.73M     00:12:59
    5     32     DB INCR     COMPLETED     2013-05-20 11:15     2013-05-20 13:15        22.74G     02:00:19
    6     42     DB INCR     FAILED             2013-05-20 15:20     2013-05-20 15:20         0.00K     00:00:02
    7     44     DB INCR     COMPLETED     2013-05-20 15:21     2013-05-20 15:33       151.83M     00:11:39
    8     49     DB INCR     COMPLETED     2013-05-21 09:14     2013-05-21 09:32         1.98G     00:17:58
  • 3. Re: delete backup
    rarain Explorer
    Currently Being Moderated
    Hi,

    This is the output of last run RMAN backup jobs and if you see the status column its either failed or completed, no one is in running state.

    Thanks
  • 4. Re: delete backup
    rarain Explorer
    Currently Being Moderated
    Hi,

    This is the output of last run RMAN backup jobs and if you see the status column its either failed or completed, no one is in running state.

    Thanks
  • 5. Re: delete backup
    777435 Newbie
    Currently Being Moderated
    Hi,
    Thank for your not, but how to clear this history?

    Br/Hassan
  • 6. Re: delete backup
    DK2010 Guru
    Currently Being Moderated
    Hi,

    You can use the following command. May it help you
    SYS.DBMS_BACKUP_RESTORE.resetCfileSection(28);
    Doc Ref:http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmtroub.htm
  • 7. Re: delete backup
    rarain Explorer
    Currently Being Moderated
    Hi,

    v$rman_backup_job_details is basically a synonym which is based on dynamic view prefix with v_$rman_backup_job_details and these dynamic view is based on dynamic tables prefix with X$ and these dynamic tables are created at nomount and mount and it is automatically maintained and updated by Oracle and Oracle doesn't allow to perform manual DML operation on these tables but as suggested using this function (SYS.DBMS_BACKUP_RESTORE.resetCfileSection(28);) you can delete all previous RMAN job history.

    http://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmtroub.htm#i1008552

    Thanks

    Edited by: rarain on May 21, 2013 4:42 PM
  • 8. Re: delete backup
    777435 Newbie
    Currently Being Moderated
    Thank you for your support.

Legend

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