recovering a DB from full backup when one of TSM DB DIR became corrupt and DB is in roll forward mode (need help)

2014-11-23 Thread Dury, John C.
Long story short, I have a full DB backup taken on a linux system running TSM 
6.3.4.300 with the DB in roll forward mode. The DB is spread across 4 different 
dbdirs file systems. One of the file systems became corrupt and I need to 
recover the DB from the full backup.
I have the dbdirs file systems back  and the active log and archive log 
directories are ok and were untouched. The dbdirs directories are back  but 
there are no files in them.
The active log and archive log directories are ok and uncorrupted.
How can I restore the DB to the most recent point since the archivelog is still 
intact and recreate the files in the dbdirs so a restore can repopulate them 
from the full DB backup?


Re: recovering a DB from full backup when one of TSM DB DIR became corrupt and DB is in roll forward mode (need help)

2014-11-23 Thread Erwann Simon
Hello John,
See both Admin Guide and Admin Reference regarding "dsmserv restore db". There 
are two recovery methods : on that deletes the logs (point in time restore,  
ignore it) and one that keeps and rollforwards the logs after db restore (most 
current state, use this one).
The command is pretty simple :
Login as instance owner
Change to the instance directory
Simply run : dsmserv restore db

Note that of you use the todate option of the dsmserv restore db command, 
you'll have a point in time restore which deletes the log !



Le 24 novembre 2014 00:57:56 CET, "Dury, John C."  a écrit :
>Long story short, I have a full DB backup taken on a linux system
>running TSM 6.3.4.300 with the DB in roll forward mode. The DB is
>spread across 4 different dbdirs file systems. One of the file systems
>became corrupt and I need to recover the DB from the full backup.
>I have the dbdirs file systems back  and the active log and archive log
>directories are ok and were untouched. The dbdirs directories are back 
>but there are no files in them.
>The active log and archive log directories are ok and uncorrupted.
>How can I restore the DB to the most recent point since the archivelog
>is still intact and recreate the files in the dbdirs so a restore can
>repopulate them from the full DB backup?

-- 
Erwann SIMON
Envoyé de mon téléphone Android avec K-9 Mail. Excusez la brièveté.