you can just use the controlfile restore datafile, recover database. when the database has recovered up to date. recreate the controlfile.. it has the same result as duplicate database. -----邮件原件----- 发件人: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 代表 Peter McLarty 发送时间: 2007年3月16日 8:44 收件人: oracle-l@xxxxxxxxxxxxx 主题: ASM monitoring in Enterprise Manager Hi ASM gurus I am trying to find out why when in EM and I look up the page for the Diskgroup the pie graph Disk Group Usage shows the an amount used for internal that is currently 28%. I have my suspicions that this is from an earlier process of when we refreshed some databases that we now have dead files in ASM. Is there a way to find out the reason ASM wants 28% of my storage for internal? I cant find any reference to this in any documentation ASM is on 10.0.2.3 Cheers -- Peter McLarty Database Administrator Student System Upgrade Project Central Queensland University Email: p.mclarty@xxxxxxxxxx Phone: 07 4923 2797 Fax: 07 4923 2721 Mobile: 04 0209 4238 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l