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 > restoring the logs

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-01-04, 01:45
mariadasun mariadasun is offline
Registered User
 
Join Date: Nov 2004
Posts: 26
Arrow restoring the logs

hi,
using IDS9.4 onlinux

first i took back up, of database and logs. i did cold restore on another machine.

i could see the database some rows.

i did some transaction on primary , i took log dump

getting problem while applying logs on secondary



can any one help to solve this ,
when i apply logs what must be the database state.and how to apply logs on secondary

when i gave ontape -l

giving error there is no dbspace to recover
Reply With Quote
  #2 (permalink)  
Old 12-14-04, 03:11
nitin_math nitin_math is offline
Registered User
 
Join Date: Nov 2004
Posts: 143
Hi Maria,

When you do ontape -l, it will look for dbspaces/blobspaces which are not present in your existing list. If it finds same on the logs also, it will give the error.
When you did the cold restore, at that time itself Informix would have asked for the logical logs restore.

Bye
Reply With Quote
  #3 (permalink)  
Old 12-15-04, 04:35
mariadasun mariadasun is offline
Registered User
 
Join Date: Nov 2004
Posts: 26
Arrow mode of database server to restore logs

Quote:
Originally Posted by nitin_math
Hi Maria,

When you do ontape -l, it will look for dbspaces/blobspaces which are not present in your existing list. If it finds same on the logs also, it will give the error.
When you did the cold restore, at that time itself Informix would have asked for the logical logs restore.

Bye

i m using IDS 9.4 . i did whole system back up with onbar.

and restored on other site. dbserver came to faster recovery mode.

after i gave onbar -r -l logical logs applied and mode has been changed to quesicent mode. later if i take logs on primary and i want to apply continuously . but in quesicent mode if i give onbar -r -l it is saying three r no dbspaces to recover so , what shlud be the mode to apply logs continuously
Reply With Quote
  #4 (permalink)  
Old 12-17-04, 04:05
krekler krekler is offline
Registered User
 
Join Date: Dec 2004
Posts: 3
You cannot apply logical logs by hand to a running database. It is only for recovery.
If you want to synchronize a remote database use HA replication. It automatically applies logical logs from the source database to a remote database. Maybe this is what you want.
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