Scenario:
Let us consider oracle 3 node RAC. RMAN Managed Recovery is configured between production and standby DBs. Let us assume that the SCNs of 3 nodes are S1, S2, S3 at some point of time respectively. Let Smax=max(S1,S2,S3)
Is there any possibilities to get the archive file name containing the given SCN, Smax in oracle so as to stop applying logs at standby database as soon as the archive logs of the file containing the given SCN, Smax are applied?
Best Answer
If you want to stop recovery at a specific SCN, just run recovery until that specific SCN:
If you want the name of the files: