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’ …
Category:
Troubleshoot
-
-
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 …
-
Troubleshoot
RMAN-05537: DUPLICATE without TARGET connection when auxiliary instance is started with spfile cannot use SPFILE clause
by tuanlpby tuanlpHow 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: =============== …
-
Troubleshoot
RMAN-04014: startup failed: ORA-09925: Unable to create audit trail file during creation of physical standby using RMAN
by tuanlpby tuanlpRMAN> 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 …
-
OracleTroubleshootUncategorized
How to deal with ORA-00020: maximum number of processes (%s) exceeded
by tuanlpby tuanlpI 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 …
-
Troubleshoot
ORA-10873: file 1 needs to be either taken out of backup mode or media recovered
by tuanlpby tuanlpORA-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 …
-
OracleTroubleshoot
How to resolve ORA-01111 ORA-01110 ORA-01157 in a physical standby database
by tuanlpby tuanlpSOLUTION 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 …