Back in '98 (whew!), I was told by my Oracle7 DBA instructor (Hi Joe!) that a cold backup is necessary when your method of recovery is no longer valid, such as switching a DB from NOARCHIVELOG mode to ARCHIVELOG mode. I would also think that a DB would be vulnerable to data loss between the time the OPEN RESETLOGS was issued and a complete backup was run.
So, yes, in most cases, I would agree with the cold backup. My $.02 (after taxes), Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 09, 2002 3:15 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Re[2]: What is the point to use "alter database rename > file" > > > Dick, > > Opening with 'RESET LOGS' should only be needed after an incomplete > recovery. > > At this point you would need to make a *cold* backup. > > I'm sure to catch flames for that last statement, but I don't > care, I'll > stand my ground. > > Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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).
