[askdba] Re: Question in HOT BACKUP
- From: "Pepling, Todd C." <tpepling@xxxxxxx>
- To: "'askdba@xxxxxxxxxxxxx'" <askdba@xxxxxxxxxxxxx>, "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 13 Oct 2004 16:22:58 -0400
Doesn't hurt to backup online redologs, but I wouldn't restore them. They
contain the most recent commited transactions, so if you replace them with
copies made with last backup, you lose current data (and may have issues w/
controlfiles too).
-----Original Message-----
From: askdba-bounce@xxxxxxxxxxxxx [mailto:askdba-bounce@xxxxxxxxxxxxx]On
Behalf Of Chirag DBA
Sent: Saturday, October 02, 2004 4:40 AM
To: oracle-l@xxxxxxxxxxxxx; askdba@xxxxxxxxxxxxx;
oracle-l@xxxxxxxxxxxxx; askdba@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx;
askdba@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx; askdba@xxxxxxxxxxxxx;
oracle-l@xxxxxxxxxxxxx; askdba@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx;
askdba@xxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx; askdba@xxxxxxxxxxxxx;
oracle-l@xxxxxxxxxxxxx; askdba@xxxxxxxxxxxxx
Subject: [askdba] Question in HOT BACKUP
Hi,
I just appeared in an interview.
When I was asked which filese I will copy for hot backup, I said redo too.
Cause I think they can help us always to recover database upto point of
time.
I was pulled a lot, but my only question that if not redo then how
will you recover yr DB upto point of failure, stopped the arguements.
M I true in this case? I have done expoerts in hot backups in
production database.
Can anyone clear my doubts? If u copy couple datafiles in hotback with
begin backup, n yr DB crashes... what will happen? Assume that an
archive log file is generated every 30 minutes and my DB crashed after
15 minutes of Last Archive file generated.
Can I go without REDO Log File ???
- Chirag
**************************************************************************************
The information contained in this email is privileged and confidential
information intended only for the use of the individual or entity named as
recipient. If the reader is not the intended recipient, please be notified
that any dissemination, distribution, or copy of this communication is strictly
prohibited. If you have received this communication in error, please do not
disclose this communication to any other person. Please notify us immediately
by telephone and return the original to us at the address indicated above.
Thank you
This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed. If
you have received this email in error please notify the system manager. This
message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this e-mail.
Other related posts: