Physical Standby Database recovery using Recover From Service Command

[@arifansari42]

Greate session 👍 Can you please share the document which are you used during this session?

[@sureshchintam7407]

Thanks for ur sharing knowledge 🙏

[@OracleDBAOnlineTraining]

You are welcome.. keep watching keep learning

[@swathik4076]

Can you pls explain why the control file is restored after restoring the datafiles? Can we first restore the controfile from service and then restore the db from service?

[@OracleDBAOnlineTraining]

Because we need to refresh the control file after restoration of datafile

[@swathik4076]

@@OracleDBAOnlineTraining can we first restore controlfile, catalog the standby data files location, switch database to copy and then start the db restore form service?

[@nagarjunareddy1495]

We can do both ways.

[@rijulife1255]

Very useful session..

[@OracleDBAOnlineTraining]

Thank you for watching our videos

[@remkovandepeppel1943]

Nice explenation

[@OracleDBAOnlineTraining]

Thank you for watching our videos

[@mido2elghoury]

Great job bro

[@OracleDBAOnlineTraining]

Thank you so much

[@sreenivasanatla8192]

why you need to restore control file and also why noredo

[@sreenivasanatla8192]

I just tested and no need to restore control file

[@sreenivasanatla8192]

NOTE: Because the online redo logs are lost, you must specify the NOREDO option in the RECOVER command. You must also specify NOREDO if the online logs are available but the redo cannot be applied to the incrementals. If you do not specify NOREDO, then RMAN searches for redo logs after applying the incremental backup, and issues an error message when it does not find them.