Troubleshoot

DGMGRL> show configuration;Configuration – DG_TST1T  Protection Mode: MaxAvailability  Databases:    TST1TS – Primary database    TST1TP – Physical standby database      Error: ORA-16765: Redo Apply is runningFast-Start Failover: DISABLEDConfiguration Status:ERRORCAUSE:Broker configuration out of…

How to check the FRA usage and troubleshoot the issue in oracle DB? step1)Check the FRA usage. SELECTROUND((A.SPACE_LIMIT / 1024 / 1024 / 1024), 2) AS FLASH_IN_GB,ROUND((A.SPACE_USED / 1024 /…

Problem DescriptionOracle physical standby database is not able to synchronize with the primary database. From the standby database alert log we see the following logs. Thu Sep 23 14:57:47 2010RFS[2237]:…

Once while configuring the dataguard broker, i faced the ORA-16625 and ORA-16501 . This error occurs beacuse the broker rejects an operation requested by the client when the database required to execute that operation…

How to resolve the error   RMAN-05537: DUPLICATE without TARGET connection when auxiliary instance is started with spfile cannot use SPFILE clause ? Error:Starting Duplicate Db at 9-SEP-14RMAN-00571: ===========================================================RMAN-00569: ===============…

RMAN> connect target sys target database Password: connected to target database: TESTDB1 (DBID=693279980) RMAN> connect auxiliary sys@testdb2 auxiliary database Password: connected to auxiliary database: TESTDB2 (not mounted) RMAN> run{ allocate…

ORA-10873: file 1 needs to be either taken out of backup mode or media recovered Error: Getting the following error while starting the Oracle database. Cause: As per the error the system…