> And 'flash recovery area'. > > Warning: I'm no oracle clue; I'm repeating talking points and terms > of art my oracle folks used. Good information was theirs, transmission > errors mine... > > Oracle has a bunch of high-tech whiz-bang recovery and analysis tools > which I lump under the label 'Flash Recovery Area'. As I understand > it, it goes like this: "If we've got an extra copy of the database > lying around, we can take that, plus the logs, and do a bunch of useful > introspection on them, without affecting production work flow. Oh, and > we can calculate a restore _really_ fast." > > This is a feature that (so I'm told) Oracle types lust after on a > regular basis, but frequently can't have, because "Gee, that's a lot of > disk to buy just for your fancy analytics toolset". > > But if you put it on the DD, then it dedupes to a ludicrously high > degree with your production backups. Hey presto, new features for your
> oracle infrastructure. > Our biggest, more important SAP/Oracle systems have this. Yea, it's a LOT of storage - about 150% of the production database. We run weekly Rman FULL backups from production into this area, and then daily incrementals, which are posted onto the full on a delayed basis. It is really quite cool. My understanding is that it's a complete database - the dba types could actually bring up the db in the flash area. We use the Oracle/RMAN feature where we post incremental backups into the full (delayed by 1 day) so that the full then reflects the point in time of the incremental. This is lots of random updates to files. I'm not sure how the DD handles random updates to existing files on it. Rick > You can't do this if your production backups are on tape volumes. > > > - Allen S. Rout > > ----------------------------------------- The information contained in this message is intended only for the personal and confidential use of the recipient(s) named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this document in error and that any review, dissemination, distribution, or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately, and delete the original message.
