IDS restore problem in Win7
Posted in 2013
Topics: Backup & Restore, Storage & Space Management, Logging & Checkpoints, Versions, Editions & End-of-Life
HI,
I take the bacup and want to restore in the same machine.
below are the steps.
C:\\\\Windows\\\\system32>ontape -r
Please mount tape 1 on c:\\\\temp\\\\ids.bak and press Return to continue ...
Archive Tape Information
Tape type: Archive Backup Tape
Online version: IBM Informix Dynamic Server Version 11.50.TC8
Archive date: Thu May 23 10:03:19 2013
User id: luchuan
Terminal id: IBM-FSKQIL4MGUO
Archive level: 0
Tape device: c:\\\\temp\\\\ids.bak
Tape blocksize (in k): 16
Tape size (in k): 1000000
Tape number in series: 1
Spaces to restore:1 [rootdbs
]
2 [ol_ids_1150_1
]
3 [mydbs
]
4 [datadbs
]
5 [dbspace1
]
6 [sbspace
]
Archive Information
IBM Informix Dynamic Server Copyright 2001, 2011 IBM Corporation.
Initialization Time 12/06/2012 09:20:47
System Page Size 4096
Version 18
Index Page Logging OFF
Archive CheckPoint Time 05/23/2013 10:03:18
Dbspaces
number flags fchunk nchunks flags owner na
me
1 60001 1 1 N B informix ro
otdbs
2 40001 2 1 N B informix ol
_ids_1150_1
3 48001 3 1 N SB informix sb
space
4 40001 4 2 N B informix my
dbs
5 42001 6 1 N TB informix tm
pdbs
6 40001 7 1 N B informix da
tadbs
7 60002 8 1 M B informix db
space1
Chunks
chk/dbs offset size free bpages flags pathname
1 1 0 51200 16834 PO-B C:\\\\IFMXDATA\\\\ol_ids_1150_1\\\\root
dbs_dat.000
2 2 0 25600 25547 PO-B C:\\\\IFMXDATA\\\\ol_ids_1150_1\\\\ol_i
ds_1150_1_dat.000
3 3 0 25600 1101 POSB C:\\\\IFMXDATA\\\\ol_ids_1150_1\\\\sbsp
ace_dat.000
4 4 0 2500 926 PO-B c:\\\\temp\\\\idschk1.dat
5 4 0 2500 2494 PO-B c:\\\\temp\\\\idschk2.dat
6 5 0 1250 1118 PO-B c:\\\\temp\\\\tmp.dat
7 6 0 25000 23250 PO-B c:\\\\temp\\\\datachk1.dat
8 7 0 2500 2447 PO-B c:\\\\temp\\\\datachk01
8 7 0 2500 0 MO-B c:\\\\temp\\\\mdatachk01
Continue restore? (y/n)y
Do you want to back up the logs? (y/n)n
It report below errors.
Dynamic Server failed to start in Recovery Mode. Check Event Log for errors.
Program over.
=====================
I found below information in the event log.
- System
- Provider
[ Name] OnLine
- EventID 1
[ Qualifiers] 16386
Level 4
Task 0
Keywords 0x80000000000000
- TimeCreated
[ SystemTime] 2013-05-27T08:45:39.000000000Z
EventRecordID 26592
Channel Application
Computer IBM-FSKQIL4MGUO
Security
- EventData
ol_ids_1150_1 : IBM Informix Dynamic Server Stopped.
Do anybody know what disallow the restore? thanks for your time
Hi,
I am not using Windows IFX, but i sn't there an online.log file ? Separate to
event log in Filesystem ?
This should give you a clue.
Marcus Haarmann
----- Ursprüngliche Mail -----
Von: "CHUAN LU" <luchuan@cn.ibm.com>
An: ids@iiug.org
Gesendet: Mittwoch, 29. Mai 2013 10:39:20
Betreff: IDS restore problem in Win7 [30374]
HI,
I take the bacup and want to restore in the same machine.
below are the steps.
C:\\\\Windows\\\\system32>ontape -r
Please mount tape 1 on c:\\\\temp\\\\ids.bak and press Return to continue ...
Archive Tape Information
Tape type: Archive Backup Tape
Online version: IBM Informix Dynamic Server Version 11.50.TC8
Archive date: Thu May 23 10:03:19 2013
User id: luchuan
Terminal id: IBM-FSKQIL4MGUO
Archive level: 0
Tape device: c:\\\\temp\\\\ids.bak
Tape blocksize (in k): 16
Tape size (in k): 1000000
Tape number in series: 1
Spaces to restore:1 [rootdbs
]
2 [ol_ids_1150_1
]
3 [mydbs
]
4 [datadbs
]
5 [dbspace1
]
6 [sbspace
]
Archive Information
IBM Informix Dynamic Server Copyright 2001, 2011 IBM Corporation.
Initialization Time 12/06/2012 09:20:47
System Page Size 4096
Version 18
Index Page Logging OFF
Archive CheckPoint Time 05/23/2013 10:03:18
Dbspaces
number flags fchunk nchunks flags owner na
me
1 60001 1 1 N B informix ro
otdbs
2 40001 2 1 N B informix ol
_ids_1150_1
3 48001 3 1 N SB informix sb
space
4 40001 4 2 N B informix my
dbs
5 42001 6 1 N TB informix tm
pdbs
6 40001 7 1 N B informix da
tadbs
7 60002 8 1 M B informix db
space1
Chunks
chk/dbs offset size free bpages flags pathname
1 1 0 51200 16834 PO-B C:\\\\IFMXDATA\\\\ol_ids_1150_1\\\\root
dbs_dat.000
2 2 0 25600 25547 PO-B C:\\\\IFMXDATA\\\\ol_ids_1150_1\\\\ol_i
ds_1150_1_dat.000
3 3 0 25600 1101 POSB C:\\\\IFMXDATA\\\\ol_ids_1150_1\\\\sbsp
ace_dat.000
4 4 0 2500 926 PO-B c:\\\\temp\\\\idschk1.dat
5 4 0 2500 2494 PO-B c:\\\\temp\\\\idschk2.dat
6 5 0 1250 1118 PO-B c:\\\\temp\\\\tmp.dat
7 6 0 25000 23250 PO-B c:\\\\temp\\\\datachk1.dat
8 7 0 2500 2447 PO-B c:\\\\temp\\\\datachk01
8 7 0 2500 0 MO-B c:\\\\temp\\\\mdatachk01
Continue restore? (y/n)y
Do you want to back up the logs? (y/n)n
It report below errors.
Dynamic Server failed to start in Recovery Mode. Check Event Log for errors.
Program over.
=====================
I found below information in the event log.
- System
- Provider
[ Name] OnLine
- EventID 1
[ Qualifiers] 16386
Level 4
Task 0
Keywords 0x80000000000000
- TimeCreated
[ SystemTime] 2013-05-27T08:45:39.000000000Z
EventRecordID 26592
Channel Application
Computer IBM-FSKQIL4MGUO
Security
- EventData
ol_ids_1150_1 : IBM Informix Dynamic Server Stopped.
Do anybody know what disallow the restore? thanks for your time
*******************************************************************************
Forum Note: Use "Reply" to post a response in the discussion forum.
The engine hasn't start to write the online.log. =============== 16:24:40 Checkpoint Completed: duration was 0 seconds. 16:24:40 Mon May 27 - loguniq 50, logpos 0x91b018, timestamp: 0x2ab01e Interval: 1135 16:24:40 Maximum server connections 1 16:24:40 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2 16:39:41 Checkpoint Completed: duration was 0 seconds. 16:39:41 Mon May 27 - loguniq 50, logpos 0x91d018, timestamp: 0x2ab02e Interval: 1136 16:39:41 Maximum server connections 1 16:39:41 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 2, Llog used 2 16:45:38 Checkpoint Completed: duration was 0 seconds. 16:45:38 Mon May 27 - loguniq 50, logpos 0x91f018, timestamp: 0x2ab038 Interval: 1137 16:45:38 Maximum server connections 1 16:45:38 Checkpoint Statistics - Avg. Txn Block Time 0.000, # Txns blocked 0, Plog used 0, Llog used 2 16:45:39 IBM Informix Dynamic Server Stopped.