Tuesday, July 16, 2024

Automating Archive Log Cleanup in DBCS Standby Databases: A Step-by-Step Guide


In Oracle Cloud Infrastructure (OCI) Database Cloud Service (DBCS), the ability to use crontab or similar utilities to schedule jobs for the oracle user is restricted by default due to security and operational best practices. Here's why this restriction exists and alternative approaches you can use:

How to Resolve Oracle LogMiner SQL Reconstruction Issues in CDC During Table Structure Changes

  Introduction  Last week, one of my clients experienced an issue with Oracle LogMiner after a table structure change. The generated SQL app...