Consider yourself lucky!! It took me 92 hours (almost 4 days) to restore a (ONE) 220k file from a backupset (we are STILL working that one with TSM support). I can't tell you how many times that I have heard "Restore backupset is not really designed to restore specific files" for TSM support in the last couple of weeks.
The next restore took 8 days before it finally failed. John stated a great text book reply that anyone considering using backupsets should follow. I considered these facts before using backupsets and also tested full and individual file restores with expected results. Now in my hour of need, I am not getting expected results. No one can tell me that it takes 92 hours for a 3584 with fiber channel drives to read a LTO tape, no matter how large or small the block size is. But as I said, we are still working this with support, just wanted to vent a little. TSM server: 4.2.2.2 (Win2K) TSM client: 4.2.2.0 (Win2K) -----Original Message----- From: John Naylor [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 13, 2002 7:39 AM To: [EMAIL PROTECTED] Subject: Re: Restore backupset take very long Miguel, Restore backupset is not really designed to retore specific files A backupset is a self contained object, desined for restore as a whole independent of the database. The database does not hold any information on the location of individual files. So when you are looking fto restore an individual file the backupset tape/tapes have to be read to find it. John Demaerel Miguel <[EMAIL PROTECTED]> on 08/13/2002 12:39:57 PM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: (bcc: John Naylor/HAV/SSE) Subject: Restore backupset take very long Hoi TSM server: 4.2.2.7 (AIX 5.1) TSM client: 4.2.1.7 (Solaris 8) I try to restore some files from a backupset (size 110 GB on 2 tapes) tsm> restore backupset SOVI01_2002-08-06.130729665 /data11/oradata/PSVB/admin/files/lcnv/*20020417.dat.gz /opt/restore. No problem so far.... But this takes very long Result of restore: Restore function invoked. Session established with server ADSM: AIX-RS/6000 Server Version 4, Release 2, Level 2.7 Server date/time: 13-08-2002 11:46:50 Last access: 13-08-2002 11:22:06 ANS1247I Waiting for files from the server... Restoring 46,592 /data11/oradata/PSVB/admin/files/lcnv --> /opt/restore/lcnv [Done] Restoring 5,673,249 /data11/oradata/PSVB/admin/files/lcnv/euro_stap2A_TZS_CREDIT_DEBET_EURO_1_20 020417. Restoring 7,556,400 /data11/oradata/PSVB/admin/files/lcnv/euro_stap2A_TZS_CREDIT_DEBET_EURO_3_20 020417. Restoring 11,659,832 /data11/oradata/PSVB/admin/files/lcnv/euro_stap2A_TZS_CREDIT_DEBET_EURO_4_20 020417. Restoring 50,129,976 /data11/oradata/PSVB/admin/files/lcnv/euro_stap2B_TZS_CREDIT_DEBET_EURO_1_20 020417. Restoring 31,002,144 /data11/oradata/PSVB/admin/files/lcnv/euro_stap2B_TZS_CREDIT_DEBET_EURO_2_20 020417. Restoring 32,800,605 /data11/oradata/PSVB/admin/files/lcnv/euro_stap2B_TZS_CREDIT_DEBET_EURO_3_20 020417. Restoring 38,666,328 /data11/oradata/PSVB/admin/files/lcnv/euro_stap2B_TZS_CREDIT_DEBET_EURO_4_20 020417. Restore processing finished. Total number of objects restored: 8 Total number of objects failed: 0 Total number of bytes transferred: 169.53 MB Data transfer time: 10.80 sec Network data transfer rate: 16,063.53 KB/sec Aggregate data transfer rate: 27.44 KB/sec Elapsed processing time: 01:45:25 tsm> There isn't action on the TSM server or on the client. Top output. last pid: 1655; load averages: 0.02, 0.01, 0.02 13:04:09 52 processes: 51 sleeping, 1 on cpu CPU states: 99.9% idle, 0.0% user, 0.1% kernel, 0.0% iowait, 0.0% swap Memory: 1024M real, 657M free, 106M swap in use, 1156M swap free PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND 1655 root 1 50 0 2536K 1632K cpu/3 0:00 0.25% top 224 root 12 58 0 2688K 1400K sleep 15:07 0.00% mibiisa 216 root 1 59 0 27M 26M sleep 3:58 0.00% Xsun 1482 root 6 59 0 9032K 6376K sleep 0:11 0.00% dsmc 23409 root 1 59 0 6872K 2192K sleep 0:09 0.00% sdtperfmeter 23405 root 8 59 0 8808K 4240K sleep 0:05 0.00% dtwm 155 root 1 48 0 1952K 1072K sleep 0:04 0.00% cron 23398 root 6 49 0 8168K 4712K sleep 0:04 0.00% dtsession 23408 root 1 48 0 10M 3608K sleep 0:03 0.00% dtfile 23407 root 1 49 0 7640K 3496K sleep 0:01 0.00% dtterm 136 root 5 58 0 4040K 2640K sleep 0:01 0.00% automountd 146 root 10 58 0 3200K 1584K sleep 0:01 0.00% syslogd 23417 root 1 59 0 1800K 664K sleep 0:01 0.00% rpc.rstatd 23420 root 1 2 0 1032K 256K sleep 0:00 0.00% sh 23347 root 1 10 0 2304K 440K sleep 0:00 0.00% fbconsole Restore from archive: tsm> retrieve /data11/oradata/PSVB/admin/files/lcnv/*20020417.dat.gz /opt/restore/ Retrieve function invoked. Retrieving 46,592 /data11/oradata/PSVB/admin/files/lcnv --> /opt/restore/lcnv [Done] ** Interrupted ** ANS1114I Waiting for mount of offline media. Retrieving 7,556,400 /data11/oradata/PSVB/admin/files/lcnv/euro_stap2A_TZS_CREDIT_DEBET_EURO_3_20 020417 Retrieving 11,659,832 /data11/oradata/PSVB/admin/files/lcnv/euro_stap2A_TZS_CREDIT_DEBET_EURO_4_20 020417 Retrieving 31,002,144 /data11/oradata/PSVB/admin/files/lcnv/euro_stap2B_TZS_CREDIT_DEBET_EURO_2_20 020417 Retrieving 32,800,605 /data11/oradata/PSVB/admin/files/lcnv/euro_stap2B_TZS_CREDIT_DEBET_EURO_3_20 020417 Retrieving 38,666,328 /data11/oradata/PSVB/admin/files/lcnv/euro_stap2B_TZS_CREDIT_DEBET_EURO_4_20 020417 Retrieving 5,673,249 /data11/oradata/PSVB/admin/files/lcnv/euro_stap2A_TZS_CREDIT_DEBET_EURO_1_20 020417 Retrieving 50,129,976 /data11/oradata/PSVB/admin/files/lcnv/euro_stap2B_TZS_CREDIT_DEBET_EURO_1_20 020417 Retrieve processing finished. Total number of objects retrieved: 8 Total number of objects failed: 0 Total number of bytes transferred: 169.28 MB Data transfer time: 9.76 sec Network data transfer rate: 17,750.91 KB/sec Aggregate data transfer rate: 1,751.29 KB/sec Elapsed processing time: 00:01:38 tsm> What can be the reason? What a difference in time? Restore backupset 01:45 Retrieve 00:02 Thanks in advance. Greetings Miguel ///// (o o) ==============oOO==(_)==OOo============== Miguel Demaerel System Engineer Schlumberger Raketstraat 98, B-1130 Brussels, Belgium Tel +32 (0)2 724 93 17 Fax +32 (0)2 724 92 92 Email [EMAIL PROTECTED] ========================================= ********************************************************************** The information in this E-Mail is confidential and may be legally privileged. It may not represent the views of Scottish and Southern Energy plc. It is intended solely for the addressees. Access to this E-Mail by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Any unauthorised recipient should advise the sender immediately of the error in transmission. Scottish Hydro-Electric, Southern Electric, SWALEC and S+S are trading names of the Scottish and Southern Energy Group. **********************************************************************
