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
[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 
----------------------------------------------------------------------
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/

Reply via email to