Database Software

source DB: 5 nodes RAC

Clone DB: 1 node         

I cloned the database and trying to figure out estimated time to roll forward the database  for future for management.

I applied a snapshot that completed on 4/4/2016 at 9:20. So, the clone DB is mounted and needed to roll forward from 04/04/2016 - 9:20 a.m. to  4/5/2016 - 03:40 a.m. How would I figure out how many logs the recovery process will apply?

The recovery process shows the following:

  1. Arch files catalogued from snapshot = 838

1. 2. Total archived log applied to roll forward = 588

from gv$log_history

GROUP by to_char(first_time,'YYYY-MON-DD'), to_date(first_time)

order by to_date(first_time)

Hourly archived logs: