Error log: 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/ORCL/system01.dbf’…
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…
I recently had a situation where access to the database was completely blocked because of the infamous error message ORA-00020: maximum number of processes (%s) exceeded Facts:The database had processes…
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…
SOLUTION Please perform the following steps on the physical standby database to resolve the issue. – Please cancel the managed recovery by – Set standby_file_management=manual If the physical standby database…
The primary database is operating in MAXIMUM PROTECTIONor MAXIMUM AVAILABILITY mode, and the standby database doesnot contain any viable standby redo logfiles.ORA-16086: Redo data cannot be written to the standby…