No you always need a script. You could use RMAN also if you prefer, but on Oracle 10 it barks about the Archive since it thinks it has already removed it for the Primary.
Well, if I configure the archive deletion policy on standby database, in the future I don't need script to manually delete the archives on standby. Except any some error. Is this right?
If this is done whenever there is a space pressure in FRA all the archivelogs that are applied on standby database should be deleted.
1. ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY : RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY; 2. Enable the flash recovery area on the standby database so that all the archivelogs are shipped in the flash recovery area. 3. Make sure these are set on Standby : DB_RECOVERY_FILE_DEST DB_RECOVERY_FILE_DEST_SIZE