Hi Shaw,
Thank you for all your input. Just a quick question in the orant/oradata
folder I see control files and log files. Where are the data files?
Also if I backup the controlfile, logfile and data files is that
sufficient to do a restore later?
Thanks!
In your situation I might recommend a scheduled nightly cold backup
implemented as a DOS command script. In NT the "AT" DOS command does the
scheduling. In Win2k you use the "Task Scheduler" console which is much
better. A cold backup involves shutting the database down in an orderly
way, copying the data files, control files, and redo logs, and then bringing
the database back up.
If you want, you can generate the copy DOS command through SQL*Plus queries
(while the database is still up of course) of a couple of system
tables/views as in:
SPOOL copy.cmd
SELECT 'COPY '||name||' <copy-to directory name>'
FROM v$controlfile;
SELECT 'COPY '||member||' <copy-to directory name>'
FROM v$logfile;
SPOOL OFF
where <copy-to directory name> is the name of the directory you want to copy
the files into. Generating the script this way automatically deals with
such changes as the addition or deletion of a data file.
You can use SQL*Plus scripts to do the shutdown immediate and startup
actions or you can shutdown and startup the database service using NET STOP
and NET START. You may want to do the latter since I have experienced and
other people have reported that shutdown immediate can hang in NT. If you
do a NET STOP, ensure that registry setting ORACLE_<instance>_SHUTDOWNTYPE
is equal to "i" (for immediate).
Of course your script can also do your export as well and maybe analyze some
of the schemas once a week or so.
All of this assumes that your backup will be a disk-to-disk copy. Tape
backup(s) of the results of the copy would presumably be done manually the
next day. In Win2k it is possible to make a tape copy using the NTBACKUP
command.
Hope this is of use.
-----Original Message-----
From: Bernita Joseph [mailto:[Email Address Removed] Friday, October 18, 2002 2:32 PM
Subject: database backup
Hi all,
My working environment is Oracle 8.1.7 on windows NT. Now I need some
suggestion on backup. Our database is relatively small.
We have approximately 33 schemas except the sys and system. Only two are
used regularly for the input of data. Even that is only performed
between 8am to 5pm. As of now our database is in non archive mode and I
manually backup the schemas using export utility at the end of the day.
I would like to implement the oracle backup. Can someone give me suggestions
on whether I should do a cold or hot backup and whether its necessary.
The other question is if I am going to be in non archive mode what are the
steps involved in setting up the backup?
Thanks a bunch!
--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
MS Sql Server LazyDBA home page