I mis-spoke earlier, not being a dba myself I sometimes get the jargon
mixed. We do hot backups, what Informix terms archive backup, for
Oracle to disk. Along with logging this allows us to recover up to the
last transaction. Recovering from disk in this fashion is faster than
recovering from tape no? Assuming you are recovering from the backup
that resides on disk.
~JK
George Schlossnagle wrote:
>
> On Tuesday, May 14, 2002, at 10:21 AM, Jeff Kennedy wrote:
>
> > Certainly there are Oracle extensions for NBU; we use an Informix and
> > SQL extension currently. However, we are moving away from them in favor
> > of exports to disk. Exports are faster (and so less drain on the
> > server),
>
> > recovery is faster
>
> How is recovery faster? Not only does the re-import require oracle to
> rebuild all it's data structures, but you have to recreate all the
> indexes at well. Plus it does not allow point in time recovery.
> Exports are certainly convenient, and good for doing restores of
> individual tables, but they definitely are not a faster recovery (at
> least for a full restore), and lack many of the benefits of a hot or
> cold physical db backup. In my instances at least, exports take a place
> alongside hot and cold backups, each providing their strengths.
>
> > , and you don't have to buy expensive
> > extensions for every instance or db you have or add.
>
> You don't need to buy any extensions to do hot backups for Oracle.
> Granted, BLI backups are really nice, but they are not the only way to
> do a hot backup. The main benefit the bLI provides is additional speed
> and efficiency, but it's certainly not necessary?
>
> >
> > With Oracle we are currently exporting to disk, write that to tape, then
> > the next export will overwrite the previous one. Logging is also done
> > to disk. Informix is taking longer to migrate.....
>
> Archive redo logs will buy you nothing in conjunction with exports, they
> only work with physical db backups (they need to reference the SCNs in
> the datafiles). Not that they aren't good for crash recovery if you've
> had long running queries that have been running through the lifespan of
> all your active log groups, but to use them for pit recovery, you need a
> physical backup.
>
> >
> > ~JK
> >
> > "HAPMAN, DAVID M [IT/0200]" wrote:
> >>
> >> Good morning,
> >>
> >> Our current environment is DataCenter 3.4.1 and we're using the
> >> Oracle/RMAN
> >> extension. In addition to using the extension, are dba's are doing
> >> exports
> >> to disk to back up their tablespaces.
> >>
> >> We have a request from our dba's asking if we can backup their exports
> >> direct to tape in a similar fashion to the RMAN backups, reducing the
> >> need
> >> for this disk space. Is anyone doing this kind of backup? Is there a
> >> way
> >> to perform this using the RMAN extension or perhaps another method?
> >>
> >> Regards,
> >>
> >> David
> >> _______________________________________________
> >> Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
> >> http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
> >
> > --
> > =====================
> > Jeff Kennedy
> > Unix Administrator
> > AMCC
> > jlkennedy AT amcc DOT com
> > _______________________________________________
> > Veritas-bu maillist - Veritas-bu AT mailman.eng.auburn DOT edu
> > http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
> >
> >
> // George Schlossnagle
> // Principal Consultant
> // OmniTI, Inc http://www.omniti.com
> // (c) 301.343.6422 (e) george AT omniti DOT com
> // 1024D/1100A5A0 1370 F70A 9365 96C9 2F5E 56C2 B2B9 262F 1100 A5A0
--
=====================
Jeff Kennedy
Unix Administrator
AMCC
jlkennedy AT amcc DOT com
|
