Running in noarchivelog mode is the same as accepting
the possibility of the loss of all data since the last
backup - which sounds like a week of data in your
case.
If you're happy with that (?), then just shutdown the
db each friday and copy evertying (including the redo
logs) off to tape.
If you're not happy with that (if I was a user, I
would not be happy with a week's lost data), then
you'll need to be in archivelog mode. Then you don't
ever have to shutdown the database.
hth
connor
- Meomeo Nguyen <meomeo22_at_yahoo.com> wrote: >
> Hi All,
>
> I need to perform a consistent backup for my whole
> database every Friday by using operating system
> utilities. My database has been currently operating
> in NOARCHIVELOG mode, so the only files need to be
> backed up are datafiles, control files, the
> initialization parameter file and other oracle
> product initialization files (Based on Oracle8.1.6
> Backup and Recovery Guide). Since the files in this
> type of backup are all consistent and do not need
> recovery, so the online logs are not needed. Since
> online redo logs is very crucial for recovery, so my
> question is do I need to back up the online redo log
> files as I choose to perform cold backup type for my
> entire database weekly? Here is step by step what I
> did to back up the whole database:
>
> after the database was closed cleanly and all the
> above mentioned files had been backed up into the
> tape. I had to restart the database and mount but
> not open, then switched between NOARCHIVELOG mode to
> ARCHIVELOG mode in order to archive the online redo
> log files. Finally, I copied all archived redo log
> files into the tape while the database was open and
> operated in ARCHIVELOG mode. when it was all done,
> I then switched the database back to NOARCHIVELOG
> mode. Just wondered whether my procedure to perform
> a whole consistent database backup is correct? Am I
> safe to this point? Your help is greatly appreciated
> it. Your help is greatly appreciated.
>
> Thanks in advance,
>
> Trang
>
>
>
> ---------------------------------
> Do You Yahoo!?
> LAUNCH - Your Yahoo! Music Experience
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Fri May 24 2002 - 04:08:19 CDT
