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

From: Stan Brown <stanb_at_panix.com>
Date: Thu, 12 Jun 2008 19:18:01 +0000 (UTC)
Message-ID: <g2rsp9$2b6$1@reader2.panix.com>


In <fa73172d-8b51-488b-ba5b-03771659c947_at_f63g2000hsf.googlegroups.com> epokopac_at_excite.com 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