Group,

I'm restoring a multi-volume database from a UFS dump. I need to
restructure it. I got all the extents and modified the structure file to
point to their correct locations. When I run "prostruct repair mydb" I get
the following error:
Error: Repair for file /mypath/mydb.db cannot add or delete entries

I did solve this once, but forgot what I did. It's not permissions, or at
least none that I can see. I own everything, including the directory
containing the .db and st files. I've tried it in a couple of directories,
and still get the same error. This is the last database of 12 that I've
restored to backup for monthly archives. The creep that I replaced didn't
do any monthly archives - much to the chagrin of the accountants.

Any help appreciated,
Julie

Group,

Never mind, I have the answer. I was attempting to move the Before Image
file and added a line to the structure file. By changing the structure, I
obviously required a change to the database file to point to the new
location for the .bi file. The error now seems very clear to me.

Sincerely Oops,
Julie



Julie Warden <Julie_Warden@spamfreeHotmail.com> wrote in
news:Xns96AFA08A5977AJulieWarden@140.99.99.130:

> Group,
>
> I'm restoring a multi-volume database from a UFS dump. I need to
> restructure it. I got all the extents and modified the structure file
> to point to their correct locations. When I run "prostruct repair
> mydb" I get the following error:
> Error: Repair for file /mypath/mydb.db cannot add or delete entries
>
> I did solve this once, but forgot what I did. It's not permissions, or
> at least none that I can see. I own everything, including the
> directory containing the .db and st files. I've tried it in a couple
> of directories, and still get the same error. This is the last
> database of 12 that I've restored to backup for monthly archives. The
> creep that I replaced didn't do any monthly archives - much to the
> chagrin of the accountants.
>
> Any help appreciated,
> Julie
>

Julie Warden <Julie_Warden@spamfreeHotmail.com> wrote in
news:Xns96AFA08A5977AJulieWarden@140.99.99.130:

> Group,
>
> I'm restoring a multi-volume database from a UFS dump. I need to
> restructure it. I got all the extents and modified the structure file
> to point to their correct locations. When I run "prostruct repair
> mydb" I get the following error:
> Error: Repair for file /mypath/mydb.db cannot add or delete entries
>
> I did solve this once, but forgot what I did. It's not permissions, or
> at least none that I can see. I own everything, including the
> directory containing the .db and st files. I've tried it in a couple
> of directories, and still get the same error. This is the last
> database of 12 that I've restored to backup for monthly archives. The
> creep that I replaced didn't do any monthly archives - much to the
> chagrin of the accountants.
>
> Any help appreciated,
> Julie
>

Before doing the restore, use prostrct create to create the new
structure, then restore the db into it.. If the structure already
exists, you need to use prostrct add to add new extents to the existing
db.

Kevin