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.

3 Answers 3

0

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.

0

My standby database is opened read only mode but online redo log has not created, I mean physical files are missing on the server in OS level. If I check on DB side it’s showing logically files are associated in database.

1
  • And why do you think you need those files? Online redo log files are not used in read only mode. Apr 30, 2023 at 16:18
-1

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

Your Answer

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