RE: resetlog confuse(B

From: Goulet, Richard(B <Richard.Goulet_at_parexel.com>
Date: Mon, 12 Jan 2009 08:13:26 -0500
Message-ID: <23C4836D8E9C5F4280A66C0C247BC16F21EE8494_at_US-BOS-MX011.na.pxl.int>

The only reason that you HAVE to use resetlogs is when you do an incomplete/point in time recovery or rebuild the controfile.  

Dick Goulet
Senior Oracle DBA
PAREXEL International
978.313.3426
 information transmitted in this communication is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please destroy any copies, contact the sender and delete the material from any computer.  

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of bao jiejie Sent: Sunday, January 11, 2009 11:05 PM
To: oracle-l
Subject: resetlog confuse

Dear all ,

I still have some confuse about reset log.

Is that true if your controlfile is restore from a backup, you must do alter database open resetlog after the final recovery?

So the only scenario i do not need resetlog should be "the control file restored from a known health state of other location while db is online" ???

if i try to move my both database files and control files from OS filesystem to ASM using rman,

I have to do the resetlog even the backup is complete , restorable and recoverable ???

Thanks a lot.

-- 



("'-''-/").___..--''"'-._

 '7_ 7  )   '_.  (     ).'-.__.')
 (_Y_.)   ._   )  '._ '. ''-..-'
_.'--'_..-_/  /--'_.' ,'


(il),-''  (li),'  ((!.-'


Best regards$B!$(J
Yours sincerely House
baojiejie_at_gmail.com




--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jan 12 2009 - 07:13:26 CST