Thanks Tom, A great help!
Dave Dave Stuart Prin. Info. Systems Support Analyst County of Ventura, CA 805-662-6731 [email protected]>>> "Tom Duerbusch" <[email protected]> 4/6/2011 2:55 PM >>> Can you define a NFS server on the same image....your can... You can define a lot of things on the same image...but... Linux memory management isn't as strong as VM, VSE or MVS...so one application can cause real problems for others. But it is doable. No, I didn't define a NFS server on the same image. You can define a second LVM on the same image. In this case, the first LVM is for Oracle (if you don't need top performance, LVM for Oracle tablespaces reduces management quite a bit) and the second LVM for Oracle backups. In my case, I defined the LVM on a NFS server, and then mounted space on the NFS on the Oracle image. How did I use z/VSE to backup it up? Well....at first, I cheated. I ran a small tape job on VSE to create the dataset (open, write, close) for Dynam file VT.TAR.3420.ARCH I then varied off the drive and varied it on the Linux LPAR. Here are my notes on what I did then: SUSE 11 Tar Tape Processing *** must install mt_st RPM to use hardware compression on the IBM 3590 drives. *** provides mtst support vary on 5b1 (vary it off on the 390 side first) attach 5b1 linux72 Logon as: root lstape FICON/ESCON tapes (found 1): TapeNo BusID CuType/Model DevType/Model BlkSize State Op MedState N/A 0.0.05b1 3590/50 3590/11 N/A OFFLINE --- N/A SCSI tape devices (found 0): Generic Device Target Vendor Model Type State chccwdev -e 0.0.05b1 Setting device 0.0.05b1 online Done lstape FICON/ESCON tapes (found 1): TapeNo BusID CuType/Model DevType/Model BlkSize State Op MedState 0 0.0.05b1 3590/50 3590/11 auto UNUSED --- LOADED SCSI tape devices (found 0): Generic Device Target Vendor Model Type State dir /sys/class/tape390 total 0 lrwxrwxrwx 1 root root 0 Jan 19 16:18 ntibm0 -> ../../devices/css0/0.0.0014/0.0.05b1/tape390/ntibm0 lrwxrwxrwx 1 root root 0 Jan 19 16:18 rtibm0 -> ../../devices/css0/0.0.0014/0.0.05b1/tape390/rtibm0 mtst -f /dev/ntibm0 rewind mtst -f /dev/ntibm0 fsf 1 mtst -f /dev/ntibm0 compression 1 tar -b 64 -v -pcf /dev/ntibm0 *.3420 (produce tar file on tape) -b 64 (block at 64 512 byte blocks i.e. 32k) -v show files as they are being processed -p -c -f file to send tar to (/dev/ntibm0) mtst -f /dev/ntibm0 eof 2 mtst -f /dev/ntibm0 rewind mtst -f /dev/ntibm0 fsf 1 tar -b 64 -tvf /dev/ntibm0 (list tar contents from tape tar -b 64 -xf /dev/ntibm0 204344.3420 (retrieve single file to current directory) All 3420 tapes takes about 14GB With hardware compression, that is about 25% of the tape used. (don*t need to gzip*hardware compression) Yea, Yea, Yea...I know.....I'm using root. Bad...booo....hissssss. As far as doing it without cheating..... I got half way thru. You know that with the CSI stack, you can ftp to/from a tape. Good to have it mounted first else the FTP will timeout. I have sent a tar file, as binary to the tape drive. Then I had to work on production stuff and haven't got back to it. What still needs to be done: I need to ftp get the tar from the tape to another filename. Do a tar to list the contents of the tarfile (validate nothing got changed during transmission). Perhaps extact the files, to another directory and compare the results to the original directory. Tom Duerbusch THD Consulting >>> David Stuart <[email protected]> 4/6/2011 3:49 PM >>> Thanks Tom, So, you defined the NFS Server on the same Linux image as the DB? And I was wondering how you used your z/VSE System to back it up... Thanks for the ideas. Dave Dave Stuart Prin. Info. System s Support Analyst County of Ventura, CA 805-662-6731 [email protected]>>> "Tom Duerbusch" <[email protected]> 4/6/2011 1:37 PM >>> Weekly, we take a backup for disaster recovery. Take the image down. Flashcopy the disks (or backup from z/OS or z/VSE, as you don't have z/VM) Bring image up. For the logical backups. I defined an NFS server which the Linux image mounts. Nightly, I take an Oracle Backup Using OEM: Maintenance tab Backup/Recovery Schedule Backup (I make it reoccurring at 3 AM). I tell it to use a directory on the mounted NFS space. Then, during the day, when we have an Operator present. Then move a 3590 drive over to the IFL. >From another Linux image (but could be your Oracle image also) They sign on using PUTTY, and do a "tar" to the tape drive. The problem you are going to have with 3480 drives, is "tar" isn't too friendly with multiple volsers. If you ever hit end of volume with "tar", it will cancel. However, you can tell "tar" that a volume is xxx MB in size. At the end of that size, it will unload the volume and call for another one. I went thru the 3480 process once, back in 2003 and started using the 3590 drives after that <G>. You're not the only one with 3480 drives, we have them, along with 3420 drives also. I have been successful in taking files on the NFS server and FTPing to a tape drive on VSE. This used the CSI stack and allowed us to use DYNAM tapes. If you can afford to take your Oracle image down, perhaps frequently, or you can afford lots of disk space, you can replace the NFS server with a LVM setup on your Oracle image, just for backups. Having separate images is nice as it allows you to take the non-Oracle images down and make changes. But if you only have a single LPAR for Linux and no VM, you can do everything in one server. I tried attaching the manuals but the listserv rejected their size. So the manuals are: b10735 Oracle Backup and Recovery Basics b10734 Oracle Backup and Recoverey Advanced users Guide Tom Duerbusch THD Consulting >>> David Stuart <[email protected]> 4/6/2011 1:12 PM >>> Morning all, New linux admin here. I have an LPAR (yes, an LPAR, no z/VM) running SLES 11 SP1 and Oracle 10g r2. I have yet to back that up. I know, shame on me! Preferably to tape. I have been looking and have found posts referencing mt_st and lintape. So, I am looking for advice on the best way to accomplish the backup. My available tape drives are IBM 3480 (yes, you read that correctly!). They are not directly attached to the Linux LPAR, but have to be 'switched' via the HMC. Which isn't a big deal, I am very familiar with doing this. I am looking for advice on which software package(s) I need on SLES 11 SP 1 to be able to detect, and back up to, my 3480's. Total data, right now, would be 10 - 12 GB (the oracle DB has not yet been populated). Also, anything special I need to do to have the SLES 11 detect that the tape drives are now there? And to 'detach' them when the backup is complete? Anyone know if Oracle can 'back up' to these drives? Or do I need to have Oracle back up to disk first, and then back that data up to the 3480? I'm having trouble finding this info int he Oracle manuals. And if Oracle backs up to disk, such as an lvm, can I back that up directly, or is there something else I need to do, first. Inquiring minds want to know, now that I have time to 'play' with this system some more. TIA, Dave Dave Stuart Prin. Info. Systems Support Analyst County of Ventura, CA 805-662-6731 [email protected] ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 ---------------------------------------------------------------------- Fo r more information on Linux on System z, visit http://wiki.linuxvm.org/ ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 ---------------------------------------------------------------------- For more information on Linux on System z, visit http://wiki.linuxvm.org/ ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 ---------------------------------------------------------------------- For more information on Linux on System z, visit http://wiki.linuxvm.org/ ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 ---------------------------------------------------------------------- For more information on Linux on System z, visit http://wiki.linuxvm.org/ ---------------------------------------------------------------------- For LINUX-390 subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 ---------------------------------------------------------------------- For more information on Linux on System z, visit http://wiki.linuxvm.org/
