RMAN Backup purges old archived redo logs even after changing the archive log destination. It is interesting to note that this is automatically taken care of. We start this process with the assumption that archival log destination has lot of archives. If not perform a log switch that automatically generates the archives
1) Log into datbaase and perform a clean shutdown of database
shutdown immediate;
2) In our case I make use of init.ora file. I’m going to change the value of log_archive_destination from its present value to another value
log_archive_dest=
3) Bring back the instance
startup
4) Confirm the value of log_archive_dest as follows
show parameter log_archive_dest
5) Now perform a log switch and make sure that archives are generated in new destination
alter system switch logfile;
6) Perform a full backup of database using rman utility
rman target username/password@sid
backup database;
backup archivelog all delete all input; — This command will purge all the old archives and new archives.
This is a clean implementation of RMAN. It is interesting to know that RMAN does a browsing of control file to locate the old log destination and automatically purges them
FOOD
ASTROLOGY
