Block Change Capture Questions

From: Scott Canaan <srcdco_at_rit.edu>
Date: Tue, 22 Feb 2022 14:39:36 +0000
Message-ID: <bbf6384177404ed7a9ffc2a134f7a409_at_ex04test91a.ad.rit.edu>



We use CommVault for database backups. CommVault interfaces with RMAN. We do hot backups on prod databases, with one full backup each night and several incrementals throughout the day. Our CommVault administrator sent a message from CommVault that says:

Severity: Minor

          Job ID: 4778016
          Event Date: Mon Feb 21 03:01:11 2022
          Program: ClOraAgent
          Client: rpiddevl2
          Description: Block Change Tracking is found DISABLED on Oracle DB [RPIDDEVL]. Incremental backups may run slow.

He wants us to look into this. We have and are concerned that the overhead will be more than the benefits.

Has anyone turned this on? If so, what was the overhead? Did it help with backups?

Thank you,

Scott Canaan '88
Sr Database Administrator
Information & Technology Services
Finance & Administration
Rochester Institute of Technology
o: (585) 475-7886 | f: (585) 475-7520
srcdco_at_rit.edu<mailto:srcdco_at_rit.edu> | c: (585) 339-8659

CONFIDENTIALITY NOTE: The information transmitted, including attachments, is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy any copies of this information.

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Feb 22 2022 - 15:39:36 CET

Original text of this message