If your database is OLTP. I would recommend to use archive backups all the
time and Cold Backup once in a week. You should consider taking backups of
your important tables via export routine everyday, either with incremental
of full depends on the volume of data.
<weijendavid_at_my-deja.com> wrote in message
news:82fk2p$p5f$1_at_nnrp1.deja.com...
: Hi, all
: I have a question regarding to backing up databases which I wish you
: can help me.
: Right now our database is still small, a few GB, however I'd like to
: have a machanism of backuping up our database in order to cope with the
: future expansion.
:
: What is the best rotation of backing up database?
: How many times a day everyday Monday to Sunday?
: What kind of back up method should I use, logical or physical?
: And what to backup and how often (database files, tablespace, etc)?
:
: We are running Oracle on NT, this is what I do to backup our database
:  Using "exp80"
:  Schedule backing up by using "Winat" in NT
:  Copy the backed up "dmp" file onto CD.
: How would I be able to produce an error log file on NT?
:
:
: Since our company is doing E-Commerce, the information obtain from
: customer is updated to our database, hence the availability of database
: must be high (24 hrs), that just makes me wonder what is the most
: secure and uninterrupting way to backup our database.
:
:
: Please help me with this question, thank you very much.
: P.S. Is there any site or book I can have such information?
:
: Regards,
:
: David
:
:
: Sent via Deja.com http://www.deja.com/
: Before you buy.
Received on Tue Dec 07 1999 - 12:09:15 CST
