Imported Restore

Hi All, I am performing restore from our PROD to a DEV env. The configurations of dbspaces are equal and the same on both servers (DEV and PROD). I copied the ixbar .xxx and oncfg.ifxxxx and onconfig.xxx into our DEV environment. I tried a FULL restore but i'm getting error below: 2010-08-08 21:13:38 884836 233686 /appl/informix/bin/onbar_d complete, returning 149 (0x95) 2010-08-08 21:14:45 884846 815282 /appl/informix/bin/onbar_d -r -p -t 2010-07-28 23:00:00 rootdbs0000 2010-08-08 21:14:45 884846 815282 Working with veritas-netbackup as generic storage manager. 2010-08-08 21:14:45 884846 815282 ASSERT: file bar_unix.c line 1253 - contact product support 2010-08-08 21:14:45 884846 815282 See also: /appl/informix/log/core I did try to change the GLS_DATETIME but it doesn't work. I did add the export BAR_BSALIB_PATH=/usr/lib/ibsad001.so, but no luck... I tried, onbar -r -p -t "2010-07-28 23:00:00" -- same error. onbar -r -t "2010-07-28 23:00:00" -w, same error. On the Netbackup side, there's no queueing of job. Thanks and hoping someone can help me on this right-away... Best Regards,

got this documentation from the net and i followed all the steps but still wasn't able to restore: ------------------------------------------------------------ Using VERITAS NetBackup for Informix to restore an alternate client, also known as a redirected restore or an import restore to a different computer. ________________________________________ Details: 1. If possible, on the source host, back up the logical logs if the server is up. Salvage the logical logs if the source server is down. 2. Shut down the database servers on both hosts. 3. Copy the appropriate configuration files from the source host to the destination host as per Informix documentation. ixbar.servernum oncfg._servername.servernum sqlhosts file ONCONFIG file 4. Change the server name and server number to the values for the destination database server. 5. Set and export the environmental variable INFXBSA_CLIENT to the name of the source host as configured in NetBackup. Note: Do not change the setting of CLIENT_NAME in either the client /usr/openv/netbackup/bp.conf file or the user bp.conf file to the backup source host name. The client Informix user bp.conf is located in the Infomix user home directory. CLIENT_NAME should be set in the client /usr/openv/netbackup/bp.conf file to the target client NetBackup configured name. If CLIENT_NAME is set in the client user bp.conf file, that setting will take precedence over the setting in the client /usr/openv/netbackup/bp.conf file. In this case, there is no reason to superseded the default setting in the /usr/openv/netbackup/bp.conf. 6. Set the appropriate entries in the NetBackup master server /usr/openv/netbackup/db/altnames directory to allow the target host to restore backups from the source host. 7. On the target host, ensure that you can now list the backup files from the source host. Enter the following command to see all such backups: /usr/openv/netbackup/bin/bplist -C "source configured name" -t 6 -R /. Replace "source configured name" above with the NetBackup client name of the Informix host that is the source of the backups. If you can see the backup dbspaces and logs, you should now be ready to restore to the alternate client. 8. Perform the restore with the following commands: onbar -r -p onbar -r -lThe above sequence of two onbar commands will prevent the target server from trying to salvage its own logical logs prior to the restore as would be the case with a simple "onbar -r". For example, if the Informix source host is configured in NetBackup with the name "production" and the target host is configured in NetBackup with the name "test", run the above NetBackup commands as follows. On the master server, create a file /usr/openv/netbackup/db/altnames/test with the contents of the file "test" being the single entry "production", without the quotes. On the host test, after preparing Informix for the restore, run the following commands for the Bourne shell: INFXBSA_CLIENT = production ; export INFXBSA_CLIENT /usr/openv/netbackup/bin/bplist -C production -t 6 -R / # note the list of Informix backups from the host production # the NetBackup client for Informix will pick up the variable INFXBSA_CLIENT, bplist will not. onbar -r -p onbar -r -l The restore of the backup is now complete. ---------------------------------- What might be the problem???????? I'm stucked for 4 days now on doing this.. It looks simple but can't make it through...

Hi All, After so many tries, here comes the solution i found: Problems: 1. Can't restore just "onbar -r -p" or else you will get segmentation fault.. You can do a per dbspace restore like onbar -r -p phylogdbs logdbs1 logdbs2 rootdbs....... 2. If your ixbar.xxx, is too big, the onbar might or will not be able to handle it... e.g. 100MB size... Best solution is trim the file to the date you want to restore. and then, redo the onbar -r -p dbspaces......

what os / ids / nbu do you use? we are doing an imported restore from prod to dev with aix 5.3 / ids 10.00.uc10 / veritas nbu 6.5 ... and "onbar -b -r" works very properly with or without editing the ixbar file. A list of dbspaces can be specified as well as restoring the entire server.