4 min read
1) Information of database (Primary & Standby). SQL> SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS FROM V$DATABASE; 2) To...
DataGuard
4 min read
2 min read
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 is unknown - rename to...
1 min read
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...
1 min read
DataGuard_Conf_Primary-_with-ASMDownload DataGuard_Conf_Standby_with-ASMDownload
1 min read
SQL> alter database open resetlogs; alter database open resetlogs * ERROR at line 1: ORA-01194: file 1 needs more recovery to...
2 min read
DB_NAME On a primary database, specify the name used when the database was created. On a physical standby database, use...
