GBASE 8S 查看onbar备份的相关任务和信息

CREATE VIEW list_backups(Backup_ID, Type, Object_Name, Ifx_Time, CopyID_HI,

CopyID_LO, Backup_Start, Backup_End, Verify_Date)

AS SELECT * FROM (

SELECT

act_aid AS backup_id,

DECODE(act_type, 5, “Whole-System”, DECODE(obj_type, “L”,

“Logical log”, “Dbspace”)) AS Type,

substr(obj_name,1, 8) AS Object_Name,

min(DBINFO (‘utc_to_datetime’, seal_time)) AS Ifx_Time,

ins_copyid_hi AS CopyID_HI,

ins_copyid_lo AS CopyID_LO,

act_start AS Backup_Start,

act_end AS Backup_End,

ins_verify_date AS Verify_Date

FROM

bar_action A,

bar_instance I,

bar_object O

WHERE

A.act_aid = I.ins_aid AND

A.act_oid = O.obj_oid AND

A.act_oid = I.ins_oid AND

O.obj_type in (“R”, “CD”, “ND”, “L”)

GROUP BY 1,2,3,5,6,7,8,9

ORDER BY Ifx_Time, Backup_ID) AS view_list_backups