Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Confusion why online redo logs should never be backed up.
Having just watched the movie "Mystery Men" with my kids last night, I
thought I'd channel the Sphinx for a moment:
"Backing up in order to recover, is less important than recovering what was backed up."
...and for those who prefer to channel the Spleen, "Pssssssssssst!"... :-)
on 5/26/03 4:26 AM, Richard Foote at richard.foote_at_bigpond.com wrote:
> Hi Hemant, > > I appreciate you're comments but I honestly haven't missed Jared's point and > I remain unconvinced. I just don't accept the argument that such backups are > warranted in case of junior DBA inabilities to perform clean backups or open > with resetlogs. "Junior DBAs" in charge of important production databases > that can't do the above are the issue, not the backup strategy. They're just > as likely to overwrite the current online logs with the backups during a > normal recovery or lock themselves in the toilet or some such ;) > > Then again, it might serve the organisation right for employing such DBAs > based only on OCP credentials !! > > Cheers ;) > > Richard > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> > Sent: Monday, May 26, 2003 2:21 AM > >
> NORMAL
> Service
> system
> database
> database"]
> trainee-DBA
> archive
> Backup.
> luck
> day
> and
> dangerous.
> any
>>>> Richard, >>>> >>>> You must have missed one. :) >>> >>> Hi Jared, >>> >>> I think we're going to have to introduce quotas, no more than two >>> contributions per thread ;) >>> >>>> >>>> There have been 2 occasions where someone has >>>> sent me 200 gb worth of database on tape, and >>>> the database had not been shutdown properly. >>>> >>>> Since the system datafile needed recovery from >>>> the online logs, I was very glad to have them. >>> >>> I guess my point is that making a backup without shutting down the system >>> properly is a sin akin to scratching a rare David Bowie LP, ie. somewhat >>> unforgivable (although I admit the second sin is far worse). Make a >>> consistent backup and/or have the database in archivelog mode, you then >>> don't require the online redo logs .... >>> >>>> >>>> I have encountered this on a very few other >>>> occasions, but can't recall the circumstances >>>> of those events. >>>> >>>> They are also useful when cloning a DB (without RMAN), >>>> though not required. Depends on how the clone >>>> will be used. >>> >>> I guess my point here is the "though not required" bit. It simplifies the >>> process I agree but even in this case, the online logs are not strictly >>> required. >>> >>>> >>>> As with many things, this is not a black and white >>>> issue. There are shades of gray. While it certainly >>>> not necesssary to normally backup the online logs >>>> during a cold backup, it is incorrect to say that >>>> they are never useful. >>>> >>> >>> I guess we're going to have to agree to disagree. However, getting back > to >>> the subject of sins, including online redo logs in a cold backup is not >>> really an issue that would cause me loss of sleep (unlike scratching DB >>> LPs). Like, it doesn't really hurt. But if someone were to accidentally >>> incorrectly restore them in a recovery scenario, ouch, that would be a > sin >>> worth having a chat about ;) >>> >>> Cheers >>> >>> Richard >>> >>> >>> -- >>> Please see the official ORACLE-L FAQ: http://www.orafaq.net >>> -- >>> Author: Richard Foote >>> INET: richard.foote_at_bigpond.com >>> >>> Fat City Network Services -- 858-538-5051 http://www.fatcity.com >>> San Diego, California -- Mailing list and web hosting services >>> --------------------------------------------------------------------- >>> 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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: tim_at_sagelogix.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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 Mon May 26 2003 - 13:31:41 CDT