Hi all, Luckily this is for a non-production tablespace, but I ran into a problem
yesterday with a datafile being corrupted. I performed an RMAN restore, after double-checking the datafile was offline, with: restore datafile 32; It ran for a while, but then bombed out with the following: channel ORA_DISK_1: restored backup piece 14 piece handle=E:\BACKUP\BACKED UP DATA\AJIGLMEM_14_1.BAK tag=TAG20070501T220157 channel ORA_DISK_1: reading from backup piece E:\BACKUP\BACKED UP DATA\AJIGLMEM_15_1.BAK ORA-19870: error reading backup piece E:\BACKUP\BACKED UP DATA\AJIGLMEM_15_1.BAK ORA-19504: failed to create file "E:\ORACLE\DATAFILES\NGDB_DATA_06.DBF" ORA-27086: unable to lock file - already in use OSD-00002: additional error information O/S-Error: (OS 32) The process cannot access the file because it is being used b y another process. failover to previous backup creating datafile fno=32 name=E:\ORACLE\DATAFILES\NGDB_DATA_06.DBF RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03002: failure of restore command at 05/03/2007 14:28:54 ORA-01119: error in creating database file 'E:\ORACLE\DATAFILES\NGDB_DATA_06.DBF' ORA-27038: created file already exists OSD-04010: <create> option specified, file already exists This Oracle 10.2.0.1 on a windows 2003 Server machine. Would (could) I just take the entire tablespace offline, rename the existing datafile, and then re-run the restore? Or stop Oracle instead to rename the file, re-run the restore, then restart Oracle? Or am I missing something else here? This is actually the first time I've ever had to perform a restore in 18 years so I'm a bit gun-shy, though it wouldn't be the end of the world if I had to drop the tablepace and recreate it, I'd only lose abround a weeks worth of work, but no big deal. Thanks. -- -- Bill Ferguson