Hello Albert and Remsang,

db_activate in 7.5 a combination.

In 7.4
Step1) util_execute init config
+
either
Step2) db_activate ...
or
Step2) recover_data ...

These two steps were combined to db_activate [RECOVER].

So you have to use db_activate RECOVER ....
which initializes the volumes (clears the log too) and recovers the given data backup.

Kind regards
Uwe

-----Urspr�ngliche Nachricht-----
Von: Albert Steckenborn [mailto:[EMAIL PROTECTED] 
Gesendet: Montag, 22. Dezember 2003 10:28
An: [EMAIL PROTECTED]
Betreff: Re: create new db instances from data backup.

Hi,

think, activate with recover in one step will not work. Hope this will 
work better:
++++++++++++++++++++++++++++++++++++++++++++++++++
echo db_activate %uDBA%,%uDBAPW% >> param.tmp
echo recover_start completeFile DATA >> param.tmp
echo util_execute clear log  >> param.tmp
++++++++++++++++++++++++++++++++++++++++++++++++++


rgds.

Albert

RemsangPulamte schrieb:
> Hi Albert & all
> "util_execute clear log " do enable us to make the db instance to online state. But 
> as  Stephen pointed out the data pages are not visible even then.
> 
> Further, trying to access the db properties or on trying to connect to the db, it 
> gives an error msg below:
> -24988 sql error [info STATE -d]
> -4004, Msg not available: INFO_STATE.
> 
> Here db_state returns "ONLINE"
> 
> regds
> Remsang Pulamte
> 
> ----- Original Message ----- 
> From: "Albert Steckenborn" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, December 21, 2003 5:24 PM
> Subject: Re: create new db instances from data backup.
> 
> 
> 
>>Hi,
>>
>>I've seen nothing about restore of LOG-Files???
>>Of course a "util_execute clear log" after recover will help.
>>
>>rgds.
>>
>>Albert Steckenborn
> 
> 
> 
> 


-- 
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]

Reply via email to