Re: How to determine if tablespace/datafile is in BACKUP mode

From: Stan Brown <>
Date: Thu, 12 Jun 2008 19:18:01 +0000 (UTC)
Message-ID: <g2rsp9$2b6$>

In <> writes:

>" As I understand it, Oracle 7, if started with files in backup mode
>after a
> crash or a SHUTDOWN ABORT, will assume media recovery is required."

>Prior to 7.2, media recovery would have been necessary. Effective with
>7.2, a simple

>"alter database datafile "full path file name" end backup" ;

>issued after the "media recovery needed messages" will take the file
>out of hot backup mode and allow you to then issue an "open".

Thanks, this is useful information.

>Eugene Pokopac (Oracle DBA - Tucker GA)

I used to live right next to there, in Clarkston.

"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
						-- Benjamin Franklin
Received on Thu Jun 12 2008 - 14:18:01 CDT

Original text of this message