Goal: Do a full recovery (to the last transaction committed) from hostA to hostB.
Following files are available:
1. Last night backup including the spfile and control file
2. Archive logs
3. Current Redo logs from hostA
4. Current control file from hostA
Other Notes: No catalog in RMAN, only control file based recovery
What I have achieved:
I am able to restore the database on hostB using the last night backup and the backed up spfile and ctl file. But then I am losing all the data committed after the last night backup. So the goal here is to apply all the new archivelogs and redo logs after last night backup.
Would it require to restore the database on hostB using latest control file from hostA?
How to roll forward to the last committed SCN using redo/archive logs?
Oh last point! I am an entry level DBA, with basic Oracle knowledge