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>
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 FranklinReceived on Thu Jun 12 2008 - 14:18:01 CDT