Informix Ontape Error

ontape remote imported dd Input/Output Technote (troubleshooting) Problem(Abstract) Running IBM Informix ontape to restore a tape backup that was made on a different host to which the restore is taking place, fails with 'Physical restore failed - function read archive backup failed code -1 errno 5'. Symptom Example ontape error :- $ ontape -r Please mount tape 1 on /dev/st0 and press Return to continue ... Physical restore failed - function read archive backup failed code -1 errno 5 Program over. Example 'dd' error :- $ dd if=/dev/st0 of=/dev/null bs=2k count=100 dd: opening `/dev/st0': Permission denied $ su - Password: # dd if=/dev/st0 of=/dev/null bs=2k count=100 dd: reading `/dev/st0': Input/output error 0+0 records in 0+0 records out 0 bytes (0 B) copied, 3.17481 seconds, 0.0 kB/s Cause There are a number of reasons you might get this error, including a bad tape. You should also consider checking the block size settings for the source and target tape drivers are compatible. Diagnosing the problem You have checked and confirmed the Informix ONCONFIG values TAPESIZE and TAPEBLK are identical on both the source and target instances. Next, check the block size settings for the tape drivers either match, or the target is set to 0 (variable length blocks). Resolving the problem Check both the source and target system by inserting a tape, and typing the following command :- # mt -f /dev/st0 status The output may look like this :- # mt -f /dev/st0 status SCSI 2 tape drive: File number=0, block number=0, partition=0. Tape block size 512 bytes. Density code 0x0 (default). Soft error count since last status=0 General status bits on (50000):

ontape Technote (troubleshooting) Problem(Abstract) This document will help you navigate through the available information and resources related to ontape backup and restore. Resolving the problem Resolving the problem Onbar Ontape- selected tab, ISM Other SMs onsmsync archecker General Description and Facts about ontape Backup and Restore commands and examples FAQ and Common errors Links to other resources General Description and Facts about ontape Description: Ontape is the oldest backup and restore utility still used with IDS that provides: Backup at the server level Support for incremental backup Manual or continuous logical-log backup Restore at the system or dbspace level Reliability - Data can be restore http://www-01.ibm.com/support/docview.wss?uid=swg21617169 up to point of failure because of logical-log backups. Support for remote tape devices. Support for external backup and restore Simple configuration. Easy to use command syntax. Generally used for small database servers. A single threaded utility and can not be ran in parallel. Requires an "auto rewind" tape device. Does not require a storage manager. Ability to change database-logging status Backup to a tape, directory or a file. Use to http://www.ibm.com/support/docview.wss?uid=swg21403313 setup Data Replication (HDR) Rename chunks to different path names and offsets. Ability to backup and restore using filters. The ontape utility uses eight configuration parameters in the ONCONFIG file Support for External Backup and Restore Back to top Backup and restore commands & examples Usage examples: Using ontape to rename chunks Salvaging Logical-log files using ontape Backing up to STDIO Using Backup / Restore Filters with ontape Back to top FAQ and Common errors Backup: How to view the contents of an ontape tape header. What is the fastest way to setup HDR using ontape backup to STDIO. Restore: Not enough memory during physical restore. Unable to restore ontape incremental archives using STDIO. Error during restore: Could not fork server connection. How do you use ontape to copy an instance to another machine? (Imported Restore). Invalid archive tape error message when performing restore. After a level 0 restore using STDIO engine comes up to Quiescent mode before applying level 1 or 2 archives. Performing Imported restore you receive error : " Physical restore failed - function read archive backup failed code -1 errno 5". Back to top Additional resources / links Trouble shooting ontape failure . MustGather. developerWorks Information Management (site) You can take advantage all of the technical resources that IB

Tape? 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 http://www.dbforums.com/showthread.php?996411-How-to-restore-from-ontape-backup-if-ontape-r-give-error-Bad-Tape above to proceed. To start viewing messages, select the forum that you want http://members.iiug.org/forums/ids/index.cgi/noframes/read/9705 to visit from the selection below. Results 1 to 7 of 7 Thread: How to restore from ontape backup, if ontape -r give error Bad Tape? Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 05-03-04,12:03 #1 Asylzhan informix ontape View Profile View Forum Posts Visit Homepage Registered User Join Date Apr 2004 Posts 5 Unanswered: How to restore from ontape backup, if ontape -r give error Bad Tape? IDS 9.3 FC1 OS HPUX 11i I backup my database with ontape -s -L 0 and delete the database for reconfiguring disk system But when I trying to restore from this backup it give me error Bad Tape And all informix ontape error previous, backups give same error, though befor I restore from there. informix@income$ ontape -r Please mount tape 1 on /home/informix/backup/probe and press Return to continue ... Archive Tape Information Tape type: Archive Backup Tape Online version: Informix Dynamic Server Version 9.30.FC1 Archive date: Sat Apr 24 12:45:50 2004 User id: informix Terminal id: ? Archive level: 0 Tape device: /dev/rmt/0m Tape blocksize (in k): 16 Tape size (in k): 104857600 Tape number in series: 1 Spaces to restore:1 [rootdbs ] 2 [blobinc ] 3 [data ] 4 [log ] 5 [phspace ] 6 [doclst ] Archive Information Informix Dynamic Server Copyright(C) 1986-1999 Informix Software, Inc. Initialization Time 08/14/2002 23:49:16 System Page Size 2048 Version 12 Archive CheckPoint Time 04/24/2004 12:45:56 Dbspaces number flags fchunk nchunks flags owner name 1 1 1 1 N informix rootdbs 2 1 2 10 N informix data 3 1 3 1 N informix log 4 1 13 1 N informix phspace 5 11 14 13 N B informix blobinc 6 1 22 2 N informix doclst Chunks chk/dbs offset size free bpages flags pathname 1 1 0 256000 254026 PO- /dev/informix/ifx-chunk_000 2 2 0 1024000 129 PO- /dev/informix/ifx-chunk_001 3 3 0 1024000 123947 PO- /dev/informix/ifx-chunk_011 4 2 0 1024000 2

Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. Powered by the IBM Informix software... Read 06 Sep 13 - IBM data magazine - Mission Accomplished - Miami, Florida will be the backdrop for the 2014 IIUG Informix Conference... Read 01 Feb 13 - IBM Data Magazine - Are your database backups safe? Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read 14 Nov 12 - IBM - IBM's Big Data For Smart Grid Goes Live In Texas... Read 3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Read 28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm... Read 10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Read 3 Aug 12 - IBM data management - Supercharging the data warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Read 2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service... Read 28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"... Read 23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Read 9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read 22 Mar 12 - developerWorks - Optimizing Informix database access... Read 14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read 1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read 1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read 26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read 24 Feb 12 - develo