I don't know if we have a requirement for flashcopy. I may not find out until all the hardware is bought (too late) and the data is being moved over.
But, 128 GB database, on the surface, would require a rather large batch window to archive it. I don't know what the batch window is for that application. If I have the window, then I might have to staff Operations for that window. Knowing if Flashcopy works in a z/Linux, Oracle 10g active database world, gives me options.... Buy more dasd to support flashcopy. Buy a dataserver so I don't have to staff the backups. Hire more operators. Until I know what I can use, I can't plan for or get cost estimates. Tom Duerbusch THD Consulting >>> [EMAIL PROTECTED] 02/01/05 12:53 PM >>> Tom, we use Tivoli storage manager with the data protector to do online backups to tape. TSM has the option of going to dasd, if that is your preferred storage medium. Is there a requirement for flashcopy? -----Original Message----- From: Tom Duerbusch [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 01, 2005 12:47 PM To: [email protected] Subject: z/Linux and Oracle Apparently we are going to be moving a large set of resources to the mainframe, and will be moving the data to Oracle 10g (note..64 bit). The last time I ran Oracle on the mainframe was Oracle 6, under VM/ESA 1.0 and also, for a brief time, under VSE/SP 4.1 (sure didn't run well there). Anyway, there are some rather large data requirments. But one of them is 128GB. I don't know what 128 GB means in this case. Raw data. The dasd used by the current database platform. The amount of dasd on that server...just what, I don't know. In either case, I expect at least 100 GB of mainframe dasd to be used for this. On the little info I have, I'm expecting a total of 400 GB to be moved to us. 400 GB ends up being a lot more, when we factor in test systems, number of Linux images necessary (8X5 servers, weekend servers, 24X?? servers) as well as the dasd requirements for flashcopy. And the question of the day becomes, does z/Linux (Suse 8.0 or better) and Oracle 10g, support flashcopy of an active, running database. I know I can quiese things and do a flash, but on an active Oracle system, how does Oracle sync the logs to the flash point? Will z/Linux flush out the write cache buffers in prep for the flash? There is a new feature, Flashcopy, copy only, which apparently only copies data that was to be changed, so most of your backup will be done to the origional copy and "copy only" will retain the "before" image of any data that was changed. This would reduce the dasd requirement greatly (from needing 100% for the flash to a few percent). I've only had to deal with a few GB databases (DB2, Oracle, IMS, etc). Where I figure I will have between 7 and 12 databases, the big one, 128 GB has me concerned. Just how do you back that time of thing up? None of our data is currently, true 24X7. And I don't see any great requirement in that area. Worst case, is everyone could accept a few minutes for a "flash" to be done. Best case, is the users go home and leave us to do the job <G>. So what kind of hardware do you backup large databases to? How often? How frequently do you need to shutdown z/Linux or Oracle and for what reasons? Right now, I'm trying to spec out what hardware we need. But I need to know how this all operates in production to determine what hardware and how much is necessary. Thanks Tom Duerbusch THD Consulting ---------------------------------------------------------------------- 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 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 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
