RE: Export error in 10.2.0.4 database stating temp tablespace is offline but it's not
- From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- To: <jrkhym@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 5 Nov 2010 10:40:33 -0400
Jason,
Look in dba_temp_files, the status may be offline. I do not totally
understand how a tablespace can be online when all of it's data files
are offline, but it can be done. Go figure.
Dick Goulet
Senior Oracle DBA
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jason Khym
Sent: Friday, November 05, 2010 5:27 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Export error in 10.2.0.4 database stating temp tablespace is
offline but it's not
My apologies for not including the tablespace information. Tablespace is
a true temporary tablespace . It is a Locally Managed Tablespace.
I also forgot to mention that this problem started after our database
server paniced due to a null pointer condition in the driver for our
encrypted volumes(we use a Voremtric solution for encrypting data at
rest). Since we were in a VCS cluster the service grop failover to the
secondary node. Oracle did crash recovery on the secondary node and
opened without errors. Well except this error in the exp started
afterwards.
1* select * from dba_tablespaces where tablespace_name='TEMP'
SQL> /
TABLESPACE_NAME BLOCK_SIZE INITIAL_EXTENT NEXT_EXTENT
MIN_EXTENTS MAX_EXTENTS
------------------------------ ---------- -------------- -----------
----------- -----------
PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING FOR EXTENT_MAN
ALLOCATIO PLU SEGMEN DEF_TAB_
------------ ---------- --------- --------- --------- --- ----------
--------- --- ------ --------
RETENTION BIG
----------- ---
TEMP 32768 1048576 1048576
1
0 1048576 ONLINE TEMPORARY NOLOGGING NO LOCAL
UNIFORM NO MANUAL DISABLED
NOT APPLY NO
Other related posts:
