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
