After using RMAN to duplicate a database, everything is fine except the locally managed temporary tablespace seems to be missing. Look at the following query. Is this a bug?
SQL> select * from dba_tablespaces where tablespace_name='BIG_TEMP';
TABLESPACE_NAME INITIAL_EXTENT NEXT_EXTENT MIN_EXTENTS MAX_EXTENTS PCT_INCREASE MIN_EXTLEN STATUS CONTENTS LOGGING EXTENT_MAN ALLOCATIO PLU
-------------------- -------------- ----------- ----------- ----------- ------------ ---------- --------- --------- --------- ---------- --------- ---
BIG_TEMP 1048576 1048576 1 0 1048576 ONLINE TEMPORARY NOLOGGING LOCAL UNIFORM NO
if it is a temp tablespace, oracle scarcely acknowledges temp files. since it seems to be in the DBA_TABLESPACES, do
ALTER DATABASE CREATE DATAFILE 'blah' ...
the tempfile at temparory tablespace will be backup with rman, because the tempfile did not be recorded at control file.
and don't rename and don't recovery. you can re-created the tempfile.
Bookmarks