Re: Backup mode information in data dictionary
From: Michael Serbanescu <ms_at_cmprime.cis.att.com>
Date: 1996/10/03
Message-ID: <3253C275.4F8A_at_cmprime.cis.att.com>#1/1
Moorthy N. Rekapalli wrote:
>
> Hello There,
>
> Where in the data dictionary that I will find that the tablespace
> is in backup mode. I thought that the STATUS field of the
> DBA_TABLESPACES will show that information. I issued
>
> SQLDBA> ALTER TABLESPACE USER_DATA BEGIN BACKUP;
>
> After this, the status of the user_data tablespace is online. From
> this information, how can I tell that the tablespace is in backup
> mode.
>
> THANKS IN ADVANCE.
>
> Moorthy
Received on Thu Oct 03 1996 - 00:00:00 CEST
Date: 1996/10/03
Message-ID: <3253C275.4F8A_at_cmprime.cis.att.com>#1/1
The data dictionary view that stores the information you want is V$BACKUP (or V_$BACKUP). Check the value of column STATUS. If the value='ACTIVE', it means that the file is in backup mode. However, this table goes by file, not by tablespace; therefore, you have to run a query that joins V$BACKUP and SYS.DBA_DATA_FILES tables.
I hope this helps.
Michael Serbanescu
Sr. ORACLE DBA, TRECOM Business Systems, Edison, NJ
ms_at_cmprime.cis.att.com
(908)576-3894
Moorthy N. Rekapalli wrote:
>
> Hello There,
>
> Where in the data dictionary that I will find that the tablespace
> is in backup mode. I thought that the STATUS field of the
> DBA_TABLESPACES will show that information. I issued
>
> SQLDBA> ALTER TABLESPACE USER_DATA BEGIN BACKUP;
>
> After this, the status of the user_data tablespace is online. From
> this information, how can I tell that the tablespace is in backup
> mode.
>
> THANKS IN ADVANCE.
>
> Moorthy
Received on Thu Oct 03 1996 - 00:00:00 CEST