Re: Restore problem

  • From: "Jared Still" <jkstill@xxxxxxxxx>
  • To: wbfergus@xxxxxxxxx
  • Date: Sun, 6 May 2007 14:11:13 -0700

On 5/4/07, Bill Ferguson <wbfergus@xxxxxxxxx> wrote:

Hi all,

> channel ORA_DISK_1: restored backup piece 14
> tag=TAG20070501T220157
> 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

Hi Bill,

Taking a tablespace offline on windows does not seem to remove the lock that
Oracle has on it.
When a file is open, the process has a lock (don't know the windows
technical term for the
type of lock)

Just tested this on my laptop:  took 10g tablespace EXAMPLE offline, and the
handle utility
(from Sys Internals toolkit) shows that the EXAMPLE files are still open by

oracle.exe pid: 2848 NT AUTHORITY\SYSTEM
   c: File          C:\WINDOWS\SYSTEM32
  d8: Section       \BaseNamedObjects\*oraspawn_buffer_ts50*
  f4: Section       \BaseNamedObjects\ShimSharedMemory
 624: File          C:\oracle\product\10.1.0\oradata\ts50\USERS01.DBF
 628: File          C:\oracle\product\10.1.0\oradata\ts50\EXAMPLE01.DBF
 62c: File          C:\oracle\product\10.1.0\oradata\ts50\EXAMPLE01.DBF
 664: File          C:\oracle\product\10.1.0\oradata\ts50\SYSTEM01.DBF
 668: File          C:\oracle\product\10.1.0\oradata\ts50\SYSTEM01.DBF
 66c: File          C:\oracle\product\10.1.0\oradata\ts50\UNDOTBS01.DBF

I've never restored a tablespace on Windows, but it appears that your
procedure may need to be modified a bit.

Have you tried restoring the tablespace with Oracle in mount mode?

Our resident RMAN expert (Robert Freeman) may know the answer to this.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: