Backup & Recovery

How to check Data Pump job progress in Oracle

Show Oracle Data Pump job state from DBA_DATAPUMP_JOBS plus per-worker progress percentage from V$SESSION_LONGOPS.

List Oracle controlfile locations and status from V$CONTROLFILE.

Delete Oracle archivelogs already backed up and older than one day using RMAN DELETE ARCHIVELOG, wrapped in a shell script for cron.

Show percent complete for running Oracle RMAN backup operations from V$SESSION_LONGOPS.

Show elapsed hours per Oracle RMAN backup job to track how long each run takes over time.

List Oracle RMAN backup jobs with status, input type, size, and time taken from V$RMAN_BACKUP_JOB_DETAILS.