Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Not able to open database in Oracle
Patel
post Apr 20 2017, 01:08 AM
Post #1


Newbie
*

Group: Members
Posts: 2
Joined: 13-April 17
Member No.: 51,905



I am facing an issue where i am not able to open the database. Gettting the error "ORA-00312: online log 2 thread 1: '/u01/app/oracle/fast_recovery_area/XE/onlinelog/o1_mf_2_dgy5sxv5_.log'"

Since i am unable to open the database, i cant do log switching. If anyone has faced this issue, please share the inputs to overcome above error and open the database. Tried all the different ways mentioned in different forums but still stuck.

SQL> ALTER SYSTEM SWITCH LOGFILE
2 ;
ALTER SYSTEM SWITCH LOGFILE
*
ERROR at line 1:
ORA-01109: database not open


SQL> ALTER SYSTEM ARCHIVE LOG GROUP 2;
ALTER SYSTEM ARCHIVE LOG GROUP 2
*
ERROR at line 1:
ORA-00259: log 2 of open instance XE (thread 1) is the current log, cannot archive



--------------------
regards,
Patel
Go to the top of the page
 
+Quote Post
Chaandan Bose
post Apr 22 2017, 02:24 PM
Post #2


Newbie
*

Group: Members
Posts: 3
Joined: 22-April 17
Member No.: 51,922



QUOTE (Patel @ Apr 20 2017, 11:38 AM) *
I am facing an issue where i am not able to open the database. Gettting the error "ORA-00312: online log 2 thread 1: '/u01/app/oracle/fast_recovery_area/XE/onlinelog/o1_mf_2_dgy5sxv5_.log'"

Since i am unable to open the database, i cant do log switching. If anyone has faced this issue, please share the inputs to overcome above error and open the database. Tried all the different ways mentioned in different forums but still stuck.

SQL> ALTER SYSTEM SWITCH LOGFILE
2 ;
ALTER SYSTEM SWITCH LOGFILE
*
ERROR at line 1:
ORA-01109: database not open


SQL> ALTER SYSTEM ARCHIVE LOG GROUP 2;
ALTER SYSTEM ARCHIVE LOG GROUP 2
*
ERROR at line 1:
ORA-00259: log 2 of open instance XE (thread 1) is the current log, cannot archive




Could you please paste alert log details
Go to the top of the page
 
+Quote Post
burleson
post Apr 25 2017, 09:50 AM
Post #3


Advanced Member
***

Group: Members
Posts: 13,571
Joined: 26-January 04
Member No.: 13



Hi,

>> ORA-00312

http://www.dba-oracle.com/t_rman_135_recov...o_log_group.htm

************************************************

This may help:

http://www.dba-oracle.com/t_ora_00259_log_of_open.htm




--------------------
Hope this helps . . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 20th October 2017 - 02:09 AM