0

Log files are missing on my standby database server, please help to re create it. My standby database was created manual method.

enter image description hereenter image description here

I need to get the missing redo logfiles back on standby database.

Improve this question

2 Answers 2

Reset to default
2

They will be created when you open the standby database. Online redo log files are not used in a standby (manual or Data Guard) database in MOUNT stage.

Improve this answer
-2

try running this command on standby -

ALTER DATABASE CLEAR LOGFILE GROUP 1;

then check if files are created for group 1. follow same for other groups as well

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.