Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

redo logs issue...

Efarah-OracleApr 9 2012 — edited Apr 9 2013
Hi Gurus,
I have a development database (study purpose) on which I run some apex applications.
it's 11g and runs in a regular PC with Windows Vista Home Edition (service pack 2).
because it's just for study I never bothered to backup it. (I know, I'm an idiot!).
few days ago, my PC crashed and there were some disk issues, already fixed.

the actual status of the database is:
it mounts but doesn't open.

SQL> select open_mode from v$database;

OPEN_MODE
--------------------
MOUNTED

SQL> select * from v$log;

GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- --------- ------------ ---------
1 1 1 52428800 512 1 NO CURRENT 12285781 09-APR-12 2.8147E+14
3 1 0 52428800 512 1 YES UNUSED 0 0
2 1 0 52428800 512 1 YES UNUSED 0 0

SQL> select * from v$logfile;

GROUP# STATUS TYPE MEMBER IS_
---------- ------- ------- -------------------------------------------------------------------------------- ---
3 ONLINE M:\SOFTWARES\ORACLE\ORADATA\ORAEDU\REDO03.LOG NO
2 ONLINE M:\SOFTWARES\ORACLE\ORADATA\ORAEDU\REDO02.LOG NO
1 ONLINE M:\SOFTWARES\ORACLE\ORADATA\ORAEDU\REDO01.LOG NO


when I try to open, it returns:
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 300
Session ID: 5 Serial number: 7

I have gone through some of the posts in the forum with similar issues and have tried a few steps... (such as "recover database until cancel" and "open resetlogs") but apparently there's no success on that.

listener is up an running (tnsping against the instance works fine).

in case someone can help, 3 questions below.

1) what's the recommended approach here?
I was wondering, before I mess up (MORE) with my data, if I could create new redo logs / groups and expect this to work ?

2) without any backup should I throw my "study apps" away or I still have some options to revover them?

other question is: 3) in case this DB is gone. Is there ANY way to get my data (DDL and data) as well as my apex code?
I have created all my apps in different tablespaces.. .but have never done this process of moving them into another DB... that's the reason for asking...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 7 2013
Added on Apr 9 2012
17 comments
3,829 views