Hi All,

Could you please suggest me "How to recover database with the loss of redo logs and without backup". My oracle database is running in no archive log mode, and I have no previous backup. Please suggest the possiblity of recovering the database.

I am getting below error when trying to recover.

$ sqlplus / as sysdba

SQL*Plus: Release - Production on Thu Feb 16 22:21:25 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup mount
ORACLE instance started.

Total System Global Area 5133828096 bytes
Fixed Size 2000800 bytes
Variable Size 1157630048 bytes
Database Buffers 3959422976 bytes
Redo Buffers 14774272 bytes
Database mounted.
SQL> recover database using backup controlfile;
ORA-00279: change 3977276 generated at 12/25/2011 03:46:59 needed for thread 1
ORA-00289: suggestion :
ORA-00280: change 3977276 for thread 1 is in sequence #115

Specify log: {=suggested | filename | AUTO | CANCEL}
Media recovery cancelled.
SQL> alter database open resetlogs;
alter database open resetlogs
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oravl01/oracle/oradata/LUXGSM/system01.dbf'