Hi Nicholas, please make sure, that D:\db\HEIDB\baklogs\heidblog.005 exists and is accessible. Otherwise the first both "recover_replace"s look good. The third cannot work, as the path is enclosed in ''.
Best Regards Tilo Heinrich SAP Labs Berlin -----Original Message----- From: Mundy, Nicholas S-PN EXT [mailto:[EMAIL PROTECTED]] Sent: Montag, 3. Februar 2003 11:02 To: [EMAIL PROTECTED] Subject: Problems with complete backup Hello, am trying (without success) to restore a database after a simulated media failure: -Took full data backup (Medium heidbcomp2) -Generated some activity so autolog would kick in (Medium heidblog, logs heidblog.004 - 008 come after the full data backup) -Set db_cold and dropped data devspace. -Carrying out recovery as below. What's wrong here? How do you then know which logs are needed.. presumeably some redo information is still in the log devspace and can be read directly from there (returncode?) Thanks Nick Mundy --------------------------------------------------------------------------------------- dbmcli -u dbm,---- -d HEIDB -uUTL dbmcli on HEIDB>recover_start heidbcomp2 DATA OK Returncode 0 Date 20030203 Time 00104114 Server heiapp00048 Database HEIDB Kernel Version Kernel 7.3.0 Build 029-000-087-809 Pages Transferred 640 Pages Left 0 Volumes 1 Medianame heidbcomp2 Location D:\db\HEIDB\bakdata\heidbcomp2 Errortext Label DAT_00002 Is Consistent true First LOG Page 2710 Last LOG Page DB Stamp 1 Date 20030203 DB Stamp 1 Time 00094036 DB Stamp 2 Date DB Stamp 2 Time Page Count 623 Devices Used 1 Database ID heiapp00048:HEIDB_20030203_085158 Max Used Data Page 924 --- dbmcli on HEIDB>recover_start heidblog LOG 004 OK Returncode -8020 Date 20030203 Time 00104130 Server heiapp00048 Database HEIDB Kernel Version Kernel 7.3.0 Build 029-000-087-809 Pages Transferred 704 Pages Left 0 Volumes 1 Medianame heidblog Location D:\db\HEIDB\baklogs\heidblog.004 Errortext Label LOG_00004 Is Consistent First LOG Page 2043 Last LOG Page 2723 DB Stamp 1 Date 20030203 DB Stamp 1 Time 00091612 DB Stamp 2 Date 20030203 DB Stamp 2 Time 00094050 Page Count 680 Devices Used 1 Database ID heiapp00048:HEIDB_20030203_085158 Max Used Data Page --- dbmcli on HEIDB>recover_replace heidblog "D:\db\HEIDB\baklogs\heidblog" 005 ERR -24988,ERR_SQL: sql error -3004,invalid file or device name [2] --- dbmcli on HEIDB>recover_replace heidblog D:\db\HEIDB\baklogs\heidblog 005 ERR -24988,ERR_SQL: sql error -3004,invalid file or device name [2] --- dbmcli on HEIDB>recover_replace heidblog 'D:\db\HEIDB\baklogs\heidblog' 005 ERR -24988,ERR_SQL: sql error -3014,Message not available _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
