OraFAQ Forum: Backup & Recovery » Tablespace in backup mode ?

Home » RDBMS Server » Backup & Recovery » Tablespace in backup mode ?

Tue, 05 December 2006 09:42

ericsan
Messages: 2
Registered: September 2006

Junior Member

First than all... sorry about my English.

How shall i now what tablespace is in backup mode?

I'm using Oracle 8i

Thanks.

Tue, 05 December 2006 10:00

ebrian
Messages: 2794
Registered: April 2006

Senior Member

select file#, status from v$backup;

If the status column shows ACTIVE, then the tablespace is in backup mode. You can find the corresponding tablespace with:

select tablespace_name from dba_data_files
	where file_id = <file#_from_above>;

If you want to take the tablespace out of backup mode, you can issue:

alter tablespace <tablespace_name> end backup;

Tue, 05 December 2006 10:26

ericsan
Messages: 2
Registered: September 2006

Junior Member

THANK YOU

IT WORKS!!!

Previous Topic:	Using RMAN, first and foremost, how?
Next Topic:	RMAN can't find redo logs in recovery catalog

Goto Forum:

]

Current Time: Thu May 02 10:19:57 CDT 2024