Hi,

I know this is a trivial quesiton but I cant seem to get the information I require using the rman list command. Think Im using it wrong or with the wrong parameters. Basicaly what I would like to do is get a listing of all the active datafiles in the rman catalog.

I would like to use this information to identify old backupfiles that are not in the catalog for some reason and remove them.

If anyone could help it would be much appreciated.

Thanks,
Stanton.

(Oh yeah if anyone would like to throw in the command to delete obsolete arch log file that are more then 30 days old please feel free :)).