Oracle 11g RMAN恢復-只讀表空間的恢復（備份是在表空間只讀狀態下做的)

--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