RHEL 8.x Spectrum Protect Backup schedule status commands
From Notes_Wiki
Revision as of 05:34, 3 May 2023 by Saurabh (talk | contribs) (Created page with "Home > RHEL > RHEL 8.x > Backup tools > Spectrum Protect Backup > Spectrum Protect Backup schedule status commands #On the backup server, open backup console #:<pre> #::dsmadmc #:</pre> #Check How much data backed up in last 24 hours #:<pre> #::> SELECT entity, CAST(FLOAT(SUM(bytes)) / 1024 / 1024 / 1024 AS DECIMAL(8,2)) as...")
Home > RHEL > RHEL 8.x > Backup tools > Spectrum Protect Backup > Spectrum Protect Backup schedule status commands
- On the backup server, open backup console
- dsmadmc
- Check How much data backed up in last 24 hours
- > SELECT entity, CAST(FLOAT(SUM(bytes)) / 1024 / 1024 / 1024 AS DECIMAL(8,2)) as "GB" FROM summary WHERE ( activity='ARCHIVE' OR activity='BACKUP' ) AND end_time>current_timestamp-24 hours GROUP BY entity ORDER BY "GB"
- Check how much data backed up in specified time range
- > SELECT entity, CAST(FLOAT(SUM(bytes)) / 1024 / 1024 / 1024 AS DECIMAL(8,2)) as "GB" FROM summary WHERE ( activity='ARCHIVE' OR activity='BACKUP' ) AND start_time >{'2022-04-22 19:00:00'} AND start_time <{'2022-04-23 19:00:00'} GROUP BY entity ORDER BY "GB"
- Find out the backup status
- > SELECT TO_CHAR(CHAR(scheduled_start),'YYYY-MM-DD HH24:MI:SS') as SCHEDULED_START, TRANSLATE('a bc:de:fg', DIGITS(completed - actual_start), '_______abcdefgh_____',' ') as "ELAPTIME (D HHMMSS)", schedule_name, status, reason FROM events WHERE node_name IS NULL
- Search the status
- > SELECT date_time,severity,message FROM actlog WHERE originator='SERVER' AND ( message LIKE'ANR2507I%' OR message LIKE'ANR2110I%' OR message LIKE'ANR2751I%' OR message LIKE'ANR2578W%' OR message LIKE'ANR2579E%') AND date_time>current_timestamp-24 hours
Home > RHEL > RHEL 8.x > Backup tools > Spectrum Protect Backup > Spectrum Protect Backup schedule status commands
