see RMAN effective use see Rman - Quering catalog see how to create catalog see Legato for required parameters and configuration
Clean way allocate channel for maintenance device type 'SBT_TAPE' ; allocate channel for maintenance device type disk; delete force noprompt archivelog all completed before 'sysdate-30'; delete force noprompt backup completed before 'sysdate-30'; release channel; #for rman clients < 9.2.0.5 manually launch @?/rdbms/admin/prgrmanc to clean RLH table #the script must be >= 9.2.0.5 |
delete from rlh where rlh_key in ( select rlh.rlh_key from rlh, al where al.thread# (+)= rlh.thread# and al.sequence# (+)= rlh.sequence# and al.low_scn (+)= rlh.low_scn and al.dbinc_key (+)= rlh.dbinc_key and al_key is null ) |