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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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, Yours sincerely House baojiejie@xxxxxxxxx