Search

Join this Blog for direct reference of any post into your inbox. To join just click on "Join this Site" under "Follower" then Login with your Email.*** DECLARATION: I Maintain this Blog for Helping Myself While at Work and Welcome any body Needing Help!!!.*** CAUTION: Using any of the script from this Blog may contain at Own Risk. These scripts May or May not have been Tested.***

Wednesday, 4 March 2015

Monitoring RMAN Backup with QBR tools

The Quest Backup Reporter is a windows client application. It can connect too many databases at a time and reports directly from oracle data dictionary views and RMAN catalog. It does not make any modification to either database as well as RMAN configuration. It is just a read only reporting tools.
Quest Backup Reporter tools offers DBA a dashboard view of all oracle backup across one desktop view. Thus it is relatively easy for the DBA who is managing different database backup to check all the backup status at a time (on single screen) and to ensure the backup are valid and recoverable. QBR supports oracle version 9i onwards and OS Windows Server2003/XP/Vista/Win7/Win Server 2008 (32 or 64).
QBR requires .Net Framework ver. 2.0–3.5 for installation and does not require oracle client installation for operation: Download Quest Backup Reporter


You can register target database using the menu Data source –> Register New Data source to access the information either through Control file or the RMAN catalog.
Once the targets are registered then you are able to check time of the successful and failure backup as well as real time status of running backup.

You can define policies if you need to meet backup with certain criteria such as retention period of backup of different types (full, level 0 and other incremental backup, archive log backup) and within various backup type you can define the days of the week as well as maximum run time.
Once a policy has been applied to a target you can click on the violations tab to see the types and categories of violations.
The Backup tab gives overview of the database backup as well as details of the particular backup. If you have already added recovery catalog you can see additional details of registered database.
Another very useful feature of QBR is checking growth of the backup size corresponding to its duration and Timelines for each type of backup.
Note: If you register more databases to QBR will take longer time to load them. This could results catalog database to slow and some other issues because it is continuously querying on the registered database catalog. 

11 comments:

  1. Thank you for this valuable information. It was really helpful.

    school signs

    ReplyDelete
  2. Awesome resources!
    Thanks for sharing such good article.

    Top HR Consultancy In Bangalore

    ReplyDelete
  3. Great post.
    It really helped me to learn something new. So thanks.
    Software Maintenance and Support Services

    ReplyDelete
  4. This is an awesome post.Really very informative and creative contents. These concept is a good way to enhance the knowledge.I like it and help me to development very well.Thank you for this brief explanation and very nice information.Well, got a good knowledge.
    Isoft Innovations Adyar
    Isoft Innovations Facebook

    ReplyDelete
  5. Awesome resources!
    Thanks for sharing such good article. This is really helpful.

    Vintage Tiles
    Rustic Tiles
    Mosaic Tiles

    ReplyDelete
  6. You have posted Very good information to all readers .surely i am very much interested in reading this type of articles .keep posting more articles.

    ReplyDelete
  7. This is just the kind of information that I had been looking for a long time. Thank you very much for posting this blog it’s very nice.

    Oracle Fusion financial

    ReplyDelete

  8. Its a wonderful post and very helpful, thanks for all this information. You are including better information regarding this topic in an effective way.Thank you so much

    Personal Installment Loans
    Title Car loan
    Cash Advance Loan

    ReplyDelete