ora-01033: Oracle initialization or shutdown in progress [message #444781] |
Wed, 24 February 2010 03:10 |
monasingh
Messages: 229 Registered: May 2006 Location: Mumbai
|
Senior Member |
|
|
Hi,
I am getting the error 'ora-01033: Oracle initialization or shutdown in progress' when I try to login into oracle. It was working fine some days ago.
I tried the below steps :-
C:\Documents and Settings\sk32740>sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 24 14:31:08 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected.
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup nomount
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1248552 bytes
Variable Size 100664024 bytes
Database Buffers 176160768 bytes
Redo Buffers 7139328 bytes
SQL> alter database mount;
Database altered.
SQL>
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-16038: log 2 sequence# 324 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1:
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG'
SQL>
I even tried increasing the value of db_recovery_file_dest_size
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=2048576000 SCOPE=BOTH;
System altered.
SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORA-32004: obsolete and/or deprecated parameter(s) specified
ORACLE instance started.
Total System Global Area 285212672 bytes
Fixed Size 1248552 bytes
Variable Size 100664024 bytes
Database Buffers 176160768 bytes
Redo Buffers 7139328 bytes
Database mounted.
ORA-16038: log 2 sequence# 324 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 2 thread 1:
'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG'
Please advice.
Regards,
Mona
|
|
|
|
|