RE: Antique flavor of unix

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Thu, 7 Oct 2004 12:36:58 -0400
Message-ID: <KNEIIDHFLNJDHOOCFCDKAEIGFHAA.mwf@rsiz.com>

Some process still has a handle on the file. If Oracle is open, it is probably oracle. When the handles are all released, the storage will reappear.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mary Bahrami Sent: Thursday, October 07, 2004 12:34 PM To: Oracle-L (E-mail)
Subject: Antique flavor of unix

All, =20

I'm trying to restore a hotbackup (v7.1.3.2) on a partition with little = extra space. I cannot add space or modify much on this server, so I = placed the new version of the oracle hotbackup files on a separate = partition. =20

I need to delete the old .dbf file and copy in the new file. When I do = a 'rm' of the existing file, available space (df -k) does not change, so = the 'cp' of the new file fails. here's a snip:

# copy current database files that we just ftpd

rm /oracle/dbs/dbsA.dbf                   << this is the large file =

causing problems
wait
sync
cp /voice1/tmporacle/* /oracle/dbs
wait
rm /oracle/dbs/arch/arc_*.*
wait
mv /oracle/dbs/arch/archfrom58/* /oracle/dbs/arch wait
# restore database from fresh copy =20

sqldba <<EOF1>>$LGDEST                    << remember this?

connect internal
startup mount;
set autorecovery ON;
recover database;
alter database open;
EOF1 I tried a 'sync', 'mv' instead of 'cp' also fails. Any other ideas? Os = is unixware, -v 1.1.2, -r 4.2.

Thanks,
Mary

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


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

Received on Thu Oct 07 2004 - 11:33:29 CDT