solusi error pada oracle redo log

26 Jul

solusi error pada oracle redo log

[oracle@orcl5 orcl5]$ sqlplus / as sysdba
SQL> startup;
ORACLE instance started.
Total System Global Area 1653518336 bytes
Fixed Size                  2144944 bytes
Variable Size            1174406480 bytes
Database Buffers          469762048 bytes
Redo Buffers                7204864 bytes
Database mounted.
ORA-16014: log 2 sequence# 671 not archived, no available destinations
ORA-00312: online log 2 thread 1: ‘/u01/orcl5/redo02.log’

cara mengatasinya :
1. shutdown immediate
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

2. startup mount
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1653518336 bytes
Fixed Size                  2144944 bytes
Variable Size            1174406480 bytes
Database Buffers          469762048 bytes
Redo Buffers                7204864 bytes
Database mounted.

3. ALTER DATABASE RECOVER DATABASE UNTIL CANCEL
SQL> ALTER DATABASE RECOVER DATABASE UNTIL CANCEL;
Database altered.

4. ALTER DATABASE OPEN RESETLOGS
SQL> ALTER DATABASE OPEN RESETLOGS;
Database altered.

5. shutdown immediate
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

6. startup
SQL> startup;
ORACLE instance started.
Total System Global Area 1653518336 bytes
Fixed Size                  2144944 bytes
Variable Size            1174406480 bytes
Database Buffers          469762048 bytes
Redo Buffers                7204864 bytes
Database mounted.
Database opened.

7. periksa archive log
SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u02/orcl5/archive/archive01
Oldest online log sequence     1
Next log sequence to archive   1
Current log sequence           1

8. listener
[oracle@orcl5 orcl5]$ lsnrctl status
LSNRCTL for Linux: Version 11.1.0.6.0 – Production on 26-JUL-2011 09:39:26
Copyright (c) 1991, 2007, Oracle.  All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=orcl5.localdomain)(PORT=1521)))
STATUS of the LISTENER
————————
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.1.0.6.0 – Production
Start Date                24-JUL-2011 10:42:08
Uptime                    1 days 22 hr. 57 min. 17 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/11.1.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/orcl5/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=orcl5.localdomain)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
Services Summary…
Service “orcl5” has 1 instance(s).
Instance “orcl5”, status READY, has 1 handler(s) for this service…
Service “orcl5XDB” has 1 instance(s).
Instance “orcl5”, status READY, has 1 handler(s) for this service…
Service “orcl5_XPT” has 1 instance(s).
Instance “orcl5”, status READY, has 1 handler(s) for this service…
The command completed successfully

9. test login
[oracle@orcl5 orcl5]$ sqlplus scott/tiger@orcl5
SQL*Plus: Release 11.1.0.6.0 – Production on Tue Jul 26 09:39:47 2011
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@orcl5 orcl5]$

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: