I have a Dataguard involving a physical standby database. This standby node, haven't been recovered for a very long time, a the mostly of the archive logs aren't present in the disks, and sure neither on tap.
I want to recover it with one of the RMAN backups that I have taken recently (last week) in the primary node, as part of the current backup policy. And my question is:
Which is the best way to recover/restore it with the full RMAN backup? must it be performed in the some way as when we restore an RMAN backup in a differente database in another different server where the RMAN backup was taken? - I want to say, as if the target database wasn't a part of a DataGuard infraestrctucture.
Thanks a lot in advance.
Sorry, I have answered you first, but there was a problem with my browser and the response wasn't sent.
Your link is strongly helpful for me in the same way, of course!
Thanks a lot for your fast response too, I'll tell you again when I performed the changes.
Have a nice day and kind regards
The official document you linked for me has been very useful. For example, I have perform with it some chekes that weren't reflected in the other link, for example:
SELECT MIN(FIRST_NONLOGGED_SCN) FROM V$DATAFILE WHERE FIRST_NONLOGGED_SCN>0;
SELECT FILE#, FIRST_NONLOGGED_SCN FROM V$DATAFILE WHERE FIRST_NONLOGGED_SCN > 0;
but at the end, I have needed to perform an explicity a backup of the control file to restore in the standby (BACKUP CURRENT CONTROLFILE FOR STANDBY FORMAT ...)
Finally, with the two documents, I have performed succesfully my task.
Thanks a lot, my friend!
We'll stay in touch, best regards