Oracle 12c中臨時表空間丢失的處理和日志檔案丢失的恢複方案

cdb,pdb分别有自己的臨時表空間

SQL> select name,con_id from v$tempfile;
NAME										     CON_ID
-------------------------------------------------------------------------------- ----------
/u01/oracle/oradata/wyzc/temp01.dbf							  1
/u01/oracle/oradata/wyzc/pdbseed/pdbseed_temp012015-07-31_11-55-53-PM.dbf		  2
/u01/oracle/oradata/wyzc/pdbwyzc/pdbwyzc_temp012015-08-01_12-17-15-AM.dbf		  3

SQL> alter session set container=cdb$root;

Session altered.

SQL> alter session set container=pdb$seed;

Session altered.

SQL> alter session set container=pdbwyzc;

Session altered.
切換當相應的cdb，pdb中重建自己的臨時檔案即可。
           

--可以在重建控制檔案中看到臨時檔案是如何增加的。

SQL> alter session set container=cdb$root;

Session altered.

SQL> alter database backup controlfile to trace as '/tmp/c.sql';

Database altered.


-- Commands to add tempfiles to temporary tablespaces.
-- Online tempfiles have complete space information.
-- Other tempfiles may require adjustment.
ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/oracle/oradata/wyzc/temp01.dbf' REUSE;
ALTER SESSION SET CONTAINER = PDB$SEED;
ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/oracle/oradata/wyzc/pdbseed/pdbseed_temp012015-07-31_11-55-53-PM.dbf' REUSE;
ALTER SESSION SET CONTAINER = PDBWYZC;
ALTER TABLESPACE TEMP ADD TEMPFILE '/u01/oracle/oradata/wyzc/pdbwyzc/pdbwyzc_temp012015-08-01_12-17-15-AM.dbf' REUSE;
ALTER SESSION SET CONTAINER = CDB$ROOT;
-- End of tempfile additions.