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…
Check Status of SSH Service Verify current status of SSH service by using systemctl command. # systemctl status sshd.service â sshd.service – OpenSSH server daemon Loaded: loaded (/usr/lib/systemd/system/sshd.service; enabled; vendor preset: enabled)…
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…
Error: ORA-12537: TNS:connection closed Details: Occurred on a standby database after switchover from primary to standby. Error came up when checking DataGuard broker configuration. Cause: The mrp process not running on standbySolution:Checked if…
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…