Backup / Restore

qiniyekiqiniyeki - Select Field -
edited April 2021 in General Discussion

Can someone that is not the one that initiated vbr's backup or restore command see the progress of backup or restore actions that are currently running? Can the progress be seen from Vertica system tables or from OS?

My eyes flicked to the pile of essays, half of which I had already graded. I wondered if I could discover the author by process of elimination. Whoever had been present but not turned in an essay would likely be the writer. So, I did my best to put the explicit narrative--one in which a neighbor takes pictures of a girl sunbathing topless, then blackmails her into giving head before finally forcing her to deepthroat--out of my mind. With some effort, I succeeded .

Once all the essays were graded, I recorded the grades. However, I was left frustrated. None of the students present that day had failed to turn in an essay, and the only two absences were boys. And yet, the essay had been in the pile from my fourth period class, and I knew it could not have come from anywhere else. Then my mistake hit me. I had set the deepthroat essay aside without noting which essays came before and after it.

Staring at the stack of papers, I attempted to remember which essay I had graded immediately after the deepthroat one. It had been about cooking a thanksgiving meal for the first time after her mom passed away, or at least I thought it had. I searched for the essay, finding it eighth from the top, which seemed about right. Skimming it, I confirmed it was the one I recalled. And it was written by a girl – Emily Breckenridge. I set it aside next to the one without a name, then looked at the essay that had been seventh from the top. It was by a boy named Craig and was, of course, about the first time his dad took him driving. I put it back on the pile and turned my attention back to Emily’s essay, picturing the girl in my mind .


  • moshegmosheg Vertica Employee Administrator

    By default only database administrator can access the logs.
    Vbr logs are stored on node where vbr was kicked off, by default, /tmp/vbr, or in another directory as defined in tha backup ini file.
    Here are other log options:
    tail -f catalog-path/database-name/node-name_catalog/vertica.log
    select * from v_monitor.database_backups; -- Lists historical information for each backup that successfully completed after running the vbr utility.
    select * from v_internal.dc_backups; -- to monitor successful backups and copy cluster operations
    select * from v_internal.dc_object_backups; -- to monitor successful object level restores
    select * from dc_vbr_invocations;
    select * from V_MONITOR.TABLE_RECOVERY_STATUS; -- View general information about a recovery
    select * from V_MONITOR.TABLE_RECOVERIES; -- detailed information about the status of the recovery the table being restored

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file