Michael Schwind wrote:

> Hi,
> 
> trying to recover a database from a complete consistent backup, I do the
> following:
> The recovery process seems to run just fine, but I can't switch the database
> to WARM. BTW,
> I try to do this right after creating a database called xxx with a slightly
> modified create_demo_db.sh script. knldiag.err says:
> 
> 
> 2002-02-01 10:34:57 13786 ERR 52444 LOG      db_ident mismatch
> 
> 
> 
> Thanks for any help.
> 
> Michael
> 
> 
> ./dbmcli on xxx>db_cold
> OK
> 
> ---
> ./dbmcli on xxx>backup_media_put rec /tmp/xxx_backup20020201 FILE DATA 0 8
> YES
> OK
> 
> ---
> ./dbmcli on xxx>util_connect dbm,dbm
> OK
> 
> ---
> ./dbmcli on xxx>recover_start rec
> OK
> Returncode              0
> Date                    20020201
> Time                    00103447
> Server                  yyy
> Database                xxx
> Kernel Version          Kernel    7.3.0    Build 015-000-070-620
> Pages Transferred       1072
> Pages Left              0
> Volumes                 1
> Medianame               rec
> Location                /tmp/xxx_backup20020201
> Errortext
> Label                   DAT_00099
> Is Consistent           true
> First LOG Page          18612
> Last LOG Page
> DB Stamp 1 Date         20020201
> DB Stamp 1 Time         00020001
> DB Stamp 2 Date
> DB Stamp 2 Time
> Page Count              1056
> Devices Used            1
> Database ID             cysrv07:xxx_20020109_160301
> Max Used Data Page      2425
> 
> ---
> ./dbmcli on xxx>db_warm
> ERR
> -24988,ERR_SQL: sql error
> -8003,Message not available



Two things:
  - remove the util_activate dba,dba from your creation script
  - do not warm the instance at the end of the creation.


> 
> ---
> ./dbmcli on xxx>
> 
> _______________________________________________
> 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

Reply via email to