dbTalk Databases Forums  

HELP! v7 Prostrct repair question

comp.databases.progress comp.databases.progress


Discuss HELP! v7 Prostrct repair question in the comp.databases.progress forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Julie Warden
 
Posts: n/a

Default HELP! v7 Prostrct repair question - 08-11-2005 , 02:46 PM






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

Reply With Quote
  #2  
Old   
Julie Warden
 
Posts: n/a

Default Never mind, I just got the answer! - 08-11-2005 , 02:57 PM






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 (AT) spamfreeHotmail (DOT) com> wrote in
news:Xns96AFA08A5977AJulieWarden (AT) 140 (DOT) 99.99.130:

Quote:
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



Reply With Quote
  #3  
Old   
Kevin
 
Posts: n/a

Default Re: HELP! v7 Prostrct repair question - 08-12-2005 , 12:17 AM



Julie Warden <Julie_Warden (AT) spamfreeHotmail (DOT) com> wrote in
news:Xns96AFA08A5977AJulieWarden (AT) 140 (DOT) 99.99.130:

Quote:
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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.