Introduction: To check and manage RMAN backups using dbcli in Oracle Database Cloud Service (DBCS) on Oracle Cloud Infrastructure (OCI), follow these practical steps. dbcli is a command-line interface available on bare metal and VM DB systems that simplifies core DBA activities including backup operations without the need for the full RMAN syntax or Oracle Enterprise Manager.
Database Cloud Service agent) in Oracle DBCS:
In Oracle DBCS environments, backup operations and other database lifecycle activities are managed by the DCS agent. This agent handles job execution, logging, and monitoring ensuring tasks like automatic backups are properly scheduled and tracked. Instead of relying solely on manual scripts, DCS agent integrates with Oracle Cloud tooling to orchestrate backups and maintain logs under /var/opt/oracle/log/ for auditing and troubleshooting.
1. List Backup Jobs and Status:
To see the status of backup operations run by dbcli, list job history:
[root@oci-TEST01 TESTCDB_phx35s]# dbcli list-jobs
2.Check Backup Status:
You can check backup status or get the latest backup report using:
dbcli getstatus-backup -in <dbName>
Note: -in <dbName> specifies the database name (example: -in mydb).
For the latest backup report only:
dbcli getstatus-backup –l
3.List and Describe Backup Configurations:
a) To see configured backup options:
dbcli list-backupconfigs
b) For detailed information about a backup config:
dbcli describe-backupconfig -n <configName>
RMAN Job file location:
/opt/oracle/dcs/log/oci-TEST01/rman/bkup/TESTCDB_phx35s
This stores the log files of the respective jobs for further checking and troubleshooting.
Conclusion: Checking RMAN backups in Oracle DBCS isn’t just about running a job and forgetting it’s about visibility, traceability, and recoverability. Whether you use dbcli, rman, or SQL views, regular validation ensures that your backup strategy isn’t just configured it’s reliable.
