Increase redo log file size

Check Standby Thread number and Size for Standby redo logs. As you see standby is unassigned status means it is not used by standby database. Stop the data-guard recovery process in Standby database: -- for standby db which is under recovery, recovery needs to be stopped first alter database recover managed standby database cancel;.

In this example we configure 6 standby redo files. Start the Recovery of the dataguard in oracle. Pingback: Smart way of Technology. You are commenting using your WordPress. Like the article Share it.

Leave a Reply Cancel reply. Search for:. Anonymous Posted November 14, 0 Comments. Register or Login. Welcome back!

Sign in with Email. Reset Your Password We'll send an email with a link to reset your password. Stay ahead! Get the latest news, expert insights and market research, tailored to your interests. Sign up with Email. Sign in with email Enter the email address associated with your account. You auth link is expired or incorrect, please try again. Your email address will not be published. Save my name, email, and website in this browser for the next time I comment.

Redo Log File. Resize Redo Logs The default size of redo logs during installation is 50MB which is too small for production databases.