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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Home > RHEL > RHEL 8.x > Backup tools > Spectrum Protect Backup > Spectrum Protect Backup schedule status commands

  1. On the backup server, open backup console
    dsmadmc
  2. 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"
  3. 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"
  4. 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
  5. 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