Solution to error ORA-03113 CRS-5017 PRCR-1079 ~ Blog for oracle RAC Goldengate Dataguard ASM database

Hello Friend's,

In this post we will discuss about error of inconsistent control file. The Error the solution to error (ORA-03113).

so let's get started.

error recieved will be as below :


[oracle@dm01gg01 ~]$ srvctl start database -d CDBSOURCE;
PRCR-1079 : Failed to start resource ora.cdbsource.db
CRS-5017: The resource action "ora.cdbsource.db start" encountered the following error:
ORA-03113: end-of-file on communication channel
Process ID: 6517
Session ID: 1 Serial number: 53604
. For details refer to "(:CLSN00107:)" in "/oracle/app/grid/diag/crs/dm01gg01/crs/trace/ohasd_oraagent_grid.trc".

CRS-2674: Start of 'ora.cdbsource.db' on 'dm01gg01' failed

Error in alertlog will be as follows.


2020-07-31T23:36:27.384806+05:30
krsd_check_stuck_arch: stuck archiver condition cleared
2020-07-31T23:36:27.510507+05:30
Unable to create archive log file '+DATA'
2020-07-31T23:36:27.510684+05:30
Errors in file /oracle/app/orawork/diag/rdbms/cdbsource/CDBSOURCE/trace/CDBSOURCE_arc0_14831.trc:
ORA-19504: failed to create file "+DATA"
ORA-17502: ksfdcre:4 Failed to create file +DATA
ORA-15041: diskgroup "DATA" space exhausted
ARC0: Error 19504 Creating archive log file to '+DATA'
krsd_check_stuck_arch: stuck archiver: insufficient local LADs
krsd_check_stuck_arch: stuck archiver condition declared

Now login to asmcmd check the diskgroup usage:


[grid@dm01gg01 ~]$ asmcmd
ASMCMD>
ASMCMD>
ASMCMD>
ASMCMD> lsdg
State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512             512   4096  4194304     20476      104                0             104              0             N  DATA/
MOUNTED  EXTERN  N         512             512   4096  4194304     10236     1060                0            1060              0             N  FRA/
ASMCMD>

Take a backup of archives and delete it from the location

Error is resolved now : Start the database.


[oracle@dm01gg01 ~]$ srvctl start database  -d CDBSOURCE
[oracle@dm01gg01 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Fri Jul 31 23:58:38 2020

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> set pages 9999 lines 300
col OPEN_MODE for a10
col HOST_NAME for a30
select name DB_NAME,HOST_NAME,DATABASE_ROLE,OPEN_MODE,log_mode,version DB_VERSION,LOGINS,to_char(STARTUP_TIME,'DD-MON-YYYY HH24:MI:SS') "DB UP TIME" from v$database,v$instance;
SQL> SQL> SQL>
DB_NAME   HOST_NAME                      DATABASE_ROLE    OPEN_MODE  LOG_MODE     DB_VERSION        LOGINS     DB UP TIME
--------- ------------------------------ ---------------- ---------- ------------ ----------------- ---------- -----------------------------
CDBSOURC  dm01gg01.database.com          PRIMARY          READ WRITE ARCHIVELOG   12.2.0.1.0        ALLOWED    31-JUL-2020 23:57:16

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDBSOURCE                      READ WRITE NO

Solution to error ORA-03113 CRS-5017 PRCR-1079

Related Post