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

Home -> Community -> Mailing Lists -> Oracle-L -> ora_snp locks offline datafile

ora_snp locks offline datafile

From: Alessandro Vercelli <alever_at_libero.it>
Date: Fri, 31 Mar 2006 16:30:38 +0200
Message-Id: <IWZXN2$2E915884A7A8BAA399F78E1AB342EF5C@libero.it>


Hi all,
some days ago I created a big rollback_segment to refresh some huge snapshots; the rbs was created in a own separated filesystem which is laying on a own separated disk; operating system is AIX 4.3; the snaspshot was refreshed by a script which onlined the big rbs, refreshed the snapshot and offlined the big rbs. Today, since the snapshot finished successfully, I checked the big rbs which was (obviously) offline, dropped the big rbs and after issued a "drop tablespace RBS_TMP including contents". No error was showed.

After that I tryed to unmount the separated filesystem, but it's locked by three instances of ora_snp.

Does anybody have any suggestion for this issue?

Thanks,

Alessandro Vercelli

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 31 2006 - 08:30:38 CST

Original text of this message

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