OracleBackup & recovery
Running RMAN job progress
Percent complete and time remaining for each RMAN channel that's working right now.
Not yet verified. How scripts are tested
1CLEAR COLUMNS2SET LINESIZE 140 PAGESIZE 100 TRIMOUT ON TAB OFF3COLUMN sid_serial HEADING "SID,SERIAL#" FORMAT A144COLUMN opname HEADING "OPERATION" FORMAT A35 TRUNCATE5COLUMN pct_done HEADING "DONE %" FORMAT 990.96COLUMN elapsed_m HEADING "ELAPSED MIN" FORMAT 99,9907COLUMN remain_m HEADING "REMAIN MIN" FORMAT 99,9908 9SELECT sid || ',' || serial# AS sid_serial,10 opname,11 ROUND(100 * sofar / NULLIF(totalwork, 0), 1) AS pct_done,12 ROUND(elapsed_seconds / 60) AS elapsed_m,13 ROUND(time_remaining / 60) AS remain_m14FROM v$session_longops15WHERE opname LIKE 'RMAN%'16 AND opname NOT LIKE '%aggregate%'17 AND sofar < totalwork18ORDER BY start_time;Save it as ora-rman-progress.sql and run it with SQL> @ora-rman-progress.
Open in denrepoRelated tool: RMAN command builder
More Oracle scripts: Backup & recovery
- RMAN backup history with run time in hoursRun in the target database as SYSDBA, not the recovery catalog. The first report lists every RMAN job (full, incremental and archivelog) with start,…
- RMAN backup jobs in the last 7 daysStatus, duration and output size of each RMAN job, newest first.
- Datafiles without a recent backupDatafiles with no backup of any kind in the last two days, or none at all. A new datafile added after the last full backup shows up here first.
- RMAN configuration (non-default settings)The persistent CONFIGURE settings stored in the control file, the same list SHOW ALL marks as changed. Check retention and control file autobackup…
- Fast Recovery Area usageFRA size, used and reclaimable space, then what's using it by file type. Real used % is the number that matters: at 100% the database stops archiving…
- Flashback status and restore pointsWhether flashback is on, how far back you can go, and every restore point. A forgotten guaranteed restore point will keep filling the FRA until it's…