home‎ > ‎restore‎ > ‎

restore logical

Perform a logical restore. Only valid if the instance is in recovery mode following a physical restore. 

usage

infx restore type=logical inst [ cont=yes|no online=yes|no ]
     restore logical logs
       required:
         inst - instance name
       optional:
         cont - leave logical restore in continuous mode
         online - bring the instance online after

The logical restore is performed in continuous mode. You can run the infx restore type=logical command as many times as required.

To automatically end the logical restore specify cont=yes option on the restore command. Otherwise execute the restore endlogical command to complete the logical restore.

After the logical restore completes, the database will be in quiescent mode, use the online=yes to bring the instance online.

examples

Roll forward current logical logs, keeping the logical restore active.

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

Roll forward should start with log number 38
Using the backup and restore filter gzip -dc.

Roll forward should start with log number 38
Using the backup and restore filter gzip -dc.
Rollforward log file /infx/inst/demo1/backup/logs/bobii_5_Log0000000038 ...
Using the backup and restore filter gzip -dc.

Roll forward should start with log number 38
Using the backup and restore filter gzip -dc.
Rollforward log file /infx/inst/demo1/backup/logs/bobii_5_Log0000000038 ...
Using the backup and restore filter gzip -dc.
Rollforward log file /infx/inst/demo1/backup/logs/bobii_5_Log0000000039 ...
Using the backup and restore filter gzip -dc.

Roll forward should start with log number 38
Using the backup and restore filter gzip -dc.
Rollforward log file /infx/inst/demo1/backup/logs/bobii_5_Log0000000038 ...
Using the backup and restore filter gzip -dc.
Rollforward log file /infx/inst/demo1/backup/logs/bobii_5_Log0000000039 ...
Using the backup and restore filter gzip -dc.
Rollforward log file /infx/inst/demo1/backup/logs/bobii_5_Log0000000040 ...

Program over.

Roll forward current logical logs, end the roll forward and bring the instance online.

demo1@bobii:/home/informix>infx restore type=logical demo1 cont=no online=yes

notes

  • backup directory is defined by onconfig LTAPEDEV parameter
  • all logical log files in the directory will be restored