Thursday, December 2, 2010

cvg manage

cvg apollo server machine

emca -config dbcontrol db



---------------

rman> target sys/sys

rman>list archivelog all;

(note that in listener.ora, the host=apollo)

rman>crosscheck backup;

rman> delete expired backup;

rman>delete obsolete;

-------------------------------------------------

THIS GAINED 34 GIG (april 2010):

rman>backup archivelog until time 'sysdate-7'; (might try a lower number here so as not to temporarily fill the drive)

rman>delete copy of archivelog all completed before 'sysdate-7'; (might use the same lower number here)