To bring the database online use following syntax (this also works when .tuf file is missing):

RESTORE <database> WITH RECOVERY