archive log maintenance on standby db
On my standby db I want to use rman for backups and to have rman also manage the arch logs and delete the from disk as well. I want to ensure however that it does not try and delete an arch log that is concurrently being accessed (in the process of being applied to the standby) Might I avoid this by using something like the following
to that I would not whack an archive log whilst it is being applied?
With the following I would expect all archive logs to stay on disk for two days and then be backed up to an rman set with the arch logs on disk then being deleted.
Does it look copasetic?
BACKUP ARCHIVELOG UNTIL TIME 'SYSDATE-2';
DELETE COPY OF ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-2';
I'm stmontgo and I approve of this message