Home » RDBMS Server » Backup & Recovery » Tablespace in backup mode ?
icon9.gif  Tablespace in backup mode ? [message #207433] Tue, 05 December 2006 09:42 Go to next message
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.
Re: Tablespace in backup mode ? [message #207436 is a reply to message #207433] Tue, 05 December 2006 10:00 Go to previous messageGo to next message
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;
Re: Tablespace in backup mode ? [message #207443 is a reply to message #207436] Tue, 05 December 2006 10:26 Go to previous message
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 Dec 08 03:53:16 CST 2016

Total time taken to generate the page: 0.20706 seconds