<div>
select * from v$backup;<br />
<br />
wmp
</div>


<div>
select file#, status from v$backup;<br />
<br />
if the status is active then the tablespace in backup mode <br />
<br />
select tablespace_name from dba_data_files<br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;where file_id = file_no_from_above_Query;
</div>


select file#, status from v$backup;

if the status is active then the tablespace in backup mode

select tablespace_name from dba_data_files
      where file_id = file_no_from_above_Query;

<div>
Are you manually backing up or are you using RMAN? &nbsp;RMAN uses different views for backup status.
</div>


Are you manually backing up or are you using RMAN?  RMAN uses different views for backup status.

<div>
<div class="content wysiwyg-content">
Hey what is the command or procedure to check if tablespace are in begin backup mode for hotbackup. Please let me know thanks
</div>
</div>


Hey what is the command or procedure to check if tablespace are in begin backup mode for hotbackup. Please let me know thanks

Oracle tablespace status

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.