Skip to main content

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: 

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. 

Comments

Post a Comment

Popular posts from this blog

RMAN Different errors and their Solution

RMAN Different errors and their Solution Backup Fails with Invalid RECID Error: RMAN-20035, RMAN-6038 When you attempt a backup and receive the following error messages: RMAN-3014: Implicit resync of recovery catalog failed RMAN-6038: Recovery catalog package detected an error RMAN-20035: Invalid high RECID error It indicates the control file and the recovery catalog is not synchronized. RMAN detects that the control file currently in use is older than the control file previously used to resynchronize. Cause: This due to any of the scenario you are restore a backup controlfile through a non-oracle mechanism and then open the database through Resetlogs option or making a copy of control file through operating system utility and trying the restore on new system through RNAN. You do not use catalog so RMAN does not get any information regarding this process.  The recovery catalog indicates that the highest RECID is 100, but the control file indicates that the highe...
Post a Comment
Read more

Changing National Character Set AL16UTF16 to UTF8

Changing National Character Set AL16UTF16 to UTF8 The national character set is used for data that is stored in table columns of the types NCHAR, NVARCHAR2, and NCLOB.  In contrast, the database character set is used for data stored in table columns of the types CHAR, VARCHAR2 and CLOB. Like the database character set, the national character set is defined when the database is initially created and can usually no longer be changed, at least not easily or without involving quite a lot of work (export, recreate database, import). Except when creating the database, where the national character set is defined explicitly, it can change implicitly even when upgrading the database from Oracle8i to Oracle9i (or Oracle10g). You require SYSDBA authorization to change the national character set. Changing the national character set means changing an Oracle Dictionary entry, but no data is changed.  $sqlplus /nolog SQL> CONNECT / AS SYSDBA SQL> Select property_...
Post a Comment
Read more

How to Remove Oracle services from Windows

How to Remove Oracle services from Windows If you have uninstall the Oracle software from your system, but, the services are not removed. This resulted, when you are trying to install oracle back and trying to configure your Instance as old name is not allowed. Method1: To remove OracleService , go to the command prompt and type: oradim -delete -sid <SID> where SID is the sid of your database, as it appears when you type net start | more (you should get an "OracleServiceSID") Method2: If you have the resource kit, you can use delsrv.exe to remove the listener service. If you don't have the resource kit, you can download delsrv.exe from Microsoft Support: http://www.microsoft.com/windows2000/tec… Method3: Go to Registry (Type regedit on RUN) Take a backup of Registry. (For the backup Click on file menu on Registry and export your registry backup any location so whenever required you can import your old registry.) Now go to registry HKEY_L...
Post a Comment
Read more