Tagged articles
5 articles
Page 1 of 1
Aikesheng Open Source Community
Aikesheng Open Source Community
Dec 5, 2022 · Databases

Greenplum Standby Failure Diagnosis and Recovery Procedure

This article describes how to identify and fix Greenplum standby segment failures by inspecting segment status, comparing missing files, generating a recovery configuration, executing gprecoverseg commands, and verifying that all segments return to normal operation without service interruption.

GreenplumRecoverySQL
0 likes · 17 min read
Greenplum Standby Failure Diagnosis and Recovery Procedure
ITPUB
ITPUB
Aug 7, 2020 · Databases

How to Fix ORA-600 Errors Stalling Oracle Standby Log Apply

A detailed walkthrough shows how a mismatched COMPATIBLE parameter caused ORA-600 errors that blocked log apply on an Oracle 11.2.0.4 standby, and explains the step‑by‑step queries, diagnostics, and commands needed to correct the issue and resume synchronization.

CompatibilityDatabase AdministrationLog Apply
0 likes · 9 min read
How to Fix ORA-600 Errors Stalling Oracle Standby Log Apply
ITPUB
ITPUB
Aug 7, 2020 · Databases

How Changing the COMPATIBLE Parameter Fixed ORA-600 Errors on Oracle Standby

A single‑instance Oracle 11.2.0.4 primary‑standby setup on Windows encountered ORA‑600 errors on archived logs 17620 and 17621 after manual file deletions, and the detailed troubleshooting revealed a mismatched COMPATIBLE parameter that was corrected, allowing the standby to apply the missing logs and resume synchronization.

COMPATIBLEORA-600Oracle
0 likes · 9 min read
How Changing the COMPATIBLE Parameter Fixed ORA-600 Errors on Oracle Standby
ITPUB
ITPUB
Aug 10, 2016 · Databases

Step‑by‑Step Manual Setup of Oracle Data Guard on RH Linux

This guide walks through preparing the primary and standby Oracle 11g databases on RH Linux, configuring listeners, tnsnames, force logging, adding standby redo logs, editing parameter files, transferring files with RMAN, verifying roles, activating Active Data Guard, using snapshot standby, switching logs, and setting an archive‑log deletion policy.

Active Data GuardData GuardDatabase Replication
0 likes · 20 min read
Step‑by‑Step Manual Setup of Oracle Data Guard on RH Linux