Hi, Our SAPDB database PDB has been backed up, using Legato Networker, to the medium NSR_PDB_full. The backup reports that it has completed successfully. In restoring, I am trying to test the scenario when the disks containing our \sapdb\PDB\sapdata and \sapdb\PDB\saplog are lost. This is the steps I follow:
dbmcli -d PDB -u control,control dbmcli on PDB>db_state OK State OFFLINE --- dbmcli on PDB>db_clear OK --- dbmcli on PDB>db_start OK --- dbmcli on PDB>backup_ext_ids_get NSR_PDB_full PDB OK --- dbmcli on PDB>backup_ext_ids_list OK END AVAILABLE|NST 1043940282 APLELJ02|DATA MIGRATION|2003-01-30 15:24:42| AVAILABLE|NST 1043940283 APLELJ02|DATA MIGRATION|2003-01-30 15:24:43| AVAILABLE|NST 1044046654 APLELJ02|DATA MIGRATION|2003-01-31 20:57:34| AVAILABLE|NST 1044046676 APLELJ02|DATA MIGRATION|2003-01-31 20:57:56| AVAILABLE|NST 1044131194 APLELJ02|DATA MIGRATION|2003-02-01 20:26:34| AVAILABLE|NST 1044131207 APLELJ02|DATA MIGRATION|2003-02-01 20:26:47| AVAILABLE|NST 1044218131 APLELJ02|DATA MIGRATION|2003-02-02 20:35:31| AVAILABLE|NST 1044218132 APLELJ02|DATA MIGRATION|2003-02-02 20:35:32| AVAILABLE|NST 1044363727 APLELJ02|DATA MIGRATION|2003-02-04 13:02:07| AVAILABLE|NST 1044363728 APLELJ02|DATA MIGRATION|2003-02-04 13:02:08| AVAILABLE|NST 1044370827 APLELJ02|DATA MIGRATION|2003-02-04 15:00:27| AVAILABLE|NST 1044370828 APLELJ02|DATA MIGRATION|2003-02-04 15:00:28| AVAILABLE|NST 1044388954 APLELJ02|DATA MIGRATION|2003-02-04 20:02:34| AVAILABLE|NST 1044388955 APLELJ02|DATA MIGRATION|2003-02-04 20:02:35| AVAILABLE|NST 1044475538 APLELJ02|DATA MIGRATION|2003-02-05 20:05:38| AVAILABLE|NST 1044475539 APLELJ02|DATA MIGRATION|2003-02-05 20:05:39| AVAILABLE|NST 1044521145 APLELJ02|DATA MIGRATION|2003-02-06 08:45:45| AVAILABLE|NST 1044521146 APLELJ02|DATA MIGRATION|2003-02-06 08:45:46| --- dbmcli on PDB>util_connect OK --- dbmcli on PDB>recover_start NSR_PDB_full DATA EBID "NST 1044521145 APLELJ02,NST 1044521146 APLELJ02" OK Returncode 0 Date 20030206 Time 00104027 Server APLELJ02.uk.ba.com Database PDB Kernel Version Kernel 7.3.0 Build 030-000-088-243 Pages Transferred 328 Pages Left 0 Volumes 2 Medianame NSR_PDB_full Location \\.\pipe\NSR_PDB_full2 Errortext Label DAT_00007 Is Consistent true First LOG Page 2109 Last LOG Page DB Stamp 1 Date 20030206 DB Stamp 1 Time 00084542 DB Stamp 2 Date DB Stamp 2 Time Page Count 264 Devices Used 2 Database ID aplelj02:PDB_20020606_123603 Max Used Data Page 289 --- dbmcli on PDB>db_stop OK --- dbmcli on PDB>db_start OK --- dbmcli on PDB>db_warm ERR -24988,ERR_SQL: sql error -8003,Message not available What am I doing wrong? I have read the PDF "External Backup Tools: SAPDB" and the postings on this site and no extra steps seem to be mentioned. Thanks __________________________________________________________________________ Freeserve AnyTime - Go online whenever you want for just �6.99 a month for your first 3 months, that's HALF PRICE! And then it's just �13.99 a month after that. For more information visit http://www.freeserve.com/time/ or call free on 0800 970 8890 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
