Re: Backup question

Hi,

I've posted this before... I don't know whether it's the right way to 
go, but it works for me :-)
Before trying to recover the medium, do a full data backup into a dummy 
backup device. This will clear/initialize the backup history. After that 
you can restore your backup medium.
Arne

Matteo Gattoni wrote:

> Hello,
>   I don't know if I understand what you have said.
> To create a new istance I do the following:
> a) 
> export PATH=/tmp/sdb/programs/bin:$PATH
> export LD_ASSUME_KERNEL=2.2.5
> b) # start remote communication server
> x_server start >/dev/null 2>&1
> c) # stop and drop probably existing demo database
> dbmcli -d TEST2 -u root,root db_offline >/dev/null 2>&1
> dbmcli -d TEST2 -u root,root db_drop >/dev/null 2>&1 
> d) # create new database
> dbmcli -s -R  /tmp/sdb/7500 db_create TEST2 root,root 2>&1
> e) # setup database parameter
> cat <<EOF | dbmcli -d TEST2 -u root,root 2>&1
> param_rmfile
> param_startsession
> param_init OLTP
> param_put CAT_CACHE_SUPPLY 600
> param_put CACHE_SIZE 6000
> param_put MAXDATAVOLUMES 5
> param_put _PACKET_SIZE 131072      
> param_checkall
> param_commitsession
> param_addvolume 1 DATA DISKD0001 F 12800
> param_addvolume 1 LOG  DISKL001  F 5120
> quit
> EOF
> f) # startup database
> dbmcli -d TEST2 -u root,root db_admin 2>&1
> g) # initialize database files
> cat <<EOF | dbmcli -d TEST2 -u root,root 2>&1
> util_connect root,root
> db_activate dba,dba
> quit
> EOF
> h) # load database system tables
> dbmcli -d TEST2 -u root,root load_systab -u dba,dba -ud domain 2>&1
> i) # create database user PSF
> cat <<EOF | dbmcli -d TEST2 -u dba,dba
> sql_connect dba,dba
> sql_execute CREATE USER TEST PASSWORD TEST DBA NOT EXCLUSIVE
> quit
> EOF    
>
> Than I try to recover a backup medium with DBM GUI (Recovery-> Recovery Wizard).
> Or with dbmcli with statement 
>                 recover_start TeBa DATA 
>
> First time, I saw that, even if I said that, point f), to put the istance in 
> admin status, at the end I found the istance in onlin status.
> So, the second time, I stop executing the step at point e). But, with dbmcli I 
> receive the error:
>             ERR
>             -24992,ERR_NOUTILSESSION: no utility session available
> and with DBM GUI still remains the error
>             -24988 sql error [db_activate RECOVER "TB" DATA]; -9026, System 
> error: DB Bad datapage, bada restart record
>
> Each operation was done with root user.
>
> What do you mean with "Here you should choose "Restore instance for recovery""?
> Could you explain a little longer how the correct way would be?
>
> Sorry for misunderstanding.
> Thanks a lot,
> Matteo
>
> ----- Original Message ----- 
> From: "Döhr, Markus ICC-H" <Markus.Doehr@xxxxxxxxxxxxxxxxx>
> To: "'Matteo Gattoni'" <matteo.gattoni@xxxxxxxxx>; <maxdb@xxxxxxxxxxxxxxx>
> Sent: Wednesday, September 29, 2004 5:43 PM
> Subject: RE: Backup question
>
>
>
> > 3)Recovery-Recovery Wizard
> Here you should choose "Restore instance for recovery". If the DB comes
> online it will write a timestamp into the logarea and your restored DB will
> not work with this logpage.
>
> The correct way would be:
>
> - Create Instanz (new or initialize)
> - NEVER bring it to online mode (just to admin)
> - restore from backup
> - bring to online mode
>
>
> Greetz,
>
>
> SIEGENIA-AUBI KG
> Informationswesen
>  
> i.A.
>  
> Markus Döhr
> SAP-CC/BC, SAPDB-DBA
>
> Tel.: +49 6503 917-152
> Fax: +49 6503 917-7152
> E-Mail: markus.doehr@xxxxxxxxxxxxxxxxx
> Internet: http://www.siegenia-aubi.com 
--
Institut fuer Seeverkehrswirtschaft und Logistik    http://www.isl.org/
Arne Gehlhaar                                   mailto:gehlhaar@xxxxxxx
Universitaetsallee GW1 Block A                     tel:+49 421 22096-49
D-28359 Bremen                                     fax:+49 421 22096-55

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx