-
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
1 row selected.
SQL> select * from DBA_TEMP_FILES;
no rows selected
SQL>
-
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' ...
d.
-
Here is the answer:
ALTER TABLESPACE BIG_TEMP ADD TEMPFILE 'xxxxxxxxxxxxxx/big_temp01.dbf' SIZE 1073741824;
-
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.
