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

From: <>
Date: Thu, 12 Jun 2008 06:56:12 -0700 (PDT)
Message-ID: <>

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

Eugene Pokopac (Oracle DBA - Tucker GA) Received on Thu Jun 12 2008 - 08:56:12 CDT

Original text of this message