how to delete archive log file (rman 8.1.7.4)
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: how to delete archive log file (rman 8.1.7.4)

  1. #1
    Join Date
    Mar 2003
    Posts
    8

    how to delete archive log file (rman 8.1.7.4)

    I have been using following code for level0 archive log RMAN backup on oracle 8.1.7.4. All archived log files are backing up on the disk. I would like to know the best way to delete them from the disk.

    sql 'alter system archive log current';
    backup
    filesperset 20
    format '/BACKUP/db1/rman/archive/db1_al_t%t_s%s_p%p'
    archivelog all
    delete input;


    I tried following rman commands but these does not delete archive logs files from the disk or changed the status. List backup is showing all pervious backup with available status.

    allocate channel for maintenance type disk;
    crosscheck backupset of database;
    delete expired backupset;
    delete expired backup of archivelog all;
    release channel;

    Any suggestions?

    Thanks,
    Puneet

  2. #2
    Join Date
    May 2001
    Posts
    736
    Search the forum there are lot of questions on this topic and also the scripts.

  3. #3
    Join Date
    Jul 2001
    Location
    Slovenia
    Posts
    422

    Re: how to delete archive log file (rman 8.1.7.4)

    Originally posted by puneet1
    backup
    filesperset 20
    format '/BACKUP/db1/rman/archive/db1_al_t%t_s%s_p%p'
    archivelog all
    delete input;
    This command should delete the archived logs when they are backed up.
    Tomaž
    "A common mistake that people make when trying to design something completely
    foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams

  4. #4
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938

    Re: how to delete archive log file (rman 8.1.7.4)

    Originally posted by puneet1
    I have been using following code for level0 archive log RMAN backup on oracle 8.1.7.4. All archived log files are backing up on the disk. I would like to know the best way to delete them from the disk.

    sql 'alter system archive log current';
    backup
    filesperset 20
    format '/BACKUP/db1/rman/archive/db1_al_t%t_s%s_p%p'
    archivelog all
    delete input;


    I tried following rman commands but these does not delete archive logs files from the disk or changed the status. List backup is showing all pervious backup with available status.

    allocate channel for maintenance type disk;
    crosscheck backupset of database;
    delete expired backupset;
    delete expired backup of archivelog all;
    release channel;

    Any suggestions?

    Thanks,
    Puneet
    Example:

    change archivelog until time 'sysdate-2' delete;

    deletes all archive logs older than 48 hours.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g
    email: ocp_9i@yahoo.com

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