Oracle Database Discussions

Hi all
I was copied virtual machine with oracle 11g expres (11.2.0.1) install on CentOS 5.6 64bytes
and when I was start up I have error: ora-00333
then I was run
sql>recover database until cancel;
ORA-00279 :change 7876345672341 generated at 10/13/2011
10:33:07 needed for thread 1
ORA-00289 : suggestion:
/u01/app/oracle/flash_recovery_area/XE/archivelog/2011_11_25/01_mf_1_400_%u_.arc
ORA-OO280 : change 7876345672341 for threat 1 is in sequence #305

sql>select * from v$logfile;

GROUP# STATUS TYPE MEMBER
1 online /u01/app/oracle/xe/flash_recovery_area/XE/onlinelog/o1_mf_1_75nf3sxb_.log
2 online /u01/app/oracle/xe/flash_recovery_area/XE/onlinelog/o1_mf_1_75nf5sxb_.log

and then I was type:
sql>alter database clear log file '/u01/app/oracle/xe/flash_recovery_area/XE/onlinelog/o1_mf_1_75nf3sxb_.log';

. - Database altered

... and error stil exist !

sql>alter database open resetlogs;
alter database open resetlogs;
*
ERROR at line 1:
ORA-01139:RESETLOGS option only valid after an incoplete database recovery

alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u01/app/oracle/xe/oradata/system.dbf'



-any solution?
-is reason for that bad sector?

regards
Gordan

Edited by: useruseruser on Oct 26, 2011 7:13 PM

Edited by: useruseruser on Oct 26, 2011 7:16 PM