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 10.2.0.1.0 - 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 :
/oravl01/oracle/flash_recovery_area/LUXGSM/archivelog/2012_02_16/o1_mf_1_115_%u_
.arc
ORA-00280: change 3977276 for thread 1 is in sequence #115


Specify log: {=suggested | filename | AUTO | CANCEL}
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'


SQL>