Automating archivelog deletion on RAC primary and unmanaged Standby database
edited Jan 13, 2014 8:37PM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 3 commentsAnswered
Hello,
We are running a 10.2.0.3 Standard Edition RAC with two nodes and have a manual/unmanaged standby database. As this is not data guard configuration due to being on Standard Edition we are not able to configure automatic archivelog deletion on Standby and primary through RMAN policies. We have created a FTP script that ships archivelogs from primary to standby and standby db applied them fine using scheduled cron.
We are having to delete archivelogs manually on primary and standby so I am looking for a method/script through RMAN that check applied archivelog sequence numbers for both nodes and deletes older (keeping last 30 archivelogs for both threads) archivelogs accordingly on both primary and standby.
0