Oracle 11.2.0.3 with daily full backup and hourly archivelog backup. RMAN with a catalog.
If I take a backup at 11pm at night and it finishes 5am the next day and I want to restore a backup to a different system, how can I identify either a time for 'set until' or an SCN that will require the least amount of archivelogs to be replayed? 11pm? After 5am? RMAN is my least understood part of the database.