jika database di startup terjadi error
Fix ORA-03113: end-of-file on communication channel
[oracle@localhost ~]$ sqlplus / as sysdba
SQL> startup
ORACLE instance started.
Total System Global Area 4993982464 bytes
Fixed Size 2261808 bytes
Variable Size 1006636240 bytes
Database Buffers 3976200192 bytes
Redo Buffers 8884224 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 4903
Session ID: 237 Serial number: 26032
maka solusi :
Cara Pertama :
[oracle@localhost ~]$ sqlplus / as sysdba
SQL> startup mount;
ORACLE instance started.
Total System Global Area 4993982464 bytes
Fixed Size 2261808 bytes
Variable Size 1006636240 bytes
Database Buffers 3976200192 bytes
Redo Buffers 8884224 bytes
Database mounted.
SQL> SELECT GROUP# FROM V$LOG;
GROUP#
----------
1
3
2
SQL> alter database clear unarchived logfile group 1;
Database altered.
SQL> alter database clear unarchived logfile group 2;
Database altered.
SQL> alter database clear unarchived logfile group 3;
Database altered.
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 4993982464 bytes
Fixed Size 2261808 bytes
Variable Size 1006636240 bytes
Database Buffers 3976200192 bytes
Redo Buffers 8884224 bytes
Database mounted.
Database opened.
Cara Kedua :
[oracle@localhost ~]$ sqlplus /nolog
SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.
Total System Global Area 4993982464 bytes
Fixed Size 2261808 bytes
Variable Size 1006636240 bytes
Database Buffers 3976200192 bytes
Redo Buffers 8884224 bytes
Database mounted.
Kita dapat meningkatkan db_recovery_file_dest_size saat ini, meningkat menjadi 100G dalam ini:
cara :
SQL> alter system set db_recovery_file_dest_size = 100G scope=both; System altered. Now, you can shutdown and startup again and that previous error should be gone. The proper fix is to get rid of the recovery files. You do that using RMAN [oracle@localhost ~]$ rman target / Recovery Manager: Release 11.2.0.4.0 - Production on Fri Aug 16 14:49:39 2019 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. connected to target database: DB11G (DBID=432722608, not open) RMAN> backup archivelog all delete input; Starting backup at 16-AUG-19 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=156 device type=DISK specification does not match any archived log in the repository backup cancelled because there are no files to backup Finished backup at 16-AUG-19 RMAN> exit
Recovery Manager selesai.
semua archive ruang akan dikosongkan, maka sekarang adalah mematikan dan memulai atau menghidupkan database
[oracle@jktdi009 ~]$ sqlplus / as sysdba
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 4993982464 bytes
Fixed Size 2261808 bytes
Variable Size 1006636240 bytes
Database Buffers 3976200192 bytes
Redo Buffers 8884224 bytes
Database mounted.
Database opened.
