Hello everybody, I'm quite new with RMAN package and, to be frank, reading the manual (for the 3rd time!) is not helping much. I'd very much appreciate if anyone with experience in RMAN functionality would assist with some simple "recipes". 1) I have an operational database (Oracle 11 R2) configured in a RAC mode with about 15 datafiles. 2) I want to perform daily backups that would create fully copy of the datafiles. 3) Once the backup is completed, these files would be MOVED/COPIED (using OS commands) to a separate folder (e.g. a folder whose name would reflect the DATE of the backup; alternatively, the backup process could generate brand new files each time, but this would drastically increase the time it takes for the backup to complete, I think). 4) While MOVING/COPYING the files to the other folder, the REDO logs would be copied to the folder of the previous day; this way, it would be possible to re-generate the database from scratch to just before backup "N" using the files of backup "N-1" + the REDO logs found while generating BACKUP "N". 5) Whenever I need to restore the database (for whatever reason) I would like to take the data files from BACKUP "X-1", restore them, and then update them with the stored REDO logs found while generating BACKUP "X". The following would (hopefully) explain what I would like to achieve: : : FOLDER OF DAY 6 containing: - Data files found in day "6", - REDO logs found in day "7"; FOLDER OF DAY 7 containing: - Data files found in day "7", - REDO logs found in day "8"; FOLDER OF DAY 8 containing: - Data files found in day "8", - REDO logs found in day "9"; : : So, if I want to restore the database to the state it was just before DAY 8, I would be taking the 'Data files found in day "7"' and the 'REDO logs found in day "8"', all of them located within the FOLDER OF DAY "7". Hoping that the above is clear, here are my questions: 1) Is the above feasible at all? 2) Assuming it is, could anyone provide detailed RMAN scripts handling the BACKUP generation and the RESTORE to DAY "X" (I assume that some OS scripts may also be needed, and can handle them without any issue)? Thanking in advance to the philanthropists among you, Fernando.