Re: How to determine if tablespace/datafile is in BACKUP mode
Date: Thu, 12 Jun 2008 06:56:12 -0700 (PDT)
" As I understand it, Oracle 7, if started with files in backup mode
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