newbie to ingres 2.6


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers newbie to ingres 2.6
# 1  
Old 06-13-2009
Tools newbie to ingres 2.6

Ok, so I inherited a system with Ingres 2.6 - which they will migrate to SQL Server soon... But until then, we still need to make sure the database is recoverable in case we need to. The issue is that the backup script is failing on rollforwarddb as you can see below. Where the heck do I start to troubleshoot this issue? My background is Oracle & SQL Server, so this is a totally new animal. Thanks in advance.

UPDATE: after looking through some more logs, I ran the following command with the result below:

[535 /ing26/ingres/home] <<ING26>> rp3440-server->infodb dbname
==================Sat Jun 13 17:25:18 2009 Database Information=================

Database : (dbname,mgr3) ID : 0x42AB2C8D Collation : default
Extents : 10 Last Table Id : 970245
Config File Version Id : 0x00060001 Database Version Id : 6
Mode : DDL ALLOWED, ONLINE CHECKPOINT ENABLED
Status : CKP,DUMP,CFG_BACKUP

The Database is Inconsistent.
Cause of Inconsistency: RFP_FAIL
The Database has been Checkpointed.
The Database is not Journaled.

Journals are not valid from any checkpoint.

###==========================================================================================
[528 /ing26/ingres/home] <<ING26>> rp3440-server->rollforwarddb -umgr3 dbname -v '#x'
Sat Jun 13 17:05:21 2009 RFP: Preparing for database rollforward on : dbname
Checking database snapshot for table level recovery
Checking database snapshot for table level recovery
Checking database snapshot for table level recovery
Checking database snapshot for table level recovery
Checking database snapshot for table level recovery
Checking database snapshot for table level recovery
beginning restore of disk /ing26/iijcd/ingres/ckp/default/dbname of 6 locations
Sat Jun 13 17:05:21 2009 RFP: Deleting files at root location : ii_database:
Sat Jun 13 17:05:21 2009 RFP: Start restore of location: ii_database from disk:
path = '/ing26/iijcd/ingres/ckp/default/dbname'
file = 'c1422001.ckp'
executing restore to disk /ing26/iijcd/ingres/ckp/default/dbname of 6 locations
tar: cannot open /ing26/iijcd/ingres/ckp/default/dbname/c1422001.ckp
deleting files in location /ing26/limsdata1/ingres/data/default/dbname
Sat Jun 13 17:05:21 2009 RFP: Start restore of location: dbname_loc1 from disk:
path = '/ing26/iijcd/ingres/ckp/default/dbname'
file = 'c1422002.ckp'
executing restore to disk /ing26/iijcd/ingres/ckp/default/dbname of 6 locations
tar: cannot open /ing26/iijcd/ingres/ckp/default/dbname/c1422002.ckp
deleting files in location /ing26/limsdata2/ingres/data/default/dbname
Sat Jun 13 17:05:21 2009 RFP: Start restore of location: dbname_loc2 from disk:
path = '/ing26/iijcd/ingres/ckp/default/dbname'
file = 'c1422003.ckp'
executing restore to disk /ing26/iijcd/ingres/ckp/default/dbname of 6 locations
tar: cannot open /ing26/iijcd/ingres/ckp/default/dbname/c1422003.ckp
deleting files in location /ing26/limsdata3/ingres/data/default/dbname
Sat Jun 13 17:05:21 2009 RFP: Start restore of location: dbname_loc3 from disk:
path = '/ing26/iijcd/ingres/ckp/default/dbname'
file = 'c1422004.ckp'
executing restore to disk /ing26/iijcd/ingres/ckp/default/dbname of 6 locations
tar: cannot open /ing26/iijcd/ingres/ckp/default/dbname/c1422004.ckp
deleting files in location /ing26/limsdata4/ingres/data/default/dbname
Sat Jun 13 17:05:21 2009 RFP: Start restore of location: dbname_loc4 from disk:
path = '/ing26/iijcd/ingres/ckp/default/dbname'
file = 'c1422005.ckp'
executing restore to disk /ing26/iijcd/ingres/ckp/default/dbname of 6 locations
tar: cannot open /ing26/iijcd/ingres/ckp/default/dbname/c1422005.ckp
deleting files in location /ing26/limsdata5/ingres/data/default/dbname
Sat Jun 13 17:05:21 2009 RFP: Start restore of location: dbname_loc5 from disk:
path = '/ing26/iijcd/ingres/ckp/default/dbname'
file = 'c1422006.ckp'
executing restore to disk /ing26/iijcd/ingres/ckp/default/dbname of 6 locations
tar: cannot open /ing26/iijcd/ingres/ckp/default/dbname/c1422006.ckp
done with disk operations
Sat Jun 13 17:05:22 2009 E_DM130D_RFP_BAD_RESTORE Error occurred trying to restore the checkpoint.
Sat Jun 13 17:05:22 2009 E_DM1301_RFP_ROLL_FORWARD An error occurred that prevents further processing.

