Hi! First: I'm not from Sap team, and this is not an official guide. So use at your own risk (in another words: worked for me from a long time).
Guys this could be anywhere in Admin guide? It's easy, I know, but I'm
shamed when I forget some step and face this kind of trouble... I'm using a
Open Office document as checklist when making backups to not forget any step
;-)
Well the steps that work for me (using DBM Gui, in Windows, or WebDBM in any
plataform):
1) Certify that you have a migration copy of database or a recovery
copy+logs;
2) Drop database (if he still there); You could do it using wizard or
dbmcli. My preference is doing it by dbmcli:
C:\> dbmcli -u dbm,dbm -d MyDatabaseInstance
C:\> dbmcli on MyDatabaseInstance> db_drop
3) In database Wizard, ask for a New Instance, then, in "parameter
configuration" ask for "Restore config from Database"; he will ask you what
backup media should be used. Point your backup file.
4) In final steps, you'll have a choice to Install or Restore. Select
Restore.
You can be crazy if you think that option Restore will
restore your database. It will not. You will have additional steps. This
options only tell to SapDB that YOU will restore the database in the future,
so it should not be activate automatically.
5) Now, your database is "cold". Don't try to start. If you do it, will give
you an -248.. something error. Go direct to Restore Database option. Restore
your backup and additional logs.
6) Start database now.
I think that is all. I think that a large majority of starters with SapDB
will search the Admin guide just bellow these steps. It could be in a
chapter like "Step-by-step commom admin taks"...
Just M2c,
Edson Richter
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.465 / Virus Database: 263 - Release Date: 25/3/2003
smime.p7s
Description: S/MIME cryptographic signature
