將Oracle 10g RAC庫用rman 的方式備份並恢復到異機單機-3

NAME
---------------------------------------------------------------------------------------------------------------------------------------------
/oradata/racdb/RACDB/datafile/o1_mf_temp_4jtl9yfl_.tmp

SQL>
SQL>
SQL> select tablespace_name from dba_tablespaces where contents='TEMPORARY';

TABLESPACE_NAME
------------------------------
TEMP

SQL>  create temporary tablespace TEMP1
  2    tempfile '/oradata/racdb/temp01.dbf'
  3    size 50M autoextend off;

Tablespace created.

SQL> alter database default temporary tablespace TEMP1;

Database altered.

SQL>  drop tablespace TEMP including contents and datafiles;

Tablespace dropped.

SQL>

再配上tnsnames.ora 及  listener.ora，到此就完成的RAC庫到異地單機的恢復，這樣大大的提高了工作效率。