DataGuard Archives - Page 4 of 4

ORA-10567: Redo is inconsistent with data block on standby !!

Issues: ORA-10567: Redo is inconsistent with data block on standb Error: Thu May 21 18:24:10 2022 Errors in file /u02/diag/rdbms/prod/prod1/trace/prod1_pr0s_12697.trc (incident=360771): ORA-00600: internal error code, arguments: [3020], [408], [671265], [1711947297],…

asrblogger July 26, 2022No Comments

DataGuard

Physical Standby Configuration with ASM.

DataGuard_Conf_Primary-_with-ASMDownload DataGuard_Conf_Standby_with-ASMDownload

asrblogger July 3, 2022No Comments

DataGuard Oracle

ORA-01194: file 1 needs more recovery to be consistent

SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01194: file 1 needs more recovery to be consistent ORA-01110: data file 1: ‘/u01/app/oracle/oradata/prod/system01.dbf' Suppose we are…

asrblogger May 1, 2022No Comments

DataGuard Interview Questions

Important Parameters in Data Guard

DB_NAME On a primary database, specify the name used when the database was created. On a physical standby database, use the DB_NAME of the primary database. DB_UNIQUE_NAME Specify a unique…