This content has been marked as final. Show 3 replies
New to Oracle and recently inherited an Oracle database server that is in archivelog mode but has not had a full backup since the middle of May when the last DBA quit. I checked the archivelog folder and there is almost 500 archivelog files (approx. 18gb). I of course need to start backing up and planned on running the script below to clear out the logs.
Anyone know if there would be any issues with backing up the database and a large amount of archivelogs?
crosscheck archivelog all;
delete noprompt expired achivelog;
delete noprompt expired backup;
backup database as compressed backupset format 'H:\RMANBACKUP\RMAN%d_DB_%u_%s_%p.bkp';
BACKUP archivelog all format 'E:\RMAN_FULL_BKP\RMAN\%d_DB_%u_%s_%p' delete input;