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
> 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
Other related posts:
