rman异机恢复问题汇总03

SQL> select file_name,tablespace_name from DBA_TEMP_FILES;
select file_name,tablespace_name from DBA_TEMP_FILES
                                      *
ERROR at line 1:
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/oracle/app/oradata/hnzz/temp01.dbf'

SQL> alter tablespace temp_demo drop datafile '/oracle/app/oradata/hnzz/temp01.dbf';
alter tablespace temp_demo drop datafile '/oracle/app/oradata/hnzz/temp01.dbf'
*
ERROR at line 1:
ORA-03219: Tablespace 'TEMP_DEMO' is dictionary-managed, offline or temporary


SQL> alter tablespace temp_demo drop tempfile '/oracle/app/oradata/hnzz/temp01.dbf';
alter tablespace temp_demo drop tempfile '/oracle/app/oradata/hnzz/temp01.dbf'
*
ERROR at line 1:
ORA-03284: datafile or tempfile /oracle/app/oradata/hnzz/temp01.dbf is not a
member of tablespace TEMP_DEMO
解决
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.

Total System Global Area  849530880 bytes
Fixed Size                  1339824 bytes
Variable Size             742395472 bytes
Database Buffers          100663296 bytes
Redo Buffers                5132288 bytes
Database mounted.
SQL> alter database tempfile '/oracle/app/oradata/hnzz/temp01.dbf' offline;

Database altered.

SQL> alter database tempfile '/oracle/app/oradata/hnzz/temp01.dbf' drop;

Database altered.

SQL> alter database open;

Database altered.