Prorest: trying to access control area in wrong dir

Rob Fitzpatrick

Rob Fitzpatrick

ProgressTalk.com Sponsor
I'm experiencing a strange error: I have two boxes, call them prod and dr. A probkup of the DB on prod runs fine, and the resulting backup can be successfully restored to some other directory on prod. However when I try to restore the same good backup file on dr, I get errors.

Code: 
dr:/path/to/db/dir # prorest proddb ../backup/proddb_2011-12-20.pbk 
** Cannot find or open file /proddb.db, errno = 2. (43) 
Unable to read master block, file = proddb, errno = -1. (6070) 
** Cannot find or open file /proddb.db, errno = 2. (43) 
** Cannot find or open file /proddb.db, errno = 2. (43)

For some reason it is trying to open the control area in the root directory, rather than the current directory. The current directory is empty, so it is using the structure in the backup.

Also, for an existing DB on dr, it can be started and stopped fine, but a prostrct add or a prostrct list gives similar errors (can't find or open file /proddb.db). At this point it is looking like a setup or permissions issue on dr, and we are comparing its configuration to prod.

Has anyone encountered this, or do you have any suggestions?

Both systems run 10.2B02 Enterprise on AIX 6.1.
 
What happens if you put a proper .st file in place prior to the restore? (rather than depending on the backup to provide it)
 
I haven't tried that, but it seems to be finding the backup file OK.

Strange update: specifying a fully-qualified path to the database makes the prorest succeed. E.g.: prorest /path/to/db/dir/proddb ../backup/proddb_2011-12-20.pbk
 
I'm sure you would have. :) The $64 question, however, is why do I need to provide information that I shouldn't have to provide (and don't have to provide on other platforms) to get this to work? :confused:
 
Good question. It's a client system, so we'll have to schedule another support session with them. If I can repro with sports, then that eliminates "weird corruption in prod DB" as a possible cause. Now that you mention it, I should have another read of the SP05 release notes. I don't remember any issues like this related to prorest, but it doesn't hurt to look.

I've asked my tech to open a case with support. We'll see what they say.
 
You must log in or register to reply here.
Back
Top