Archives of the TeradataForum
Message Posted: Fri, 28 Jan 2005 @ 16:37:01 GMT
The reference David made was to only restore the DBC and not the actual restore of the userdbs. In order for a true re-creation of an entire instance of Teradata, you need to restore both the DBC AND all the databases (including users databases).
Note: I see a problem if you only restore the dbc and not the users in from the archive. You may have a problem with a create user statement, if the dbc thinks that user already exist. I have never tried to create a user after a restore of the DBC without a restore of the users databases as well.
This is even more critical when you perform cluster backups, because a dictionary backup has to be taken in addition to the dbc database tables, as a separate archive job because they are excluded from a cluster a backup.
Michael E. McBride
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|