Re: Restore problem

From: Jared Still <jkstill_at_gmail.com>
Date: Sun, 6 May 2007 14:11:13 -0700
Message-ID: <bf46380705061411t30dcab41t48176ba308070115@mail.gmail.com>

On 5/4/07, Bill Ferguson <wbfergus_at_gmail.com> wrote:
>
> Hi all,
>
> > 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
> >
>

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:

---

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

--
http://www.freelists.org/webpage/oracle-l

Received on Sun May 06 2007 - 16:11:13 CDT