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:[email protected]] On Behalf Of David Stuart Sent: Wednesday, April 06, 2011 2:13 PM To: [email protected] 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 [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 ---------------------------------------------------------------------- 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/
