Oracle DBA Tasks

You are an Oracle Database Administrator managing enterprise database operations including backup, recovery, patching, and monitoring.

What to check first

• Run sqlplus -v to verify Oracle client installation and version
• Execute echo $ORACLE_HOME to confirm ORACLE_HOME environment variable is set
• Check lsnrctl status to verify the Oracle Listener is running
• Run v$instance query to confirm database connectivity: sqlplus / as sysdba

Steps

1. Connect to Oracle database as SYSDBA: sqlplus / as sysdba and verify instance status with SELECT status FROM v$instance;
2. Enable Archive Log mode if not enabled: SHUTDOWN IMMEDIATE; STARTUP MOUNT; ALTER DATABASE ARCHIVELOG; ALTER DATABASE OPEN;
3. Configure RMAN backup destination: CONFIGURE CHANNEL DEVICE TYPE DISK TO '/backup/oracle';
4. Create full database backup using RMAN: BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
5. Configure incremental backups with retention policy: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
6. Monitor backup progress via v$rman_backup_job_details view and check alert log at $ORACLE_BASE/diag/rdbms/[db_name]/[instance_name]/trace/alert_[instance_name].log
7. Apply Oracle patches using OPatch utility: $ORACLE_HOME/OPatch/opatch auto $ORACLE_HOME -oh $ORACLE_HOME
8. Query v$log, v$logfile, and v$archived_log to monitor redo logs and archive status
9. Set up automated backups in cron: 0 2 * * * /scripts/rman_backup.sh >> /logs/backup.log 2>&1
10. Monitor database performance using AWR reports: @?/rdbms/admin/awrrpt.sql

Code

-- Oracle DBA Task Management Script
SET PAGESIZE 50 LINESIZE 120 FEEDBACK OFF VERIFY OFF ECHO OFF

-- 1. Check Database Status and Instance Info
PROMPT ======== DATABASE STATUS ========
SELECT name, open_cursors, db_unique_name, created FROM v$database;
SELECT instance_name, version, status FROM v$instance;

-- 2. Check Redo Log Status and Archive Mode
PROMPT ======== ARCHIVE LOG STATUS ========
SELECT log_mode FROM v$database;
SELECT group#, members, status, archived FROM v$log ORDER BY group#;

-- 3. Tablespace Usage Report
PROMPT ======== TABLESPACE USAGE ========
SELECT tablespace_name, 
       ROUND(sum_free_space/1024/1024, 2) AS free_mb,
       ROUND(sum_alloc_space/1024/1024, 2) AS allocated_mb,
       ROUND(100 *

Note: this example was truncated in the source. See the GitHub repo for the latest full version.

Common Pitfalls

• Treating this skill as a one-shot solution — most workflows need iteration and verification
• Skipping the verification steps — you don't know it worked until you measure
• Applying this skill without understanding the underlying problem — read the related docs first

When NOT to Use This Skill

• When a simpler manual approach would take less than 10 minutes
• On critical production systems without testing in staging first
• When you don't have permission or authorization to make these changes

How to Verify It Worked

• Run the verification steps documented above
• Compare the output against your expected baseline
• Check logs for any warnings or errors — silent failures are the worst kind

Production Considerations

• Test in staging before deploying to production
• Have a rollback plan — every change should be reversible
• Monitor the affected systems for at least 24 hours after the change