Hi Dear ,

I have faced this problem to a client server.I couldn’t open database and software then arise this problem.

ORA-16038: log 1 sequence# 35 cannot be archived

ORA-19809: limit exceeded for recovery files

ORA-00312: online log 1 thread 1:

‘/home/oracle/10.2.0/product/oradata/MYDB/redo01.log’

—–Finally i had succeed flowing step :————-

****You can check the total and used size using below query

ORA-01033: ORACLE initialization or shutdown in progress :>>>>>

SQL> select status, database_status from v$instance;
STATUS DATABASE_STATUS


STARTED ACTIVE

SQL> select open_mode from v$database;
*
ERROR at line 1:
ORA-01507: database not mounted

SQL> alter database mount;
Database altered.
SQL> select status, database_status from v$instance;
STATUS DATABASE_STATUS


MOUNTED ACTIVE

SQL> select open_mode from v$database;

OPEN_MODE

MOUNTED

SQL> alter database open;
Database altered.
SQL> select status, database_status from v$instance;
STATUS DATABASE_STATUS


OPEN ACTIVE
SQL> select open_mode from v$database;
OPEN_MODE
——-if database not altered then flow this process>>>>>>>>>
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcratr_nab_less_than_odr], [1],
[613], [42759], [42760], [], [], [], [], [], [], []

SQL> startup mount

ORACLE Instance started

SQL> recover database

Media recovery complete

SQL> alter database open

Database altered

****You can also  delete the  expired archive logs —

RMAN>connect target sys/sys@orcl;

RMAN>crosscheck archivelog all;

RMAN>delete expired archivelog all;

Also get problem try again bellow instruction :

SQL>  Show parameter control_files;

NAME                                 TYPE        VALUE


control_files                        string      C:\DB\ORADATA\ORCL\CONTROL01.C
TL, C:\DB\FLASH_RECOVERY_AREA\
ORCL\CONTROL02.CTL
SQL> select a.member,a.group#,b.status from v$logfile a ,v$log b where a.group#=
2  b.group# and b.status=’CURRENT’;
MEMBER                                                       GROUP#   STATUS
C:\DB\ORADATA\ORCL\REDO01.LOG        1            CURRENT
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 2480971 generated at 12/08/2015 00:31:48 needed for thread 1
ORA-00289: suggestion :
C:\DB\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2015_12_18\O1_MF_1_163_%U_.ARC
ORA-00280: change 2480971 for thread 1 is in sequence #163
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
C:\DB\ORADATA\ORCL\REDO01.LOG  —-manually input this log file with locatin
Log applied.
Media recovery complete.
SQL> alter database open resetlogs;

Database altered.

Thanks to all……………continue with me.

 

Advertisements