• Please help support our sponsors by considering their products and services.
    Our sponsors enable us to serve you with this high-speed Internet connection and fast webservers you are currently using at ADSM.ORG.
    They support this free flow of information and knowledge exchange service at no cost to you.

    Please welcome our latest sponsor Tectrade . We can show our appreciation by learning more about Tectrade Solutions
  • Community Tip: Please Give Thanks to Those Sharing Their Knowledge.

    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.

  • Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)

    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

Restoring TSM DB ver. 7.1.X on AIX

dojabergen

ADSM.ORG Member
#1
Hi,
We are running TSMDB backup twice a day, one full backup at 09:00 AM to tape in library-01 and one snapshot at 03:pm to tape in library-02 in a remote site.
We are not running incremental backup in between.
Our question is: Can we utilize the archive logs on top on the full backup in order to recover the most resent data?
Thank you in advance!
 

nenifled

ADSM.ORG Member
#2
Yes you can, you can restore to any specific time you want, if you have the logs:

http://www.ibm.com/support/knowledg...v.reference/r_cmd_dsmserv_restore_db_pit.html

Tip: When you restore a V6 or later Tivoli Storage Manager server database to a specific point in time, the preferred method is to issue the DSMSERV REMOVE DB command before you issue the DSMSERV RESTORE DB command. This ensures that the system is in a clean state. The system drops and uncatalogs the database in the background. When you restore data to a specific point in time, all the required logs and the database image are retrieved from the backup media.
 

nenifled

ADSM.ORG Member
#3
by the way - I think I would make both backups full and both of them to the remote site...of cause that depends on the speed of the backup:

SELECT Cast(START_TIME AS DATE) AS "Date", Cast(START_TIME AS TIME) AS "Start", (timestampdiff(2,end_time-start_time)/60) As "Minuts", Cast((BYTES/1048576) AS Decimal(9,2)) AS "DB MB", (BYTES/1048576)/timestampdiff(2,end_time-start_time) as "MB/sec" , SUCCESSFUL AS "Succ." FROM SUMMARY WHERE activity='FULL_DBBACKUP' AND START_TIME>=(CURRENT_TIMESTAMP-25 days) order by 1
 

nenifled

ADSM.ORG Member
#4
..or since you are doing incremental and full:

SELECT Cast(START_TIME AS DATE) AS "Date", Cast(START_TIME AS TIME) AS "Start", (timestampdiff(2,end_time-start_time)/60) As "Minuts", Cast((BYTES/1048576) AS Decimal(9,2)) AS "DB MB", (BYTES/1048576)/timestampdiff(2,end_time-start_time) as "MB/sec" , SUCCESSFUL AS "Succ." FROM SUMMARY WHERE activity like '%DBBACKUP' AND START_TIME>=(CURRENT_TIMESTAMP-25 days) order by 1
 

dojabergen

ADSM.ORG Member
#5
Hi Nenifled,

Thank you for responding, but I think we are on a wrong track.
You wrote:
"Yes you can, you can restore to any specific time you want, if you have the logs:"
Yes, I have the archive logs, but they are not archived in TSM, but are still in the /tsmarchivelog area.

The data we want to put on the restored full TSM are the archivelogs,
I do not think it is possible to do a rollforward of these archive files in TSM, but maybe DB2. But then I think this is not an official way og doing recovery. Maybe we had to perform incr. backups in between the full TSMDB backup.
Thanks for any replies.
 

Advertise at ADSM.ORG

If you are reading this, so are your potential customer. Advertise at ADSM.ORG right now.

UpCloud high performance VPS at $5/month

Get started with $25 in credits on Cloud Servers. You must use link below to receive the credit. Use the promo to get upto 5 month of FREE Linux VPS.

The Spectrum Protect TLA (Three-Letter Acronym): ISP or something else?

  • Every product needs a TLA, Let's call it ISP (IBM Spectrum Protect).

    Votes: 12 15.8%
  • Keep using TSM for Spectrum Protect.

    Votes: 48 63.2%
  • Let's be formal and just say Spectrum Protect

    Votes: 9 11.8%
  • Other (please comement)

    Votes: 7 9.2%

Forum statistics

Threads
31,350
Messages
133,531
Members
21,475
Latest member
sag
Top