Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> archiving stopped, but lsof shows an old file handle

archiving stopped, but lsof shows an old file handle

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Thu, 19 Apr 2007 00:24:39 -0400
Message-ID: <t1pd23drbvv7dbicdhumt1geidfurlgccn@4ax.com>


Anyway to make oracle release it?

Was trying to expand a file system online. Can't umount with file handles open

SQL> alter system archive log stop

System altered.

SQL> show parameter log_archive_dest_1

log_archive_dest_1                   string
LOCATION=/b03/oradata/mydb2

[root_at_my-db2~]# lsof|grep b03

oracle 12713 oracle 23uW REG 120,241 102209536 1065158 /b03/oradata/mydb2/1_37575_577470749.log (deleted)

[root_at_my-db2~]# ps -ef|grep 12713

oracle 12713 1 0 Jan10 ? 02:09:11 ora_arc1_bopbi

.......
We run Oracle 9iR2,10gR1/2 on RH4/RH3 and Solaris 10 (Sparc) remove NSPAM to email Received on Wed Apr 18 2007 - 23:24:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US