Popped over from c.d.informix
Date: Tue, 28 Sep 93 05:31:41 GMT
Message-ID: <1993Sep28.053141.4458_at_wvus.org>
Greetings,
I'm just popping over from my normal comp.databases.informix habitat to ask a couple of questions about Oracle:
if not, why not? (informix uses raw partitions primarily for
performance - perhaps oracle runs okay working within the unix file hierarchy...)
2) please tell me that oracle 7.1 or 8.0 (whatever) will have a clean
online backup. no "fuzzy" stuff. the possibility of incremental
backups.
no? if one limits themselves to operating system backups (which is
the preferred method, ostensibly), then an incremental is not possible. sure, cpio can do incremental but only by copying WHOLE FILES where files have had changes. that, in the eyes of the data base, is not an incremental backup. and we're not much better off using the export facility, which states, "you should have file offline during the export".
the point about a "clean" backup is a request for a facility that works within the data base to supply a backup that is consistent at a certain point in time. this is not the same as one "becoming clean" after you apply a redo log. the right idea comes from the notion of a readconsistent transaction. if only we could do this to backup the whole instance. that is a clean backup.
Thanks for your comments.
-- Scott F. Ford, Data Base Administrator | sford_at_wvus.org bps (Benefit Panel Services) | elroy.jpl.nasa.gov!wvus!sford 888 South Figueroa Street, Suite 1400 | Voice: (213) 489-2694 Los Angeles, CA. 90017 | FAX: (213) 489-7973 "...The bozone layer: shielding the rest of the solar system from the earth's harmful effects...."Received on Tue Sep 28 1993 - 06:31:41 CET