did you look to the clause 'skip tablespace' ? it will however requires to restore a system tablespace. bp _____ From: laura pena [mailto:lizzpenaorclgrp@xxxxxxxxx] Sent: Wednesday, 25 October, 2006 3:59 PM To: oracle-l@xxxxxxxxxxxxx Subject: Can RMAN backup certain datafiles and recover just those dataFiles RMAN questions, Hopefully it's not to dumb. 1. Can RMAN do a full backup of just certain datafiles and lay them out on another system? 2. If so, can you then do incrementals on those datafiles? 3. Lastly if one and two are possible - what if you modify the destination database say update a row that lives in the datafile you are doing increments on, will applying the RMAN incremental datafile file fail? Thanks in advance.... -Lizz _____ Get your email and more, right on the new Yahoo.com <http://us.rd.yahoo.com/evt=42973/*http://www.yahoo.com/preview>