Oracle Dataguard Scripts
1) Information of database (Primary & Standby). 2) To display current status for Physical Standby…
Read moreDataGuard
Standby : Unnamed file issue
Sun Jan 1 22:02:11 2022 Errors in file /u01/app/oracle/diag/rdbms/proddb/proddb1/trace/proddb1_pr00_117080.trc: ORA-01111: name for data file 185…
Read moreORA-10567: Redo is inconsistent with data block on standby !!
Issues: ORA-10567: Redo is inconsistent with data block on standb Error: Solution: 1) At the…
Read morePhysical Standby Configuration with ASM.
DataGuard_Conf_Primary-_with-ASMDownload DataGuard_Conf_Standby_with-ASMDownload
Read moreORA-01194: file 1 needs more recovery to be consistent
SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01194:…
Read moreImportant Parameters in Data Guard
DB_NAME On a primary database, specify the name used when the database was created. On…
Read more