Hello Jiri, Instead of dbm.ebf, dbm.knl and dbm.mdf you will need the history file of the Backint for MaxDB program (aka adapter program for Backint for Oracle) on the new machine. This files path and name was configured by aou and must be restored manually using NetBackup directly or NetBackup's Backint for Oracle.
The listing of ID's has no bug, it was actually intended to look like this. Maybe the documentation of the command can be improved. I have only little knowledge of NetBackup. So how can "policy_log" be switched on or altered? Best regards, Tilo Heinrich SAP Labs Berlin -----Original Message----- From: Přibyl Jiří Sent: Donnerstag, 7. September 2006 17:38 To: Heinrich, Tilo; maxdb@lists.mysql.com Subject: RE: How to recover archived version file ? Hello Tilo, so there is possibility to recover archived log directly from external backup tool? And when I copy dbm.ebf, dbm.knl and dbm.mdf from source machine to target one, I should be able to use option "Restore medium", list archived logs from external backup medium and start recovery? That's great! There is probably small bug in listing of external IDs. Though specifying backup medium I get IDs for all defined BACK medium (in GUI as well as in CLI). When I run: dbmcli -d TST -u control,control dbmcli on TST>backup_ext_ids_get BACK_LOG TST host OK --- dbmcli on PSV>backup_ext_ids_list OK END UNAVAILABLE|TST NS1157038671 /sapdb/PSV/staging/p01|DATA MIGRATION|2006-08-31 17:36:35| UNAVAILABLE|TST NS1157609651 /usr/sap/tmp/stage/pipel|LOG RECOVERY |2006-09-02 10:49:55| Below you can see dbm.ebf 44F701D60006|DAT_000000029|TST NS1157038671 /sapdb/TST/staging/p01|DATA MIGRATION|2006-08-31 17:36:35|BACK|0||BACK_FULL_SINGLE|vftPipe|NO|0|8|S|/sapdb/TST/staging/p01|0| 44F94E5F002A|LOG_000000090|TST NS1157609942 /usr/sap/tmp/stage/pipel|LOG RECOVERY |2006-09-02 11:26:55|BACK|0||BACK_LOG|vftPipe|NO|0|8|S|/usr/sap/tmp/stage/pipel|0| My last question: We call NetBackup 5 through Backint for Oracle interface and there are defined different policies for DATA and LOG in init_online.utl. But archive_stage command doesn't use policy_log, as expected due to our experience from Oracle. Is there any possibility, how to influence this? This would be nice as we want to reapply log to standby and so policy defines for logs disk storage instead of slower tape. Thanks, Jiri ________________________________ Od: Heinrich, Tilo Odesláno: čt 7.9.2006 10:37 Komu: maxdb@lists.mysql.com Předmět: RE: How to recover archived version file ? Hello Jiri, There is curently no way to reocver files back into the file system using MaxDB-tools. Archived log backups can currently only be restored into the database. The only way to restore those (and other) backups from an external backup tool into the file system is to use the backup tool manually. To get an idea, what must be done for achieving this, do a restore or check such a backup and have a look into dbm.ebp. Best regards, Tilo Heinrich SAP Labs Berlin -----Original Message----- From: Přibyl Jiří Sent: Mittwoch, 6. September 2006 12:08 To: maxdb@lists.mysql.com Subject: How to recover archived version file ? Hello, What is expected way to recover archived version files of log backup? We archive files using command archive_stage with VERIFY and REMOVE options, during verifying phase data are correctly read from external backup tool to disk. I have ExternalBackupId "TST NS1157113013 /sapdb/backup/stage/pipel" but I'm not able to recover files back to filesystem by means of command recover_start. Maybe problem of syntax, maybe I should use another command? Thanks for help. Regards, Jiri Pribyl -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
