Re: Rman

Re: Rman

 

  

My prefered method is to delete right after backup using "DELETE INPUT"
option.

RMAN> BACKUP ARCHIVELOG ALL DELETE INPUT;

Or if you have old archive log files which have been backed up already,
use following command to delete the files which have been backed up
twice.

RMAN> DELETE ARCHIVELOG ALL BACKED UP 2 TIMES TO DEVICE TYPE sbt;

If you have removed archive files from OS use CROSSCHECK command to re-
sync the controle file or your repository if you are using RMAN with
catalog option.

RMAN> CROSSCHECK BACKUP;

all this is described in detail in CHAPTER-4 of "OracleŽ Database
Backup and Recovery Advanced User's Guide"


Niaz Hoda
http://www.appfiniti.com




> Hello,
> Can anyone tell me rman script to automatically delete the archived
> logs after backup is done. In 9i RAC.
> Thank you
>
> Abdul Wahab
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
terms:http://www.lazydba.com/legal.html
>
>
>



Oracle LazyDBA home page