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
|
