Re: Backup/Restore

Hi,
    If you want to specify a medium, you should use:

recover_start newbackup DATA 

Yves

[email protected] wrote:

>Hi,
>
>I emailed the listserve one time about this issue and did not get a response. I am trying to do a backup and restore on one of my database instances.  I am utilizing the complete data backup using the media type file. Here are the commands I am executing and the resulting message:
>./dbmcli -d TST74 -u dbm,dbm medium_put newbackup /home/sapdb/backup082903 FILE DATA 0 8 YES
>
>./dbmcli -d TST74 -u dbm,dbm -uUTL -c backup_start newbackup
>
>Returncode              0
>Date                    20030829
>Time                    00115941
>Server                  sapdb.abt.net
>Database                TST74
>Kernel Version          Kernel    7.4.3    Build 027-121-048-452
>Pages Transferred       248
>Pages Left              0
>Volumes                 1
>Medianame               newbackup
>Location                /home/sapdb/backup082903
>Errortext
>Label                   DAT_00019
>Is Consistent           true
>First LOG Page          1077
>Last LOG Page
>DB Stamp 1 Date         20030829
>DB Stamp 1 Time         00115941
>DB Stamp 2 Date
>DB Stamp 2 Time
>Page Count              225
>Devices Used            1
>Database ID             sapdb.abt.net:TST74_20030820_134838
>Max Used Data Page      0
>
>By the way, I AM doing all this with a utility connection.  It looks like the backup is successful.  However, I am having problems with the restore.  What exact command has to be executed in order to restore this database instance and how can one check if the restore was done successfully?   I tried the following command, however as you will afterward, the "Location" points to the datasave file which is not the file I wanted to restore:
>./dbmcli on TST74>recover_start DATA
>OK
>Returncode              0
>Date                    20030829
>Time                    00134152
>Server                  sapdb.abt.net
>Database                TST74
>Kernel Version          Kernel    7.4.3    Build 027-121-048-452
>Pages Transferred       248
>Pages Left              0
>Volumes                 1
>Medianame               data
>Location                /home/sapdb/TST74/datasave
>Errortext
>Label                   DAT_00009
>Is Consistent           true
>First LOG Page          1057
>Last LOG Page
>DB Stamp 1 Date         20030825
>DB Stamp 1 Time         00173710
>DB Stamp 2 Date
>DB Stamp 2 Time
>Page Count              225
>Devices Used            1
>Database ID             sapdb.abt.net:TST74_20030820_134838
>Max Used Data Page      0
>
>
>Sorry for the long email but I am fairly new to both sap and linux and would appreciate any help/suggestions concerning this matter.  Thank you in advance.
>
>Regards,
>J. Simoni
>_______________________________________________
>sapdb.general mailing list
>[email protected]
>http://listserv.sap.com/mailman/listinfo/sapdb.general
>
>
>  
>