The normal method is to copy out the days worth of archive log file as part
of your normal backup routine. Then maybe keep 2 days worth on-line so that
they are available for a recovery without getting them back from tape.
Keep a watch on the disk space to ensure that the disk does not get full and
a new archived redo log cannot be created.
John
John Hallas
* +44 (0) 115 945 6643
* +44 (0) 115 945 6774
-----Original Message-----
From: Sinardy Xing [mailto:[EMAIL PROTECTED]]
Sent: 06 April 2001 12:56
To: Multiple recipients of list ORACLE-L
Subject: RE: Recovery from noarchive db corrected
Hi Hallas and All DBAs
Thank you for your advise.
I have a question if I turn on our archive redo log do I
need to copy out
that archive log frequently ?
-----Original Message-----
John
Sent: Friday, 6 April 2001 7:21 PM
To: Multiple recipients of list ORACLE-L
FOR YOUR INFORMATION
ESIS and EPFAL are now part of Logica. The Internet email
addresses of the
staff has changed to the following -
[EMAIL PROTECTED] eg
[EMAIL PROTECTED] Emails using the old format will continue
to be delivered
until 30th June 2001.
With no disrespect to your English, the phrase "weakly copy
of dbf files"
(rather than weekly) seems rather appropriate.
As several other listers have stated, by far the best option
is to enable
archive logging.
Whilst you seem to have the bases covered, have you
considered how long it
will take to re-apply the batch files and whilst there may
not be much
online input you are running the risk of losing all data
that has been
input after your last export and before the next one.
Best advice seems to be try archive logging and identify the
impact then
make a considered judgement.
John
John Hallas
* +44 (0) 115 945 6643
* +44 (0) 115 945 6774
-----Original Message-----
From: Sinardy Xing
[mailto:[EMAIL PROTECTED]]
Sent: 06 April 2001 11:10
To: Multiple recipients of list ORACLE-L
Subject: RE: Recovery from noarchive
db corrected
Currently the application insert data from
batch localy and
a bit from
online insertion. We have clustering for our
database.
noarchive, I do export tables after run
batch (daily),
weakly copy out all
dbf files and ctl and redo log files. and
copy them to tape.
It's that true once the redo log switch,
oracle will write
redo log changes
to dbf ?
Do you have any recomendation for better
backup strategy ?
-----Original Message-----
Pather
Sent: Friday, 6 April 2001 1:30 PM
To: Multiple recipients of list ORACLE-L
Sinardy,
Who will recover the database in case of a
failure?
Turing on archiving would not hinder
performance so much.
Proper planning of your backup strategy and
db setup will
have little
overhead
on performance of your database.
You cannot sacrifice backups for a marginal
increase in
performance
especially if
your db is a high transaction processing
system.
Regards
Suhen
The developer application running huge batch
inserting data
into database,
that is what they told me, if you are me
what you will do?
-----Original Message-----
Testa
Sent: Friday, 6 April 2001 11:55 AM
To: Multiple recipients of list ORACLE-L
assuming you're the dba, since when does the
developer
dictate
recoverability to a DBA about a database.
sounds like a role problem there.
joe
Sinardy Xing wrote:
>
> Our Developer prefer the archive off, I
can't change that
anymore :(
>
> -----Original Message-----
> Sent: Thursday, 5 April 2001 8:54 PM
> To: LazyDBA mailing list
>
> Turn archiving on.
>
> > -----Original Message-----
> > From: Sinardy Xing
[mailto:[EMAIL PROTECTED]]
> > Sent: Thursday, April 05, 2001 4:57 AM
> > To: LazyDBA mailing list
> > Subject: Recovery from noarchive db
corrected
> >
> >
> > Hi,
> >
> > My database is noarchive mode, what
should I do to
prevent
> > from lossing any
> > transactions ?
> > Like for example incresed the REDO
buffer to ... (daily
buffer)?
> > Will this decrese the performance ?
> > any technique to share ?
> >
> > Sinardy
> >
> > --------
> > Think you know someone who can answer
the above
question?
> > Forward it to them!
> > to unsubscribe, send a blank email to
> > [EMAIL PROTECTED]
> > to subscribe send a blank email to
[EMAIL PROTECTED]
> > Visit the list archive:
http://www.LAZYDBA.com/odbareadmail.pl
> > Tell yer mates about
http://www.farAwayJobs.com
> >
> >
>
> --------
> Think you know someone who can answer the
above question?
Forward it to
> them!
> to unsubscribe, send a blank email to
[EMAIL PROTECTED]
> to subscribe send a blank email to
[EMAIL PROTECTED]
> Visit the list archive:
http://www.LAZYDBA.com/odbareadmail.pl
> Tell yer mates about
http://www.farAwayJobs.com
>
> --
> Please see the official ORACLE-L FAQ:
http://www.orafaq.com
> --
> Author: Sinardy Xing
> INET: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).
--
Joe Testa http://www.oracle-dba.com
Performing Remote DBA Services, need some
backup DBA
support?
For Sale: Oracle-dba.com domain, its not
going cheap but
feel free to
ask :)
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Joseph S. Testa
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Suhen Pather
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
This e-mail and any files transmitted with it, are
confidential to Logica
and are intended solely for the use of the individual or
entity to whom they
are addressed.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hallas, John
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sinardy Xing
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hallas, John
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).