Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Ontape restore to another Instance on same Server

Status
Not open for further replies.

stjacqd

Programmer
Jan 26, 2004
8
CA
Hello Gurus

I am using Informix 9.3 on a Linux server.

I would like to restore my ontape backup of my instance A01 to my instance B01 on the same server.

I do not want to use DBexport and DBImport.
I need to restore from the ontape to validate the backup.
(Internal backup failure procedure)

Using the ontape command, and because I am new in Informix world, what will be the step by step to restore the instance A01 to B01 on the same machine?

Backup:
set ENVIRONMENT VARIABLE to point on instance A01.
onconfig: TAPEDEV /backup/a01/data/data
TAPEBLK 256
TAPESIZE 50000000
ontape -s -L 0

Restore:
NOW IF I WANT TO RESTORE IN INSTANCE B01
set ENVIRONMENT VARIABLE to point on instance B01.
onconfig: TAPEDEV /backup/a01/data/data
TAPEBLK 256
TAPESIZE 50000000

ontape ??????????????????
(What will be the ontape command to restore to the B01 raw device and not to the A01 raw device?)

And how can I be sure that the restore is done on the B01 and not into the A01?
Is the Environment variable is good enough to see the difference? Or is ontape will restore into the raw device of A01 without warning?

stjacqd
 
The Informix instances must look identical ie They must have the same configuration.

The setting of INFORMIXSERVER is enough to point the ontape to the second instance.

ontape -r -D dbspace - if restoring individual dbspaces
ontape -r - if restoring entire instance

If you are doing this to check the integrity of the archive, you can check this without restoring. The archecker utility can achieve this for you.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top