recover oracle 9i db without backup
Posted on 2005-03-28
I have an oracle 9i database running at home under RHEL 3.
Somehow, one of the redo logs got corrupted, and now the database will not open properly.
BTW, I have no backups.
I logged in as sysdba and did a 'recover database until cancel'. I then got the following message:
"ORA-01589: must use RESETLOGS or NORESETLOGS option for database open"
So then I did: "alter database open resetlogs;" and got the following message:
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/opt/oracle/oradata/icat/system01.dbf'
I tried the two steps above after raking around the internet, but as you can probably tell, I'm not
really sure what I am doing. Does any one know how I can recover the database?
If this is not possible, then how do I get the database back into a working state so that I can recreate
my schema's from scratch.