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 > Backup & restore problems with 'ontape -r'

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-15-03, 06:11
Pasquina Pasquina is offline
Registered User
 
Join Date: Jan 2003
Posts: 4
Red face Backup & restore problems with 'ontape -r'

I make the backup with 'ontape -s' command, but I can't restore it with the 'ontape -r' command.
The output error is 'Physical restore failed - Cannot warm restore ROOT DBspace'

/home/informix> ontape -r

Please mount tape 1 on /home/informix/config/almpru.tap and press Return to cont
inue ...

Archive Tape Information

Tape type: Archive Backup Tape
Online version: Informix Dynamic Server Version 7.31.UC5
Archive date: Wed Jan 15 03:00:12 2003
User id: root
Terminal id: ?
Archive level: 0
Tape device: /home/informix/config/almpru.tap
Tape blocksize (in k): 16
Tape size (in k): 2000000
Tape number in series: 1
Continue restore? (y/n)y

Spaces to restore:1 [rootdbs ]
Physical restore failed - Cannot warm restore ROOT DBspace


Program over.
Reply With Quote
  #2 (permalink)  
Old 01-15-03, 07:14
wicky wicky is offline
Registered User
 
Join Date: Dec 2002
Location: Pakistan
Posts: 31
For full restore of system , it is required that particular server should be offline.
Reply With Quote
  #3 (permalink)  
Old 01-15-03, 07:39
Pasquina Pasquina is offline
Registered User
 
Join Date: Jan 2003
Posts: 4
Quote:
Originally posted by wicky
For full restore of system , it is required that particular server should be offline.
If I take-offline the informix, when I write 'ontape -r' It seems doesn't work.
There is no message.
Reply With Quote
  #4 (permalink)  
Old 01-15-03, 07:47
Pasquina Pasquina is offline
Registered User
 
Join Date: Jan 2003
Posts: 4
Quote:
Originally posted by Pasquina
If I take-offline the informix, when I write 'ontape -r' It seems doesn't work.
There is no message.
YES, That's right, It seems run.

Thanks a lot.
Reply With Quote
  #5 (permalink)  
Old 01-15-03, 10:58
Pasquina Pasquina is offline
Registered User
 
Join Date: Jan 2003
Posts: 4
Quote:
Originally posted by Pasquina
YES, That's right, It seems run.

Thanks a lot.
I have a new related problem:
When I write ontape -r it apears 'Physical restore failed - restore reserved pages failed'
I don't know what's wrong.
...
/home/informix> ontape -r

Please mount tape 1 on /home/informix/config/almpru.tap and press Return to cont
inue ...

Archive Tape Information

Tape type: Archive Backup Tape
Online version: Informix Dynamic Server Version 7.31.UC5
Archive date: Wed Jan 15 15:14:12 2003
User id: informix
Terminal id: /dev/pts/tb
Archive level: 0
Tape device: /home/informix/config/almpru.tap
Tape blocksize (in k): 16
Tape size (in k): 2000000
Tape number in series: 1

Spaces to restore:1 [rootdbs ]

Archive Information

Informix Dynamic Server Copyright(C) 1986-1998 Informix Software, Inc.
Initialization Time 01/15/2003 14:14:04
System Page Size 2048
Version 6
Archive CheckPoint Time 01/15/2003 15:14:13

Dbspaces
number flags fchunk nchunks flags owner name
1 1 1 1 N informix rootdbs


Chunks
chk/dbs offset size free bpages flags pathname
1 1 0 262144 191090 PO- /home/informix/config/rootdbs

Continue restore? (y/n)y
Do you want to back up the logs? (y/n)n
Physical restore failed - restore reserved pages failed


Program over.
Reply With Quote
  #6 (permalink)  
Old 01-16-03, 01:47
wicky wicky is offline
Registered User
 
Join Date: Dec 2002
Location: Pakistan
Posts: 31
Cool

check the TAPE Parameter (should be same in source/dest onconfig files )
check the path of dbspace files (should be same in source/dest location and must exit with approprite rights)
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