Oracle 11g RMAN恢复-场景3：非系统表空间数据文件损坏，数据库OPEN状态，高可用...

--1. 开库状态文件丢失, 查询该表空间中的数据出错 ys@TESTDB11>!rm /oradata/users0*.*   scott@TESTDB11>select * from dept; select * from dept               * ERROR at line 1: ORA-01116: error in opening database file 4 ORA-01110: data file 4: '/oradata/users01.dbf' ORA-27041: unable to open file Solaris-AMD64 Error: 2: No such file or directory Additional information: 3   --2. 查看所有需要恢复的文件的信息（应该使用sql 'select * from v$recover_file;） RMAN> report schema;   Report of database schema for database with db_unique_name TESTDB11   List of Permanent Datafiles =========================== File Size(MB) Tablespace           RB segs Datafile Name ---- -------- -------------------- ------- ------------------------ 1    750      SYSTEM               ***     /oradata/system01.dbf 2    730      SYSAUX               ***     /oradata/sysaux01.dbf 3    290      UNDOTBS1             ***     /oradata/undotbs01.dbf 4    6        USERS                ***     /oradata/users01.dbf 5    345      EXAMPLE              ***     /oradata/example01.dbf 6    20       NEWTS                ***     /oradata/newts01.dbf 7    200      FBTBS                ***     /oradata/fbtbs01.dbf 8    50       USERS                ***     /oradata/users02.dbf   List of Temporary Files ======================= File Size(MB) Tablespace           Maxsize(MB) Tempfile Name ---- -------- -------------------- ----------- -------------------- 1    500      TEMP                 500         /oradata/temp01.dbf   --3. 脱机需要还原的文件 RMAN> sql 'alter database datafile 4, 8 offline';   sql statement: alter database datafile 4, 8 offline --4. 还原 RMAN> restore datafile 4, 8;   Starting restore at 14-AUG-13 using channel ORA_DISK_1   channel ORA_DISK_1: restoring datafile 00004 input datafile copy RECID=12 STAMP=823418912 file name=/pooldisk02/backup03/data_D-TESTDB11_I-2578856066_TS-USERS_FNO-4_2boh8o10 destination for restore of datafile 00004: /oradata/users01.dbf channel ORA_DISK_1: copied datafile copy of datafile 00004 output file name=/oradata/users01.dbf RECID=0 STAMP=0 channel ORA_DISK_1: restoring datafile 00008 input datafile copy RECID=10 STAMP=823418909 file name=/pooldisk02/backup03/data_D-TESTDB11_I-2578856066_TS-USERS_FNO-8_29oh8o0r destination for restore of datafile 00008: /oradata/users02.dbf channel ORA_DISK_1: copied datafile copy of datafile 00008 output file name=/oradata/users02.dbf RECID=0 STAMP=0 Finished restore at 14-AUG-13 --5. 恢复 RMAN> recover datafile 4, 8;   Starting recover at 14-AUG-13 using channel ORA_DISK_1   starting media recovery   archived log for thread 1 with sequence 30 is already on disk as file /archive1/1_30_823328120.dbf archived log for thread 1 with sequence 31 is already on disk as file /archive1/1_31_823328120.dbf archived log for thread 1 with sequence 32 is already on disk as file /archive1/1_32_823328120.dbf archived log file name=/archive1/1_30_823328120.dbf thread=1 sequence=30 media recovery complete, elapsed time: 00:00:01 Finished recover at 14-AUG-13 --6. 联机 RMAN> sql 'alter database datafile 4, 8 online';   sql statement: alter database datafile 4, 8 online --7. 验证数据 scott@TESTDB11>select * from dept;       DEPTNO DNAME          LOC ---------- -------------- -------------         10 ACCOUNTING     NEW YORK         20 RESEARCH       DALLAS         30 SALES          CHICAGO         40 OPERATIONS     BOSTON

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/17013648/viewspace-1154716/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/17013648/viewspace-1154716/