Informix Restore on Tru64
Posted in 2006
Topics: Backup & Restore, Storage & Space Management
Hi , I try to restore the informix database, i am getting the below error message. 2006-05-26 12:22:26 4344 4342 /informix/AGT/bin/onbar_d -r -p rootdbs 2006-05-26 12:22:27 4344 4342 Successfully connected to Storage Manager. 2006-05-26 12:23:29 4344 4342 Begin cold level 0 restore rootdbs. 2006-05-26 12:23:30 4344 4342 ERROR: Unable to write restore data to the database server: Error opening file /informix/LGX/sapdata/physdev3/data3. errno=2. 2006-05-26 12:23:30 4344 4342 WARNING: Skipped backup/restore of space 'rootdbs'. 2006-05-26 12:23:35 4344 4342 ERROR: Unable to start the physical restore: Archive API error: already open. 2006-05-26 12:23:40 4344 4342 Due to the previous error, logical restore will not be attempted. 2006-05-26 12:23:40 4344 4342 /informix/AGT/bin/onbar_d: process exit 131 (0x83) Any idea why. Thanks Karthik 510 744 6206
On 26 May 2006 12:34:05 -0700, "Karthik" <karthikeyan.sadanandam@gmail.com> wrote: >Hi , > I try to restore the informix database, i am getting the below error >message. > > 2006-05-26 12:22:26 4344 4342 /informix/AGT/bin/onbar_d -r -p rootdbs > 2006-05-26 12:22:27 4344 4342 Successfully connected to Storage >Manager. > 2006-05-26 12:23:29 4344 4342 Begin cold level 0 restore rootdbs. > 2006-05-26 12:23:30 4344 4342 ERROR: Unable to write restore data to >the database server: Error opening file >/informix/LGX/sapdata/physdev3/data3. > errno=2. > 2006-05-26 12:23:30 4344 4342 WARNING: Skipped backup/restore of >space 'rootdbs'. > 2006-05-26 12:23:35 4344 4342 ERROR: Unable to start the physical >restore: Archive API error: already open. > 2006-05-26 12:23:40 4344 4342 Due to the previous error, logical >restore will not be attempted. > 2006-05-26 12:23:40 4344 4342 /informix/AGT/bin/onbar_d: process exit >131 (0x83) > >Any idea why. > what is the status of /informix/LGX/sapdata/physdev3/data3? Is this a link -- if so, does the target exist? What are the permissions and owner set to? JWC
Hi, Yes it is the link. Below is the permission information. lrwxrwxrwx 1 root informix 22 May 24 22:47 data3 -> /dev/rvol/dbdg/INFRAW4 If i go to /dev/rvol/dbdg root@phoenix: /dev/rvol/dbdg # ls -ltr total 0 crw-rw---- 1 informix informix 40,3000 May 25 23:00 btab-A24R crw-rw---- 1 informix informix 40,3001 May 25 23:00 btab-A25R crw-rw---- 1 informix informix 40,3002 May 25 23:00 btab-A26R crw-rw---- 1 informix informix 40,3003 May 25 23:00 btab-A27R crw-rw---- 1 informix informix 40,3004 May 25 23:00 btab-A28R crw-rw---- 1 informix informix 40,3005 May 25 23:00 btab-A29R crw-rw---- 1 informix informix 40,3006 May 25 23:00 btab-A30R crw-rw---- 1 informix informix 40,3007 May 25 23:00 btab-A31R crw-rw---- 1 informix informix 40,3008 May 25 23:00 btab-A32R crw-rw---- 1 informix informix 40,3009 May 25 23:00 btab-A33R crw-rw---- 1 informix informix 40,3010 May 25 23:00 btab-A34R Thanks karthik
Karthik wrote: > Hi, > Yes it is the link. Below is the permission information. > > lrwxrwxrwx 1 root informix 22 May 24 22:47 data3 -> > /dev/rvol/dbdg/INFRAW4 > > If i go to /dev/rvol/dbdg > > root@phoenix: /dev/rvol/dbdg # ls -ltr > total 0 > crw-rw---- 1 informix informix 40,3000 May 25 23:00 btab-A24R > crw-rw---- 1 informix informix 40,3001 May 25 23:00 btab-A25R > crw-rw---- 1 informix informix 40,3002 May 25 23:00 btab-A26R > crw-rw---- 1 informix informix 40,3003 May 25 23:00 btab-A27R > crw-rw---- 1 informix informix 40,3004 May 25 23:00 btab-A28R > crw-rw---- 1 informix informix 40,3005 May 25 23:00 btab-A29R > crw-rw---- 1 informix informix 40,3006 May 25 23:00 btab-A30R > crw-rw---- 1 informix informix 40,3007 May 25 23:00 btab-A31R > crw-rw---- 1 informix informix 40,3008 May 25 23:00 btab-A32R > crw-rw---- 1 informix informix 40,3009 May 25 23:00 btab-A33R > crw-rw---- 1 informix informix 40,3010 May 25 23:00 btab-A34R > > > > Thanks > karthik > BUT ... there is no INFRAW4 :P i.e. The rootpath is : /informix/LGX/sapdata/physdev3/data3 which is a link to : /dev/rvol/dbdg/INFRAW4 However ... /dev/rvol/dbdg/INFRAW4 does not exist.
On 26 May 2006 15:02:40 -0700, "Karthik" <karthikeyan.sadanandam@gmail.com> wrote: >Hi, > Yes it is the link. Below is the permission information. > >lrwxrwxrwx 1 root informix 22 May 24 22:47 data3 -> >/dev/rvol/dbdg/INFRAW4 > >If i go to /dev/rvol/dbdg > >root@phoenix: /dev/rvol/dbdg # ls -ltr >total 0 >crw-rw---- 1 informix informix 40,3000 May 25 23:00 btab-A24R >crw-rw---- 1 informix informix 40,3001 May 25 23:00 btab-A25R >crw-rw---- 1 informix informix 40,3002 May 25 23:00 btab-A26R >crw-rw---- 1 informix informix 40,3003 May 25 23:00 btab-A27R >crw-rw---- 1 informix informix 40,3004 May 25 23:00 btab-A28R >crw-rw---- 1 informix informix 40,3005 May 25 23:00 btab-A29R >crw-rw---- 1 informix informix 40,3006 May 25 23:00 btab-A30R >crw-rw---- 1 informix informix 40,3007 May 25 23:00 btab-A31R >crw-rw---- 1 informix informix 40,3008 May 25 23:00 btab-A32R >crw-rw---- 1 informix informix 40,3009 May 25 23:00 btab-A33R >crw-rw---- 1 informix informix 40,3010 May 25 23:00 btab-A34R > > But where is INFRAW4 ??? All I see are the btab-A??R files . . . . JWC