redo logs issue...
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...