I want to restore and recover my oracle database to the current state.
For example, I have a full backup on Sunday and I have all archive logs from Sunday to Wednesday.
If I restore and recover from backup to the new host, my database is in the state of Sunday only.
How can I apply all archive logs I have to recover my database to the state of Wednesday?
Do I need controlfile autobackup on Sunday or the current one on Wednesday?
Please give me steps to do this.