This is a discussion on RE: Backup to disk, then tape within the Informix forums, part of the Database Server Software category; --> I have seen a script somewhere in the past that overcame the 2Gb limit by simulating pressing enter to ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| I have seen a script somewhere in the past that overcame the 2Gb limit by simulating pressing enter to mount a new tape, there was a restore script that went with it. It was written before high capacity tape drives were in general use Where the hell did I see it......... Would that be useful? Regards Colin >From: "Dirk Moolman" <DirkM@mxgroup.co.za> >To: <informix-list@iiug.org> >Subject: RE: Backup to disk, then tape >Date: Fri, 13 May 2005 12:59:16 +0200 > >I haven't done this before, but assume that I can do this by running a >normal online backup (ontape -s -L 0) to (raw) disk, and then using the >dd command to copy the raw disk onto tape, seeing that I won't be able >to use ontape again ..... > >I then want to restore the tape back onto raw disk (dd), and then use >ontape to restore this to another system (same setup - a copy of the >system that was backed up). > > >-----Original Message----- >From: Simmons, Keith [mailto:keith.simmons@office2office.biz] >Sent: 13 May 2005 12:24 PM >To: Dirk Moolman; informix-list@iiug.org >Subject: RE: Backup to disk, then tape > >**** PLEASE DON'T POST HTML **** > >The 2 Gb limit is an IDS limit (in IDS7 and IDS9 below 9.4). >You will only be able to set tape size to 2097152 (2Gb) and >will get prompted for a new tape every time this size is reached. >By setting the TAPEDEV to a soft link you can change the link >to point to a different file for each subsequent 'tape'. >I assume the disk system you are archiving to is on a totally >separate controller to where the database is. >Have you thought about restores? You will need to go through a >similar mechanism of swapping softlinks from file to file in >order to restore. >Where are you backing up your log files? How will you roll them >forward in the event of a restore? >Why do you feel back-up to disk is any 'better' than tape? > >Keith > >-----Original Message----- >From: ORourke, Scott [mailto:ScottORourke@liberata.com] >Sent: Friday, May 13, 2005 11:08 AM >To: 'Dirk Moolman'; informix-list@iiug.org >Subject: RE: Backup to disk, then tape > > >PLEASE READ THE IMPORTANT NOTICE BELOW. DO NOT OPEN ANY ATTACHMENT >WITHOUT PRIOR VIRUS CHECKING. >_________________________________________________ _________________ > > >Make sure you don't hit the filesystem and/or IDS file size limit! >I hit this on 7.31 on SCO Openserver 5.05, where, if I remember >correctly, think it was 2gig. >Can't remember if this was a SCO or IDS limit though. >You can however get round this by setting TAPESIZE appropriately, along >with some clever scripting. >-----Original Message----- >From: Dirk Moolman [mailto >Sent: 13/May/2005 10:38 >To: informix-list@iiug.org >Subject: Backup to disk, then tape > > >I have to do some backup testing this weekend, testing a new way of >backing up our systems. >I want to backup to disk, and then back the disk up to tape - which I >haven't done before. >Any tips / tricks you can share with me ? > > > >IDS 7.31 FD3 >Solaris 9 > > > > > >Dirk Moolman >Database and Unix Administrator >HEALTHCORP > > > >"People demand freedom of speech as a compensation for the freedom of >thought which they seldom use." > > >sending to informix-list > > >_________________________________________________ _________________ >Liberata is the trading name of Liberata UK Limited (Registered in >England and Wales - No 1238274) and other Liberata group companies which >include Liberata Financial Services Limited (Registered in England and >Wales - No 5301492), an entity authorised and regulated by the Financial >Services Authority. The holding company is Liberata plc ( Registered in >England and Wales - No 3987802). > >Registered Offices, 17 London End, Beaconsfield Old Town, >Buckinghamshire, HP9 2HN > >IMPORTANT NOTICE: >This e-mail (including all attachments) is confidential and may be >privileged. It is for the exclusive use of the intended recipient(s) >only, and must not be re-transmitted in an amended form without our >consent. If you have received it in error, please contact us immediately >at ITSecurity@liberata.com. Please then delete it and do not disclose >its contents to any other person. > >Security and reliability of e-mails are not guaranteed. We operate >anti-virus programmes but you must take full responsibility for virus >checking this e-mail (including all attachments). Liberata plc do not >accept any liability in respect of any damage caused by any virus which >is not detected. > >All e-mails to and from anyone @liberata.com may be examined for >breaches of employee policies and the law. All e-mails to anyone >@liberata.com are communications to the company and not private and >confidential to any named individual. > >************************************************* *********************** >********** >This message is sent in strict confidence for the addressee only. It >may >contain legally privileged information. The contents are not to be >disclosed >to anyone other than the addressee. Unauthorised recipients are >requested >to preserve this confidentiality and to advise the sender immediately of >any >error in transmission. >This footnote also confirms that this email message has been swept for >the >presence of computer viruses, however we cannot guarantee that this >message >is free from such problems. >************************************************* *********************** >********** > > >sending to informix-list sending to informix-list |