This is one of my favourite method of instantiation as most of the time I worked on the environment where database is quite big in size and replicated database was created from the backup of primary database.
As database backup and restore can take hours and during that time it might not be feasible to leave capture or extract process running. In this case, Oracle data pump can be used to export tables or schema(s) from the source database. The falshback_scn export parameter is specified in the expdb command line. The current SCN of the source database is specified as the flashback_scn. Key point is to find the SCN number from the point when backup ends and use it to export data from that point onwards.
This information can also be found through RMAN while doing backup or last SCN applied at target database before resetting the log files i.e. SCN number.
As database backup and restore can take hours and during that time it might not be feasible to leave capture or extract process running. In this case, Oracle data pump can be used to export tables or schema(s) from the source database. The falshback_scn export parameter is specified in the expdb command line. The current SCN of the source database is specified as the flashback_scn. Key point is to find the SCN number from the point when backup ends and use it to export data from that point onwards.
This information can also be found through RMAN while doing backup or last SCN applied at target database before resetting the log files i.e. SCN number.
