Solved

Find and remove backup jobs in Oracle 10g databases

Posted on 2008-06-25
2
762 Views
Last Modified: 2013-12-18
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.

Thanks!
0
Comment
Question by:I_play_with_DNA
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 29

Accepted Solution

by:
MikeOM_DBA earned 500 total points
ID: 21868845
1) They should appear in OEM, check DBA_JOBS view from SQL*Plus.
2) RMAN jobs are in the DB, not the Catalog.
3) Depends, but maybe using the DBMS_JOB() package.
You can manually delete those backup files (easier than doing it with RMAN).
0
 

Author Comment

by:I_play_with_DNA
ID: 21881099
@MikeOM_DBA

Can you provide more detail on how to do this?  I'm not a DBA.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
oracle- set role and grant privileges 6 51
why truncate is faster than delete in oracle ? 4 50
pl/sql parameter is null sometimes 2 25
how to tune the query 17 59
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Via a live example, show how to take different types of Oracle backups using RMAN.
This video shows how to recover a database from a user managed backup

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question