Friday, April 23, 2021

 

ORA-03113: end-of-file on communication channel Process ID: 9097 Session ID: 365 Serial number: 1


[oracle@NVMBRCPGRHSACS01WT trace]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Mon Jul 17 14:25:17 2017

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

Connected to an idle instance.

SQL> startup

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area 8.0973E+10 bytes

Fixed Size                  2237088 bytes

Variable Size            1.0737E+10 bytes

Database Buffers         7.0062E+10 bytes

Redo Buffers              171511808 bytes

ORA-03113: end-of-file on communication channel

Process ID: 9097

Session ID: 365 Serial number: 1

SQL>


Solution

========

startup mount;

alter database clear unarchived logfile group 1;

alter database clear unarchived logfile group 2;

alter database clear unarchived logfile group 3;

alter database open;

No comments:

Post a Comment

  RMAN-20207: UNTIL TIME or RECOVERY WINDOW is before RESETLOGS time https://shivanandarao-oracle.com/2012/12/05/rman-20207-until-time-or-re...