Re: Restore problem

  • From: "Bill Ferguson" <wbfergus@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 4 May 2007 13:03:25 -0600

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
channel ORA_DISK_1: reading from backup piece E:\BACKUP\BACKED UP
ORA-19870: error reading backup piece E:\BACKUP\BACKED UP

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
ORA-27038: created file already exists
OSD-04010: <create> option specified, file already exists
This Oracle 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.


-- Bill Ferguson

Other related posts: