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

In <1e468a94-2593-4714-bc29-2d852c8f4c54_at_y21g2000hsf.googlegroups.com> "fitzjarrell_at_cox.net" <oratune_at_msn.com> writes:

>On Jun 9, 9:07=A0am, Stan Brown <st..._at_panix.com> wrote:
>> I have a 7.3.4.5.0 instance, that does hot backups to another machine via
>> NFS. The NFS server had issues this weekend, and I believe that everything=

>> is back to normal now, but i would like to make certain that none of the
>> instances tablespaces/datafiles were inadvertently left in BACKUP mode.
>>
>> How can I verify this?
>>
>> --
>> "They that would give up essential liberty for temporary safety deserve
>> neither liberty nor safety."
>> =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =
>=A0 =A0 =A0 =A0 =A0 =A0 -- Benjamin Franklin

>Query the V$BACKUP view. Should any file# have a status of ACTIVE
>it's still in backup mode and this needs to be corrected. 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.

Thanks, Good news is thta my machine was able to continue, once the NFS server was rebooted. Guess I lucked out on that one. Thanks for the quick answer.

>David Fitzjarrell

-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
						-- Benjamin Franklin