Skip to main content
Question

How To Check if Backup is Taking Place

  • October 3, 2019
  • 1 reply
  • 11 views
avi120
Forum|alt.badge.img+1
  • avi120
  • Participating Frequently

Hi Experts
We have a 3 node Verica cluster. I want to start backup from one node to an external storage how do I know that no other backup is taking place at the same time on another node. I assume we can look for running vbr process on all three nodes, but is there a better way?

Thanks

    1 reply

    Bryan_H
    Forum|alt.badge.img+2
    • Bryan_H
    • Participating Frequently
    • October 3, 2019

    Try checking the V_MONITOR.SESSIONS table for signs of vbr actions, e.g. mention of "snapshot" in transaction_description or current_statement from a user authorized to run backups:

    select node_name, user_name, transaction_description, current_statement from v_monitor.sessions;

    node_name   user_name   transaction_description current_statement
v_docker_node0001   dbadmin user dbadmin (Database Snapshot)
    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement