DATA GUARD TROUBLESHOOTING

Take Control: True Private Internet Browsing‎ with Brave Download the Brave Browser ⇒ It’s a safer and faster alternative than Chrome   This post provides help troubleshooting a standby database (dataguard). This article covers the following problems: Troubleshooting Log transport services Troubleshooting Redo Apply services Troubleshooting SQL Apply services Common Problems Log File Destination Failures Handling […]

Found 1 new persistent data failures – Cloud Control Event/error

Enterprise Manager / Cloud Control 13c raised this event: EM Event: Critical:my-db.oracle-scripts.net – Checker run found 1 new persistent data failures.   By default the database runs the Health Check periodically to find: File corruptions, Physical and logical block corruptions, Undo or redo corruptions, data dictionary corruptions If any failures are detected then a message […]

Sql Server loop through databases

How can I run the same command on all SQL Server databases without cursors The stored procedure sp_MSforeachdb allows us to iterate through each database in a SQL Server instance without a loop statement. It’s usage is similar than sp_MSforeachtable; simply execute the stored procedure, passing it the command that you’d like to execute as […]