Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed.icl.net!newsfeed.fjserv.net!nx01.iad01.newshosting.com!newshosting.com!216.196.98.140.MISMATCH!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!g49g2000cwa.googlegroups.com!not-for-mail
From: jkstill@gmail.com
Newsgroups: comp.databases.oracle.server
Subject: Re: TIMEOUT ON CONTROL FILE ENQUEUE
Date: 9 Sep 2005 08:31:11 -0700
Organization: http://groups.google.com
Lines: 13
Message-ID: <1126279871.743116.258320@g49g2000cwa.googlegroups.com>
References: <dfs6ut$dir$1@reader1.panix.com>
NNTP-Posting-Host: 208.186.116.6
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1126279876 11414 127.0.0.1 (9 Sep 2005 15:31:16 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 9 Sep 2005 15:31:16 +0000 (UTC)
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.6) Gecko/20050317 Firefox/1.0.2,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: g49g2000cwa.googlegroups.com; posting-host=208.186.116.6;
   posting-account=mGBwVA0AAAB1cByzi862Uvf-W5zcEu4D
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251172

To answer question #3:

You may startup the database in mount mode and run the following SQL
to generate SQL that may be used to take datafiles out of backup mode.

select  'alter database datafile ' || '''' || f.name || '''' || ' end
backup;'
from v$datafile f, v$backup b
where b.status = 'ACTIVE'
and f.file# = b.file#;

This can be done before or after the backup.