Is it possible to do an object backup on one database and restore these objects on another?
Yes. It is possible to backup objects from one database and restore it on another database as long as the Vertica version is same for both backup and restore operations. For more information on performing object-level backup, please take a look at URL
For more information on performing object-level restore, please take a look at URL
Does the destination database have to have the same name as the source database?
Just to clarify - I want the objects from db1 back up so that I can restore the same objects on db2 using that config file produced from db1.
Is db2 present in the same cluster? or is it present in different cluster?
As long as version, node names, IP addresses and number of nodes are same you can restore object level backup to a different cluster. please make sure that location of the backup is not changed.
You can do this if you are running Vertica 7.2.X or after (see my reply here: https://community.dev.hpe.com/t5/Vertica-Forum/how-to-synchronize-tables-between-clusters/m-p/233924#M11334).
I believe this is not the case here. Prior to 7.2.X you can restore backups to the same database, attempting to restore to another database will fail.