Skip to main content
Sign Out

Welcome to Dell

My Account
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Enjoy members-only rewards and discounts
  • Create and access a list of your products
  • Manage your Dell EMC sites, products, and product-level contacts using Company Administration.
Sign In Create an Account Dell Financial Services Premier Sign In Partner Program Sign In
Contact Us

Your Dell.com Carts

Dell Avamar for Oracle 19.10 User Guide

PDF

Activity monitor of RMAN backup shows an incorrect status of still running.

Because of an issue with the Oracle database, the Activity monitor in the Avamar Administrator may incorrectly show RMAN backups as still running.

To work around this problem, run the follow in sqlplus when logged in as sysdba:

  1. SQL> exec dbms_stats.DELETE_TABLE_STATS('SYS','X$KCCRSR');

    The PL/SQL procedure will be successfully completed

  2. SQL> exec dbms_stats.LOCK_TABLE_STATS('SYS','X$KCCRSR');

    The PL/SQL procedure will be successfully completed

  3. SQL> set autotrace on
  4. SQL> select * from x$kccrsr;
  5. Exit sqlplus and relogin sqlplus
  6. Select status from v$rman_status;

Rate this content

Accurate
Useful
Easy to understand
Was this article helpful?
0/3000 characters
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please select whether the article was helpful or not.
  Comments cannot contain these special characters: <>()\