8 Replies Latest reply: May 26, 2012 11:46 AM by onedbguru RSS

    Recover table

    BHenriquez
      Hi,

      I want to know if exist some method to recover a table from backup of rman without a duplicate of database.

      Thanks for you help.
        • 1. Re: Recover table
          mseberg
          Hello;

          You can restore and recover datafile,tablespace in RMAN but not table.

          Restore backup and export table which you want. Then import it where you want.

          Best Regards

          mseberg
          • 2. Re: Recover table
            BHenriquez
            Thanks for you response.

            My question is more related if using rman can use other method for recover a table that is in a tablespace, without restore all database (duplicate).

            Can restore only the tablespace or is need it duplicate database?
            • 3. Re: Recover table
              kuljeet singh -
              Can restore only the tablespace or is need it duplicate database?
              yes,you can restore specific tablepspce by skipping other tablespace by skip tablespace clause on rman clone cmd.


              http://docs.oracle.com/cd/B19306_01/backup.102/b14194/rcmsynta028.htm
              http://dbarajabaskar.blogspot.in/2010/05/rman-duplicate-active-database-cloning.html
              Like
              RUN
              {  
                ALLOCATE AUXILIARY CHANNEL newdb1 DEVICE TYPE sbt; 
                DUPLICATE TARGET DATABASE TO newdb
                  DB_FILE_NAME_CONVERT=('/h1/oracle/dbs/trgt/','/h2/oracle/oradata/newdb/')
                  UNTIL TIME 'SYSDATE-1'  # specifies incomplete recovery
                  *SKIP TABLESPACE cmwlite, drsys, example   # skip desired tablespaces*
                  PFILE = ?/dbs/initNEWDB.ora
                  lOGFILE
                    GROUP 1 ('?/oradata/newdb/redo01_1.f', 
                             '?/oradata/newdb/redo01_2.f') SIZE 200K, 
                    GROUP 2 ('?/oradata/newdb/redo02_1.f', 
                             '?/oradata/newdb/redo02_2.f') SIZE 200K 
                    GROUP 3 ('?/oradata/newdb/redo03_1.f',
                             '?/oradata/newdb/redo03_2.f') SIZE 200K REUSE;
              }
              • 4. Re: Recover table
                Talip Hakan Ozturk
                http://oraclepitstop.wordpress.com/2007/08/13/how-to-recover-a-table-using-rman-backup/


                Talip Hakan Ozturk
                http://taliphakanozturken.wordpress.com/
                • 5. Re: Recover table
                  BHenriquez
                  Thanks I will try with this method.
                  • 6. Re: Recover table
                    Catch-22
                    I want to know if exist some method to recover a table from backup of rman without a duplicate of database.
                    No, you cannot recover a table with RMAN without cloning/duplicating the database and exporting/importing the table.

                    To recover a table, you will normally use flashback drop to undo a table drop from recycle bin in 10g and higher.
                    • 7. Re: Recover table
                      Levi Pereira
                      883137 wrote:
                      Thanks for you response.

                      My question is more related if using rman can use other method for recover a table that is in a tablespace, without restore all database (duplicate).

                      Can restore only the tablespace or is need it duplicate database?
                      I agree with Dude.

                      Here a example how do it without flasback enabled:

                      http://levipereira.wordpress.com/2012/02/03/how-to-fast-recover-data-lost-due-to-user-errors-without-rman/

                      Regards,
                      Levi Pereira
                      • 8. Re: Recover table
                        onedbguru
                        if someone dropped the table you can restore it from the recyclebin. If it is data related, you can use the methods already described to restore that tablespace, but you will need ALL files for that tablespace.