Re: Backing up SLES 11 SP1 and Oracle
Thanks David, More research... Dave Dave Stuart Prin. Info. Systems Support Analyst County of Ventura, CA 805-662-6731 david.stu...@ventura.org>>> "David Boyes" 4/7/2011 6:49 AM >>> > My available tape drives are IBM 3480 (yes, you read that correctly!). With drives that small, you're better off backing up to disk (if you have it) and using an alternate method to back up over the network. At 180M per tape, you'll be doing this forever. > 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). Install a Bacula server on one of your distributed hosts that has access to larger capacity tapes and install the Bacula client on this LPAR. Much easier. If you must do the backups from here, Bacula server and client can deal with 3480s directly on the Linux LPAR. Make sure that the tapes are moved over, then activate them by echo "1" > the appropriate device address node in /proc. Echo "0" to the device node when you take them away. > 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. RMAN to disk works fine (in your case, NFS mounting a chunk of disk on another host would be smartest). You probably could do it directly to tape, but Linux and multivolume tape is not straightforward, and RMAN doesn't cope very well with it. -- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu 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 lists...@vm.marist.edu 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/
Re: Backing up SLES 11 SP1 and Oracle
> My available tape drives are IBM 3480 (yes, you read that correctly!). With drives that small, you're better off backing up to disk (if you have it) and using an alternate method to back up over the network. At 180M per tape, you'll be doing this forever. > 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). Install a Bacula server on one of your distributed hosts that has access to larger capacity tapes and install the Bacula client on this LPAR. Much easier. If you must do the backups from here, Bacula server and client can deal with 3480s directly on the Linux LPAR. Make sure that the tapes are moved over, then activate them by echo "1" > the appropriate device address node in /proc. Echo "0" to the device node when you take them away. > 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. RMAN to disk works fine (in your case, NFS mounting a chunk of disk on another host would be smartest). You probably could do it directly to tape, but Linux and multivolume tape is not straightforward, and RMAN doesn't cope very well with it. -- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu 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/
Re: Backing up SLES 11 SP1 and Oracle
Thanks Tom, A great help! Dave Dave Stuart Prin. Info. Systems Support Analyst County of Ventura, CA 805-662-6731 david.stu...@ventura.org>>> "Tom Duerbusch" 4/6/2011 2:55 PM >>> Can you define a NFS server on the same imageyour 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? Wellat 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 DeviceTarget Vendor ModelType 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 autoUNUSED --- LOADED SCSI tape devices (found 0): Generic DeviceTarget Vendor ModelType 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...booohiss. 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 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 david.stu...@ventura.org>>> "Tom Duerbusch" 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
Re: Backing up SLES 11 SP1 and Oracle
BTW, the main manual involved with FTP and tape processing (in case you didn't know): TCP/IP for VSE User Guide: Errata located on their website. Tom Duerbusch THD Consulting >>> David Stuart 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. Systems Support Analyst County of Ventura, CA 805-662-6731 david.stu...@ventura.org>>> "Tom Duerbusch" 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 . 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 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 david.stu...@ventura.org -- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu 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 lists...@vm.marist.edu 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,
Re: Backing up SLES 11 SP1 and Oracle
Can you define a NFS server on the same imageyour 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? Wellat 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 DeviceTarget Vendor ModelType 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 autoUNUSED --- LOADED SCSI tape devices (found 0): Generic DeviceTarget Vendor ModelType 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...booohiss. 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 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. Systems Support Analyst County of Ventura, CA 805-662-6731 david.stu...@ventura.org>>> "Tom Duerbusch" 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 . 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
Re: Backing up SLES 11 SP1 and Oracle
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. Systems Support Analyst County of Ventura, CA 805-662-6731 david.stu...@ventura.org>>> "Tom Duerbusch" 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 . 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 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 david.stu...@ventura.org -- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu 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 lists...@vm.marist.edu 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 lists...@vm.marist.edu with the message: INFO LINUX-390 or visit http://www.marist.edu/htbin/wlvindex?LINUX-390 -- For more information
Re: Backing up SLES 11 SP1 and Oracle
IBM provides solution-specific backup software; there is a TDP (Tivoli Data Protection) for Oracle, which integrates Oracle Backups with TSM. Guess that's safer than running manual backups. ( . . . ) For full VM backups, I guess the Flashcopy mentioned by Tom is a really great option, indeed. HTH. - Pedro Principeza SW Support Specialist @ IBM Brazil From: Tom Duerbusch To: LINUX-390@vm.marist.edu Date: 06/04/2011 17:39 Subject: Re: Backing up SLES 11 SP1 and Oracle Sent by:Linux on 390 Port 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 . 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 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 david.stu...@ventura.org -- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu 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 lists...@vm.marist.edu 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/ -- F
Re: Backing up SLES 11 SP1 and Oracle
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 . 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 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 david.stu...@ventura.org -- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu 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 lists...@vm.marist.edu 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/
Re: Backing up SLES 11 SP1 and Oracle
Hello Dave, There are several ways to backup the oracle database. I would check with your DBA to see how they will be doing the backups. We currently backup our database to disk then let the backup software backup the disks. Jim Dodds Systems Programmer/DBA Kentucky State University 400 East Main Street Frankfort, Ky 40601 502 597 6114 -Original Message- From: Linux on 390 Port [mailto:LINUX-390@VM.MARIST.EDU] On Behalf Of David Stuart Sent: Wednesday, April 06, 2011 2:13 PM To: LINUX-390@VM.MARIST.EDU Subject: Backing up SLES 11 SP1 and Oracle 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 david.stu...@ventura.org -- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu 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 lists...@vm.marist.edu 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/
Backing up SLES 11 SP1 and Oracle
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 david.stu...@ventura.org -- For LINUX-390 subscribe / signoff / archive access instructions, send email to lists...@vm.marist.edu 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/