A partir do Oracle versao 12c e possivel recuperar somente uma tabelaatraves do RMAN. Neste artigo vamos demonstrar os passos da recuperacao.1. Fazendo o backup "full" do banco de dados.[oracle@ora12c tmp]$ rman target /Recovery Manager: Release 12.1.0.1.0 -Production on Fri Jun 20 10:38:44 2014Copyright (c) 1982, 2013, Oracle and/orits affiliates. All rights reserved.connected to target database: ORCL(DBID=1375769800)RMAN> backup database include current controlfile;Starting backup at 20-JUN-14using target database control file insteadof recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: SID=25 devicetype=DISKchannel ORA_DISK_1: starting full datafilebackup setchannel ORA_DISK_1: specifying datafile(s)in backup setinput datafile file number=00001name=+DATA/ORCL/DATAFILE/system.258.847988943input datafile file number=00003name=+DATA/ORCL/DATAFILE/sysaux.256.847988843input datafile file number=00004name=+DATA/ORCL/DATAFILE/undotbs1.260.847989031input datafile file number=00006name=+DATA/ORCL/DATAFILE/users.259.847989029channel ORA_DISK_1: starting piece 1 at20-JUN-14channel ORA_DISK_1: finished piece 1 at20-JUN-14piecehandle=/u01/app/oracle/12c/db/dbs/09pba9pt_1_1 tag=TAG20140620T104101comment=NONEchannel ORA_DISK_1: backup set complete,elapsed time: 00:01:15channel ORA_DISK_1: starting full datafilebackup setchannel ORA_DISK_1: specifying datafile(s)in backup setincluding current control file in backupsetincluding current SPFILE in backup setchannel ORA_DISK_1: starting piece 1 at20-JUN-14channel ORA_DISK_1: finished piece 1 at20-JUN-14piecehandle=/u01/app/oracle/12c/db/dbs/0apba9s8_1_1 tag=TAG20140620T104101comment=NONEchannel ORA_DISK_1: backup set complete,elapsed time: 00:00:01Finished backup at 20-JUN-14RMAN> exitRecovery Manager complete.2. Escolher uma tabela para remocao do banco - "schema"SCOTT.SQL> conn scott/tigerConnected.SQL>select * from emp; EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO-------------------- --------- ---------- --------- ---------- ---------- ---------- 7369 SMITH CLERK 7902 17-DEC-80 800 20 7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30 7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30 7566 JONES MANAGER 7839 02-APR-81 2975 20 7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400 30 7698 BLAKE MANAGER 7839 01-MAY-81 2850 30 7782 CLARK MANAGER 7839 09-JUN-81 2450 10 7788 SCOTT ANALYST 7566 19-APR-87 3000 20 7839 KING PRESIDENT 17-NOV-81 5000 10 7844 TURNER SALESMAN 7698 08-SEP-81 1500 0 30 7876 ADAMS CLERK 7788 23-MAY-87 1100 20 7900 JAMES CLERK 7698 03-DEC-81 950 30 7902 FORD ANALYST 7566 03-DEC-81 3000 20 7934 MILLER CLERK 7782 23-JAN-82 1300 1014 rowsselected.3. Remover a tabela EMP do banco de dados.SQL> drop table emp;Table dropped.4. Uma vez removida a tabela, vamos restaurar a tabela. Vamosprimeiro verificar qual e o SCN do "backupset".[oracle@ora12c tmp]$ rman target /Recovery Manager: Release 12.1.0.1.0 -Production on Fri Jun 20 11:31:19 2014Copyright (c) 1982, 2013, Oracle and/orits affiliates. All rights reserved.connected to target database: ORCL(DBID=1375769800)RMAN> list backupset;using target database control file insteadof recovery catalogList of Backup Sets===================BS Key Type LV Size Device TypeElapsed Time Completion Time------- ---- -- ---------- ----------------------- ---------------9 Full 1.16G DISK 00:01:12 20-JUN-14 BP Key: 9 Status: AVAILABLE Compressed: NO Tag: TAG20140620T104101 Piece Name: /u01/app/oracle/12c/db/dbs/09pba9pt_1_1 List of Datafiles in backup set 9 File LV Type Ckp SCN CkpTime Name ---- -- ---- ---------- --------- ---- 1 Full 1829678 20-JUN-14+DATA/ORCL/DATAFILE/system.258.847988943 3 Full 1829678 20-JUN-14+DATA/ORCL/DATAFILE/sysaux.256.847988843 4 Full 1829678 20-JUN-14 +DATA/ORCL/DATAFILE/undotbs1.260.847989031 6 Full 1829678 20-JUN-14+DATA/ORCL/DATAFILE/users.259.847989029BS Key Type LV Size Device TypeElapsed Time Completion Time------- ---- -- ---------- ----------------------- ---------------10 Full 9.64M DISK 00:00:02 20-JUN-14 BP Key: 10 Status:AVAILABLE Compressed: NO Tag: TAG20140620T104101 Piece Name: /u01/app/oracle/12c/db/dbs/0apba9s8_1_1 SPFILE Included: Modification time: 20-JUN-14 SPFILE db_unique_name: ORCL Control File Included: Ckp SCN: 1829704 Ckp time:20-JUN-146. Para a restauracao da tabela vamos utilizar o SCN indicado noacima (1829704). RMAN> RECOVER TABLE SCOTT.EMP UNTIL scn1829704 AUXILIARY DESTINATION '/tmp/backups';Starting recover at 20-JUN-14using target database control file insteadof recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: SID=277 devicetype=DISKRMAN-05026: WARNING: presuming followingset of tablespaces