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 <duerbus...@stlouiscity.com>
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 <LINUX-390@vm.marist.edu>
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 <david.stu...@ventura.org> 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 on Linux on System z, visit
http://wiki.linuxvm.org/
