Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> archiving stopped, but lsof shows an old file handle
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 stringLOCATION=/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