Informix Cannot Read Reserved Pages From Rootdbs Object
RE: ONBAR point-in-time recovery fails (views: 1185)Andrew Grantham -- Monday, 24 August 2009, at 8:11 a.m. And we don't have to bckup every day. Read 1 Aug 11 - IBM Data Management Magazine - IIUG user view: Happy 10th anniversary to IBM and Informix... 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:
all though while full restore or with the combination of other dbspaces it doesn't give any error of this kind.... Is this procedure the right one: onbar -r -p -n 23754 onbar -r -l -n 23754 Regards Jimmy Jonsson Messages In This Thread ONBAR point-in-time recovery fails (views: 2410)JIMMY JONSSON -- Thank you, Not quite sure what you meant, so I'll give you two difference answers.
I'm a DBA in Oracle, SqlServer, etc, but have an Informix database I'm trying to manage. We actually recently contacted IBM for this, and the support human said it could not be done, even if all the raw devices were pristine. regards, Georgi. In developer server I define the same dbspaces with the same chunks but with raw devices.
In what mode will be the engine in server developer to do restore? Is there a way to force these dbspaces on-line ? onstat -d and onstat -l says: onstat -d IBM Informix Dynamic Server Version 11.70.TC1IE -- On-Line -- Up 00:00:31 -- 7 8208 Kbytes Dbspaces address number flags fchunk nchunks pgsize flags http://members.iiug.org/forums/ids/index.cgi/read/16773 Source: Cold restore I you only want to restore a non critical dbspace you could make a warm restore (the database must be online): onbar -r -O sbspace datadbs Restore instance.
Here are some of those reasons: file system where SM log file resides is full required SM environment variable is not set required SM environment variable is set incorrectly this SM Read 9 Mar 11 - DBTA - Database Administration and the Goal of Diminishing Downtime... How do they lure the college crowd?... Read 10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?...
One of those changes was in how the engine determined which dbspaces, chunks, and logs needed to be restored. https://groups.google.com/d/topic/comp.databases.informix/J6S30KhM_NM In developer server I define the same dbspaces with the same chunks but with raw devices. Once time I have copy all files in server developer with engine offline as user informix i execute onbar -r -w in file bar_act.log are errors. Also, can you please post the copy of bar log & message log.
I am now trying to restore the database onto another server to recover the tables that got wiped out. http://pgexch.com/informix-cannot/informix-cannot-write-blob.html Read 1 Feb 12 - developerWorks - 100 Tech Tips, #47: Log-in to Fix Central... I suspected this much was the case. Have a look at below post on IIUG International Informix Users Group It might help you regards, Nitin How to Move Log File...
What is the form to execute the backup or restore with onbar? yes, I have rechecked every thing! Read 20 Sep 10 - planetIDS.com - ITG analyst paper: Cost/Benefit case for IBM Informix as compared to Microsoft SQL Server... navigate here Its not possible to make it in another way.
Also, can you please post the copy of bar log & message log. I am sure the raw devices which contain the database are still intact - they are visible and online with vgdisplay, lvdisplay, etc. 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
Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"...
Read 27 Jan 11 - exactsolutions - Exact to Add Informix Support to Database Replay, SQL Monitoring Solutions... Is the database really down? Hi, Please test the permissions of all path. Hi, I have never done a restore on Linux, but I think, it should be similar to AIX (Machines, OS & Informix version should be identical ).
The backup is with onbar and Informix Storage Manager (ISM). This is exactly what this poor Oracle DBA needs... I might be forgetting something, but you can still give it a go and fix the issue on the run. :-) Nitin Hi nitin_math, Thank you for you help, I have Somebody can tell me what is the procedure for restore an instance or database.
Read 01 Feb 13 - IBM Data Magazine - Are your database backups safe? Read 2 Feb 11 - DBTAs - Informix 11.7 Flexible Grid Provides a Different Way of Looking at Database Servers... If this is a temporary dbspace chunk, drop and add the dbspace to enable it. 16:56:40 See Also: af.3ee01c0 16:56:40 chunk failed sanity check 16:56:41 I/O error, Primary Chunk 'E:\IFMXDATA\ol_absrv\rootdbs_dat.000' -- Somebody can tell me what is the procedure for restore an instance or database.
The System Operative is Suse Linux Enterprise Server, IDS 11.50. Hi Colleagues, I need restore an instance in other machine, the backup is with onbar. Read 23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... By looking into the file ixbar.0 i have figured out that i need to restore the database to log number 23754.
Best regards Regina Hi Regina Thanks for information. Is the location of the file in the error message where you actually find the file (in the "ls")? 2. 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 I am now convinced I need to create a new instance where I can move my non critical dbspace and therfor reduce the critical backup to 2 hours.
When version 11.10 was released, there were many changes to how archives worked internally. In this version, the root reserved pages are read to build a list of dbspaces, chunks, and log files needing to be restored. In bar_act.log we obtain such message : ERROR: No response was received from the database server.