restore physical

home‎ > ‎restore‎ > ‎

Physical restore only. Restores storage spaces but does not restore any logical logs.

Use this option

to seperate the physical and logical portions
to restore prior to starting replication

usage

infx restore type=physical inst [ rename tapedev salvage=yes|no force=yes|no online=yes|no ]

physical restore only

required:

inst - instance name

optional:

rename - the name of a file containing chunk mapping

tapedev - name of directory to store backup

salvage - salvage logical logs before restoring

force - force the instance offline first

online - bring the instance online after

examples

Physical restore the current instance.

demo1@bobii:/home/informix>infx restore demo1 type=physical

... snip ...

Restore is using file /infx/inst/demo1/backup/db/bobii_5_L0 ...

Using the backup and restore filter gzip -dc.

Archive Tape Information

Tape type: Archive Backup Tape

Online version: IBM Informix Dynamic Server Version 11.70.FC4IE

Archive date: Mon Mar 19 16:49:47 2012

User id: informix

Terminal id: ?

Archive level: 0

Tape device: /infx/inst/demo1/backup/db/

Tape blocksize (in k): 32

Tape size (in k): system defined for directory

Tape number in series: 1

Backup filter: gzip -c

Spaces to restore:1 [root                                                                    ]

2 [blob01                                                                                    ]

3 [plog                                                                                      ]

4 [log01                                                                                     ]

5 [log02                                                                                     ]

6 [dat01                                                                                     ]

7 [dat02                                                                                     ]

8 [dat03                                                                                     ]

9 [dat04                                                                                     ]

10 [idx01                                                                                    ]

11 [idx02                                                                                    ]

12 [idx03                                                                                    ]

13 [idx04                                                                                    ]

14 [ltmp01                                                                                   ]

15 [sblob01                                                                                  ]

Archive Information

Initialization Time 02/18/2012 14:44:10

System Page Size 2048

Version 26

Index Page Logging ON since 02/18/2012 14:44:10

Archive CheckPoint Time 03/19/2012 16:49:47

... snip ...

Continue restore? (y/n)y

Do you want to back up the logs? (y/n)n

... snip ...

Now bring the instance online, without applying any logical logs. It may take several minutes for this operation to complete.

demo1@bobii:/home/informix>onmode -m

By default, a physical restore does not salvage any logical logs, and the restore process will overwrites data contained in the current logical log. To salvage the current logical log, specify the salvage option on the command line

demo1@bobii:/home/informix>infx restore demo1 type=physical salvage=yes

... snip ...

Do you want to back up the logs? (y/n)y

Using the backup and restore filter gzip -c.

File created: /infx/inst/demo1/backup/logs/bobii_5_Log0000000040

Program over.

... snip....

notes

once complete, use restore logical to roll forward logical logs
backup directory is defined by onconfig TAPEDEV parameter
all levels of backup stored in the backup directory will be restored
restore files from an alternate directory with the tapedev option