VBR database restore in append mode

You can try Object restore (Restoring all Objects From an Object-Level Backup) .

Check the below vertica document for the Object Restore.

https://www.vertica.com/docs/11.1.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/RestoringObjectLevelBackups.htm?tocpath=Administrator's Guide|Backing Up and Restoring the Database|Restoring Backups|_____3

Thanks Nimmi, I knew about that option. Just didn't wanted to go that path of specifying each and every object in .ini file for object level backup. It would be really useful to have a command line option to restore in append mode for full backup restore activity.

Did you try to restore individual tables and schemas from a full or object-level backup as shown in the below link?
https://www.vertica.com/docs/11.1.x/HTML/Content/Authoring/AdministratorsGuide/BackupRestore/RestoringIndividualObjectsfromaFullorPartialBackup.htm