Is the location of the file in the error message where you actually find the file (in the "ls")? 2. However, if you restore just the critical dbspaces, the restore leaves all other chunks in an "inconsistent" state, as specified by the "I" flag that they display after the restore is Read 17 March 2010 - Virtualization Review - ...key components of Big Blue's platform to the commercial cloud such as its WebSphere suite of application ser vers and its DB2 and regards, Nitin Hi nitin_math, This is the output bar_act.log 2010-04-09 17:01:06 26329 26327 /usr/informix/bin/onbar_d -r -w 2010-04-09 17:01:11 26329 26327 Successfully connected to Storage Manager. 2010-04-09 17:01:11 26329 26327 XBSA Error: his comment is here
Specifically, the logical restore was done in such a way that the permissions from the level-0 archive of the rootdbs were not correct when the logical restore requested access to the My chunks are not mirrored. Read 17 March 10 - ZDNet (blog) David Morgenstern - TCO: New research finds Macs in the enterprise easier, cheaper to manage than... Any help is very appreciate, Thank you for you help Reply With Quote 04-13-10,03:19 #4 nitin_math View Profile View Forum Posts Registered User Join Date Nov 2004 Posts 143 Hi, Please http://www-01.ibm.com/support/docview.wss?uid=swg21430054
Archive level 0 is always successful. Read 2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... I will try again. Or am I on the wrong path here?
Read 12 Oct 10 - Database Trends and Applications - Informix 11.7: The Beginning of the Next Decade of IBM Informix... Read 11 Jan 12 - Computerworld - Ecologic Analytics and Landis+Gyr -- Suitors Decide to Tie the Knot... Informix support does have a tool that will change this flag to consistent, but your mileage will vary on this one. http://members.iiug.org/forums/ids/index.cgi/read/16773 All rights reserved.
Read 22 Mar 12 - developerWorks - Optimizing Informix database access... Somebody can tell me what is the procedure for restore an instance or database. Also, can you please post the copy of bar log & message log. In this version, the root reserved pages are read to build a list of dbspaces, chunks, and log files needing to be restored.
Gustavo. $ onspaces -s dm2sysdbs -p /dev/informix/ldm2sys01 -o 0 -O The chunk specified does not exist. $ ls -l /dev/informix/ldm2sys01 lrwxrwxrwx 1 root system 14 Dec 08 2004 /dev/informix/ldm2sys01 -> /dev/rdm2sys01 https://groups.google.com/d/topic/comp.databases.informix/J6S30KhM_NM Read 21 May 10 - CNET - IBM to help people monitor energy use... I cannot believe this is an unprecedented scenario, that there's no better way of dealing with this. Greetings all, I am in a situation where sysmaster and sysutils were accidentally rebuilt, causing the originals to b e dropped.
The System Operative is Suse Linux Enterprise Server, IDS 11.50. this content Was something added to online.log that might shed some light. 4. also the files sm_versions, onconfig, sqlhosts, ixbar.server and oncfg.server_number and files from /home/dbspaces and files from /home/logfiles. There are ways of recovering your data if you haven't reused any of the disk space this instance previously used.
Using OnBar -v to verify the backup also return 96. hi, as you said i tried it that way(restoring all critical dbspaces and then sbspace, datadbs) , it was working fine! The set probably does not exist.17:38:38 : (26808) IBK-bsa: [Critical] From: [email protected] "indb_pri" Time: 09/21/11 17:38:381517:38:38 : (26808): IBK-bsa : [Critical] Bad calling sequence.17:38:38 : (26808) IBK-bsa: [Critical] From: [email protected] "indb_pri" weblink If the ROOT DBspace or a DBspace containing the physical log or a logical log file is restored, then the ROOT DBspace and all DBspaces containing a logical log file or
In bar_act.log we obtain such message : ERROR: No response was received from the database server. You don't have to bounce the server, this takes effect when the Onbar command is executed. -Abraham I was looking for the onconfig answer, so thank you to you both. and i can see all the backup sets with [bplsit].
What are the chances of recreating sysmaster and sysutils from what's available on the raw devices? regards, Georgi. Re: ONBAR point-in-time recovery fails (views: 989)Art Kagel -- Monday, 24 August 2009, at 10:11 a.m. [ View Thread ] [ Post Response ] [ Return to Index ] [ Read Salvaging of existing logical logs must be performed, if it is possible to save latest transactions that resides on logical log and is not backuped by onbar.
Have a look at below post on IIUG International Informix Users Group It might help you regards, Nitin Regenerate sysmaster and sysutils, Informix 7.x? Somebody can tell me what is the procedure for restore an instance or database. But this time depends on the CPU type, we noticed. check over here If you are restoring a critical dbspace, you should really restore the whole thing." ...Which seems to indicate I would need an Informix consultant's tool to finish the job.
thanks informixwili for your response!, but does it mean that I can't restore a single dbspace, everytime I have to select all critical dbspaces for restoration?! Read 25 Jan 11 - PR Newswire - Bank of China in the UK Works With IBM to Become a Smarter, Greener Bank... without doubt,the backup is successful. I will escalate with them.
Have a look at below post on IIUG International Informix Users Group It might help you regards, Nitin How to Move Log File... Thanks in advance, Josh There are two paths you can go here. When I clicked on ON-BAR on the left nav bar, I only see the error. And the ultimate rub, this site has no DBA, no sysadmin, no skills, and you guessed it, no backups!
Hi Colleagues, I need restore an instance in other machine, the backup is with onbar. You may have to register before you can post: click the register link above to proceed. check bar_act.log, i find "XBSA Error(BSABeginTxn): A system erroroccurred. yes, I have rechecked every thing!
Read 11 Mar 11 - InvestorPlace - It's Time to Give IBM Props: How many tech stocks are up 53% since the dot-com boom?... Are there other onbar or storage manager processes open? the database is down.. I'm not sure when this parameter is read (ie once at startup or whenever needed) so you may need to bounce Informix to get the new path to take effect.
I think we got a dud on the phone. Somebody can tell me what is the procedure for restore an instance or database. I have been told that only IBM (INFORMIX) can resolve this issue. When version 11.10 was released, there were many changes to how archives worked internally.
copy the ixbar.