Find and remove backup jobs in Oracle 10g databases
Posted on 2008-06-25
We have two Oracle databases (Oracle 10g) running on one of our servers. There are one or more online backup jobs configured to run on these databases, but the backup jobs do not show up in OEM. I know for a fact, however, that these jobs are running, because file shows up in the flash_recovery_areas for these databases every day. The problem is that the consultant that configured these jobs was supposed to configure them to be self-managing (i.e. only the files necessary to do a complete restore would be kept; obsolete files would automatically be deleted from the flash recovery area. However, it appears that these jobs just continue until the FRA is full, and then the application servers start giving us problems. So my questions are as follows:
1. Why are these jobs not listed in OEM?
2. How do I find a list of all currently configured backup jobs for each database? I'm assuming this is done through the RMAN command line, but I'm not really familiar with that tool.
3. How do I delete the jobs completely? Do I also have to manually delete all the files in the FRA? I would like to delete these jobs and then reconfigure them using OEM and/or the Oracle Agent in Symantec Backup Exec 12.