--0.1 当前的备份是在mynewts表空间只读时做的，现在将表空间改为read/write

sys@TESTDB11>alter tablespace mynewts read write;

Tablespace altered.

--0.2 试验表空间已经可读写

scott@TESTDB11>delete from tab_mynewts where deptno = 40;

1 row deleted.

scott@TESTDB11>update tab_mynewts set dname = 'DNameC' where deptno = 30;

1 row updated.

scott@TESTDB11>commit;

Commit complete.

--0.3 表空间数据文件丢失

[oracle@S1011:/export/home/oracle]$ rm /oradata/mynewts01.dbf

[oracle@S1011:/export/home/oracle]$ ls /oradata/mynewts01.dbf

/oradata/mynewts01.dbf: No such file or directory

--0.4 发现数据文件丢失

sys@TESTDB11>alter system flush buffer_cache;

System altered.

scott@TESTDB11>select * from tab_mynewts;

select * from tab_mynewts

*

ERROR at line 1:

ORA-01116: error in opening database file 9

ORA-01110: data file 9: '/oradata/mynewts01.dbf'

ORA-27041: unable to open file

Solaris-AMD64 Error: 2: No such file or directory

Additional information: 3

--1. rman解决

RMAN> run {

2> sql 'alter database datafile 9 offline';    --1.1 使表空间脱机

3> restore datafile 9;                             --1.2 还原表空间

4> recover datafile 9;                             --1.3 恢复表空间（比场景5，多这一步）

5> sql 'alter database datafile 9 online';     --1.4 开库

6> }

sql statement: alter database datafile 9 offline

Starting restore at 15-AUG-13

using channel ORA_DISK_1

using channel ORA_DISK_2

channel ORA_DISK_1: starting datafile backup set restore

channel ORA_DISK_1: specifying datafile(s) to restore from backup set

channel ORA_DISK_1: restoring datafile 00009 to /oradata/mynewts01.dbf

channel ORA_DISK_1: reading from backup piece /pooldisk02/backup03/4cohbbvc_1_1

channel ORA_DISK_1: piece handle=/pooldisk02/backup03/4cohbbvc_1_1 tag=TAG20130815T072116

channel ORA_DISK_1: restored backup piece 1

channel ORA_DISK_1: restore complete, elapsed time: 00:00:03

Finished restore at 15-AUG-13

Starting recover at 15-AUG-13

using channel ORA_DISK_1

using channel ORA_DISK_2

starting media recovery

media recovery complete, elapsed time: 00:00:01

Finished recover at 15-AUG-13

sql statement: alter database datafile 9 online

--2. 数据验证

scott@TESTDB11>select * from tab_mynewts;

    DEPTNO DNAME          LOC

---------- -------------- -------------

        10 ACCOUNTING     NEW YORK

        20 RESEARCH       DALLAS

        30 DNameC         CHICAGO