How to recover database with the loss of redo logs and without backup.
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>