Archive log deletion
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
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.
"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..
you can use
BACKUP ARCHIVELOG ALL DELETE INPUT;
this will automatically delete all the logs
As an alternative you can use the following commands:
rman> crosscheck archivelog;
rman> delete force noprompt archivelog all;
Click Here to Expand Forum to Full Width