Hi, for all recovery actions the db must be in ADMIN mode, through a LOG recovery the DB will be restarted authomaticly. Through a DATA or PAGE recovery the database must be restarted manually. If you want restore PAGES or LOG after a DATA recovery do not start the database. I am not sure if this the solution for your problem.
Martin SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general -----Original Message----- From: Arne Gehlhaar [mailto:[EMAIL PROTECTED] Sent: Donnerstag, 19. Juni 2003 16:41 To: [EMAIL PROTECTED] Subject: backup and recovery problems Hi, on my productive system I do daily DATA, 6-hourly PAGES and hourly LOG backups on file backup devices. I am currently trying to resore these on a different server: same DB 7.4.3.10, same OS (RetHat 7.3), different hardware Restore of the DATA backup is no problem. Using the wizard in the DBMGUI I can create a database instance from a backup medium. But I cannot get the database to restore the incremental backups (neither PAGES nor LOG). With the DBMGUI, I can only choose Recovery->Database->Restore_a_medium when the databse in admin mode. But then I get: "sql error [util_connect ...]; 1,database not running" So I switch the database into online mode and try: dbmcli -d DB -u dbm,*** -uUTL dbm,*** recover_start PAGDEV PAGES but that simply gives: ERR -24988,ERR_SQL: sql error -3005,Invalid SQL statement What am I doing wrong? The online Manual does not give any hints... Thanks, Arne -- Institute of Shipping Economics and Logistics http://www.isl.org/ Arne Gehlhaar mailto:[EMAIL PROTECTED] Universitaetsallee GW1 Block A phone:+49.421.22096.49 D-28359 Bremen, Germany fax:+49.421.22096.55 _______________________________________________ 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
