Archive log deletion
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Archive log deletion

Hybrid View

  1. #1
    Join Date
    Apr 2001
    Location
    Vadodara, India
    Posts
    249

    Archive log deletion

    Dear All,

    After tacking rman backup, i am deleting archivelog manual after that i am using following command :

    RMAN> Change Archivelog All Crosscheck;


    This command is taking too much time as it start from 1st archive log.

    Is there any other way ?

    Thanks in advance

    Nirav

  2. #2
    Join Date
    Nov 2005
    Location
    USA
    Posts
    32
    Why do you want to delete archives manually? You can achieve the same by including "delete input" rman command in your archive backup script eventually eliminating "Change Archivelog All Crosscheck"
    Last edited by sunil_kandi; 04-14-2009 at 11:35 AM.

  3. #3
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    "change archivelog all crosscheck" checks whether archive logs are present at their original location suggested by controlfile or rman catalog.
    It takes time because it checks every location from log sequence number 1.

    U can speed it up by allocating multiple channels but it will be useful if ur system has multiple CPUs....Wen u keep on crosschecking it regularly, u can reduce the time it takes to backup archive logs as oracle server doesnt unnecessarily go on to check validity of expired archivelogs...

    This is wat I think..
    lucky

  4. #4
    Join Date
    Apr 2008
    Location
    Bangalore
    Posts
    96
    you can use
    BACKUP ARCHIVELOG ALL DELETE INPUT;

    this will automatically delete all the logs

  5. #5
    Join Date
    Apr 2009
    Posts
    10
    As an alternative you can use the following commands:

    rman> crosscheck archivelog;

    rman> delete force noprompt archivelog all;

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