ORA-00257: archiver error. Connect internal only, until freed

7 Apr

Pagi ini, server mainan saya mengalami error
1. ORA-00257: archiver error. Connect internal only, until freed
2. ORA-03113: end-of-file on communication channel

Saya pikir karena space harddisk-nya habis, setelah saya cek space harddisknya masih banyak.
tetapi ternyata karena saya melakukan update sebuah table yang jumlahnya ribuan.

Berikut kronologinya :
1. Gagal login
[oracle@test42 ~]$ sqlplus scott/TIGER
SQL*Plus: Release 11.2.0.1.0 Production on Sat Apr 7 08:45:49 2012
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
ERROR:
ORA-00257: archiver error. Connect internal only, until freed.

2. Shutdown instance
[oracle@test42 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sat Apr 7 08:46:00 2012
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> SHUTDOWN immediate;
ORA-01013: user requested cancel of current operation

SQL> shutdown abort;
ORACLE instance shut down.

3. coba startup, malahan keluar ORA-03113: end-of-file on communication channel
SQL> startup;
ORACLE instance started.

Total System Global Area 1369579520 bytes
Fixed Size                  2213216 bytes
Variable Size            1124076192 bytes
Database Buffers          234881024 bytes
Redo Buffers                8409088 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 570
Session ID: 125 Serial number: 5

4. cara mengatasinya
SQL> startup mount;
ORACLE instance started.

Total System Global Area 1369579520 bytes
Fixed Size                  2213216 bytes
Variable Size            1124076192 bytes
Database Buffers          234881024 bytes
Redo Buffers                8409088 bytes
Database mounted.

5. lakukan recover database
SQL> recover database until cancel;
Media recovery complete.

6. resetlogs
SQL> alter database open resetlogs;
Database altered.

7. test dengan restart instance : shutdown & startup
SQL> shutdown;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup;
ORACLE instance started.
Total System Global Area 1369579520 bytes
Fixed Size                  2213216 bytes
Variable Size            1124076192 bytes
Database Buffers          234881024 bytes
Redo Buffers                8409088 bytes
Database mounted.
Database opened.

 

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: