If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > Logical log restore problem...

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 10-27-03, 06:00
pedrin pedrin is offline
Registered User
 
Join Date: Jul 2003
Posts: 11
Logical log restore problem...

I have 5 logical logs and I start a full point-in-time restore (cold restore) getting the following when I start logical-log restore:

(Physical restore of my two dbspaces is correct...)

Begin restore logical log 2 (Storage Manager copy ID: 0 1067245683).
Completed restore logical log 2.
Begin restore logical log 3 (Storage Manager copy ID: 0 1067245902).
Completed restore logical log 3.
Begin restore logical log 4 (Storage Manager copy ID: 0 1067246218).
Completed restore logical log 4.
Begin restore logical log 5 (Storage Manager copy ID: 0 1067246788).
Completed restore logical log 5.
Begin restore logical log 6 (Storage Manager copy ID: 0 1067247141).
Completed restore logical log 6.

Unable to close the storage space restore: buc_fe.c : Archive API processing failed at line 941 for msgtype.
Unable to close the storage space restore: Archive API error: not yet open.

/opt2/informix/bin/onbar_d complete, returning 130 (0x82)

This error take my server offline and when I try to take it to online mode, I get the error:

oninit: Fatal error on shared memory creation.

This is, my server becomes useless.

I have some questions:

- What´s the matter with the logical-log restore? Maybe this restore need temporary space in the dbspace where logical-logs are saved and I need to add more logical logs or increase the dbspace (in this case, rootdbs)?

- Is there any way to initialize the server (oninit -i) and then restore all the data saved before the fatal error?

Thans!!!
Reply With Quote
  #2 (permalink)  
Old 10-27-03, 10:48
gurey gurey is offline
Registered User
 
Join Date: Aug 2003
Location: Argentina
Posts: 780
Re: Logical log restore problem...

Quote:
Originally posted by pedrin
I have 5 logical logs and I start a full point-in-time restore (cold restore) getting the following when I start logical-log restore:

(Physical restore of my two dbspaces is correct...)

Begin restore logical log 2 (Storage Manager copy ID: 0 1067245683).
Completed restore logical log 2.
Begin restore logical log 3 (Storage Manager copy ID: 0 1067245902).
Completed restore logical log 3.
Begin restore logical log 4 (Storage Manager copy ID: 0 1067246218).
Completed restore logical log 4.
Begin restore logical log 5 (Storage Manager copy ID: 0 1067246788).
Completed restore logical log 5.
Begin restore logical log 6 (Storage Manager copy ID: 0 1067247141).
Completed restore logical log 6.

Unable to close the storage space restore: buc_fe.c : Archive API processing failed at line 941 for msgtype.
Unable to close the storage space restore: Archive API error: not yet open.

/opt2/informix/bin/onbar_d complete, returning 130 (0x82)

This error take my server offline and when I try to take it to online mode, I get the error:

oninit: Fatal error on shared memory creation.

This is, my server becomes useless.

I have some questions:

- What´s the matter with the logical-log restore? Maybe this restore need temporary space in the dbspace where logical-logs are saved and I need to add more logical logs or increase the dbspace (in this case, rootdbs)?

- Is there any way to initialize the server (oninit -i) and then restore all the data saved before the fatal error?

Thans!!!
Hi,
Before taking restore, it checks that online this off-line and
does not exist the archives to $INFORMIXDIR/etc/.infos.$INFORMIXSERVER and in /INFORMIXTMP, are
archives of your no instance.

Gustavo.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On