Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!panix!stanb
From: Stan Brown <stanb@panix.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: TIMEOUT ON CONTROL FILE ENQUEUE
Date: Fri, 9 Sep 2005 16:39:45 +0000 (UTC)
Organization: PANIX Public Access Internet and UNIX, NYC
Lines: 30
Message-ID: <dfsdsh$cng$1@reader1.panix.com>
References: <dfs6ut$dir$1@reader1.panix.com> <1126279871.743116.258320@g49g2000cwa.googlegroups.com>
NNTP-Posting-Host: panix2.panix.com
X-Trace: reader1.panix.com 1126283985 13040 166.84.1.2 (9 Sep 2005 16:39:45 GMT)
X-Complaints-To: abuse@panix.com
NNTP-Posting-Date: Fri, 9 Sep 2005 16:39:45 +0000 (UTC)
User-Agent: nn/6.7.2
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251183

In <1126279871.743116.258320@g49g2000cwa.googlegroups.com> jkstill@gmail.com writes:

>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.

I figured out how to get the DB mounted :-)

Then I rna the query above. It retruned zero rows. So I'm interpeting this
to mean that no tablespaces on this instance were in BACKUP mode when the
instance came down. Is this correct?

And if it is, would it be safe to try and startup the instance? I am in the
process of heading twoard a complete set of cold backups, but this will
take (at least) a couple of days.


-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
						-- Benjamin Franklin