Last edited by akimeu; 06-13-2009 at 09:34 PM..
 
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. SCO

Ingres dbms on sco unix

Hi everybody. I'm going to install ingres on sco unix 5.0.7. A client version may be usefull. I want to know how can I get appropriate version and how to install ingres on sco unix. thanks. (1 Reply)
Discussion started by: javad1_maroofi
1 Replies

2. Shell Programming and Scripting

perl newbie . &&..programming newbie

Hi, I am new to programming and also to perl..But i know 'perl' can come to my rescue, But I am stuck at many places and need help..any small help is much appreciated... below is the description of what i intend to acheive with my script. I have a files named in this format... (13 Replies)
Discussion started by: xytiz
13 Replies

3. Shell Programming and Scripting

perl newbie . &&..programming newbie (question 2)

Hello everyone, I am having to do a lot of perl scripting these days and I am learning a lot. I have this problem I want to move files from a folder and all its sub folders to one parent folder, they are all .gz files.. there is folder1\folder2\*.gz and there are about 50 folders... (1 Reply)
Discussion started by: xytiz
1 Replies

4. UNIX for Dummies Questions & Answers

UNIX newbie NEWBIE question!

Hello everyone, Just started UNIX today! In our school we use solaris. I just want to know how do I setup Solaris 10 not the GUI one, the one where you have to type the commands like ECHO, ls, pwd, etc... I have windows xp and I also have vmware. I hope I am not missing anything! :p (4 Replies)
Discussion started by: Hanamachi
4 Replies

5. UNIX for Dummies Questions & Answers

Newbie in need of help

Hey all. I am a MS person that is looking to get into real computing for a change. I have seen a few different references to "UNIX Essentials and Core" DVD in different newbie threads and a quick intraweb search on Google only comes up with links to this forum and an Amazon review. Does anyone... (3 Replies)
Discussion started by: cfjohnsn
3 Replies

6. UNIX for Dummies Questions & Answers

Can u help a newbie?

want to learn unix very much.its my dream to be like you guys.can teach me how to start and what are the basics of unix.some study resources too like webiste or books.anything that can help in learning unix.hope someone will help a newbie. sincerely your, gabby (2 Replies)
Discussion started by: bLinQue
2 Replies

7. Programming

help<newbie>

i am new to the programing enviroment i know html and some of cgi i would like to know how to creat programs i know nothing!!!!!!!!!!!!! what do i need to get started where can i learn the language what language do i need to learn i tried scheme http://www.htdp.com it did not work out well... (9 Replies)
Discussion started by: skistar
9 Replies

8. IP Networking

help<newbie>

hello i would like to get a server so i may post websites on the web do i have to pay a lot of money to use someone else's server or is there a way to turn a computer into a basic server please help i am trying to find the most inexpensive way to get my own domain up on the web if this is... (1 Reply)
Discussion started by: skistar
1 Replies
Login or Register to Ask a Question