Can I recover the schema from partially deleted database ?

Posted by cverbiest on 28-Nov-2016 06:38

I have a type II oe 11.6 database where some data extents are missing.

I'm only interested in the df of this database and I still have the default area.

can I recover this db enough to do that ?

This is the output of ls for all extents

ls: cannot access /usr2/cce/schema/data/LISA_12.d1: No such file or directory
ls: cannot access /usr2/cce/schema/data/LISA_22.d1: No such file or directory
ls: cannot access /usr2/cce/schema/data/LISA_30.d1: No such file or directory
ls: cannot access /usr2/cce/schema/data/LISA_31.d1: No such file or directory
ls: cannot access /usr2/cce/schema/data/LISA_32.d1: No such file or directory
-rw-rw-rw-. 1 proadmin cce   34734080 Nov 28 08:55 /usr2/cce/schema/data/LISA_10.d1
-rw-rw-rw-. 1 proadmin cce  139591680 Nov 28 08:55 /usr2/cce/schema/data/LISA_11.d1
-rw-rw-rw-. 1 proadmin cce  243793920 Nov 14 12:23 /usr2/cce/schema/data/LISA_20.d1
-rw-rw-rw-. 1 proadmin cce 1128267776 Nov 14 11:00 /usr2/cce/schema/data/LISA_21.d1
-rw-rw-rw-. 1 proadmin cce    2228224 Nov 14 12:36 /usr2/cce/schema/data/LISA.b1
-rw-rw-rw-. 1 proadmin cce   15597568 Nov 28 08:55 /usr2/cce/schema/data/LISA.d1
-rw-rw-rw-. 1 proadmin cce     655360 Jun 29 22:31 /usr2/cce/schema/data/LISA.db

OpenEdge RDBMS - Forum
Posted by George Potemkin on 28-Nov-2016 06:57

Make the copies of the LISA.db file as LISA_12.d1, LISA_22.d1 and other lost files.

All Replies

Posted by Paul Koufalis on 28-Nov-2016 06:56

I think prostrct unlock will do what you need.

Paul


Posted by Valeriy Bashkatov on 28-Nov-2016 06:56

You can use PROSTRCT UNLOCK with "-extents" parameter:

prostrct unlock db-name -extents

-extents, replaces missing extents with empty extents if any database files are missing.

Posted by George Potemkin on 28-Nov-2016 06:57

Make the copies of the LISA.db file as LISA_12.d1, LISA_22.d1 and other lost files.

Posted by cverbiest on 28-Nov-2016 08:02

Thanks for all the answers.

I managed to do it with prostrct unlock, see below, probably used too many steps.

Tested George approach and that works as well

step 1. create st file from db with prostrct list

in a new directory

step 2. create new db,with the same structure in a different location using  procopy $pathtoemptydb LISA

step 3. copy what was left of the db over the new db, except for the .db file

step 4. prostrct unlock LISA  -extents

found in http://knowledgebase.progress.com/articles/Article/000017486

step 5. pro LISA -p dict and dump the df

This thread is closed