database not open – redo log fail

database couldn’t open because i got the error,

ORA-00313: open failed for members of log group 1 of thread 1

ORA-00312: online log 1 thread 1: ‘E:\REDO\REDO01_01.ILG’

ORA-00312: online log 1 thread 1: ‘H:\REDO\REDO01_02.ILG’

i search some explanation about the error,

ora-00312: online log %s thread %s: ‘%s’

*Cause:  This message reports the filename for details of another message.

*Action: Other messages will accompany this message. See the

associated messages for the appropriate action to take.

ora-00313: open failed for members of log group %s of thread %s

*Cause:  The online log cannot be opened. May not be able to find file.

*Action: See accompanying errors and make log available.

so to open database, follow the step,

1)Using V$LOG, got the status of each group

In mount mode,

2) Clear the log groups which are not current,

ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1

3) RECOVER DATABASE UNTIL CANCEL (This is what i missed and looking for the help)

4) ALTER DATABASE OPEN RESETLOGS;

OPEN RESETLOGS is valid whenever you make an incomplete recovery

How to change oracle report server name ?

for example, my report server was rep_appserver, then i want to rename it to rep_test.

Here some step to accomplish it,

1.   stop mid-tier
$ORACLE_HOME\opmn\bin\opmnctl stopall

2.   stop em website
$ORACLE_HOME\bin\emctl stop iasconsole

3.   rename $ORACLE_HOME\reports\conf\rep_<old_report_server_name>.conf to something else or delete it

4.   rename $ORACLE_HOME\reports\server\rep_<old_report_server_name>.dat to something else or delete it

5.   edit $ORACLE_HOME\reports\conf\rwservlet.properties file then change the SERVER parameter to new report server name(remember this new name has to be a unique name)

6.   create a backup copy of the $ORACLE_HOME\sysman\emd\targets.xml file

7.   open $ORACLE_HOME\sysman\emd\targets.xml, find old report server name and then replace it to new report server name

8.   save new targets.xml file

9.   open $ORACLE_HOME\opmn\conf\opmn.xml, old report server name and then replace it to new report server name, if you can find it, try to search for opmn.xml in $ORACLE_HOME.

10. start em website
$ORACLE_HOME\bin\emctl start iasconsole

11. start mid-tier
$ORACLE_HOME\opmn\bin\opmnctl startall

REP-56040: Server rep_ already exists in the network.

If this message occured, than you probably have a reports server by the same name running on your subnet.
Use a different name for your oracle report server.