Oninit cdi / Archive
Talk to an expert →

Using ontape to restore specific dbspaces

Posted in 2006

Topics: Backup & Restore, Storage & Space Management, Server Administration, Platform-Specific Issues

Schleicher, Keith M. — — source: IIUG Forums & Mailing Lists

I have a backup with ontape on disk. Due to some data corruption, we might need to restore specific dbspaces. These chunks are marked as online and not down. Is there going to be an issue to restore the specific dbspaces with them being marked as online? If there is, can I trick the system to making Informix think that these specific dbspaces are down? Informix version 9.30.FC2 OS Sun Solaris 5.8 Thanks in advance. ______________________ Keith Schleicher DBA - ACN Tech Services Phone: 920-405-7955 NETS: 8-270-7955 email: kschleicher@acnielsen.com

↪ replying to Schleicher, Keith M.
ART KAGEL, — — source: IIUG Forums & Mailing Lists

This should not be a problem. Art ----- Original Message ----- From: Keith M. Schleicher <ids@iiug.org> At: 9/14 17:24:04 I have a backup with ontape on disk. Due to some data corruption, we might need to restore specific dbspaces. These chunks are marked as online and not down. Is there going to be an issue to restore the specific dbspaces with them being marked as online? If there is, can I trick the system to making Informix think that these specific dbspaces are down? Informix version 9.30.FC2 OS Sun Solaris 5.8 Thanks in advance. ______________________ Keith Schleicher DBA - ACN Tech Services Phone: 920-405-7955 NETS: 8-270-7955 email: kschleicher@acnielsen.com ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.

↪ replying to Schleicher, Keith M.
MARK JAMISON — — source: IIUG Forums & Mailing Lists

Hi Keith, restoring dbspaces that are marked online is not a problem. ontape -r D (dbspace list) should work fine. The main thing you will need todo though is have logical log that the archive used to move the dbspace out of PI. Below is a sample restore of a single dbspace : (informix) /home/informix > ontape -r -D m1 DBspace 'm1' is online; restoring 'm1' will bring all chunks comprising the DBspace OFFLINE and will terminate all active transactions and queries accessing the DBspace. OK to continue?y Please mount tape 1 on /products/informix/instance_info/wm_current/tapedev and press Return to continue ... Archive Tape Information Tape type: Archive Backup Tape Online version: IBM Informix Dynamic Server Version 10.00.FC5W2 Archive date: Fri Sep 15 08:35:57 2006 User id: informix Terminal id: /dev/pts/ta Archive level: 0 Tape device: /products/informix/instance_info/wm_current/tapedev Tape blocksize (in k): 32 Tape size (in k): 10240 Tape number in series: 1 Continue restore? (y/n)y Spaces to restore:1 [m1 ] Restore a level 1 archive (y/n) n Do you want to restore log tapes? (y/n)y Roll forward should start with log number 9 Please mount tape 1 on /home/informix/ltapedev and press Return to continue ... Do you want to restore another log tape? (y/n)n Recommendation: continue the warm restore until log 10 is replayed. The last log that has been restored is: 9. If you want to stop the restore at this log, choose commit, otherwise, choose suspend. If you have not performed a backup that includes the log 10, perform a backup using the ontape -a command. Continue the suspended log restore using the ontape -l command.Do you want to suspend (y), commit (n) or abort (CTRL/C) logical restore? n Program over.

Glossary