Hello Experts,
I have that Scenario:
I have last week os copy (storage sync backup) backup for standby creation. And i have restore database and restore fresh standby control file.
After restore control file i have found there is 20 datafile newly created on primary which is not available on backup.
So i want to restore newly created datafiles. Which option is better to restore only missing(newly created) datafiles.
Can you suggest. We have last three days archive logs backup.
Thanks in advance.
Just create the missing datafiles at DR and apply logs (if there is big LAG then take an incremental backup from primary based of DR SCN) and apply that over to standby.
Note - if standby file management is set to manual at primary then every time you will have create data file manually at DR which are added at primary.