u9707118
asked on
recover oracle 9i db without backup
Hi,
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/
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.
Many thanks.
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/
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.
Many thanks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry for taking so long...
I still have not found the time to look at the problem and cannot guarantee when I will be able to look at it.
For now I have just split the points.
When I do get time to sort it out, if any of the above answers do not solve the problem....I'll just post a new question.
Thanks to all those who tried to help out.
I still have not found the time to look at the problem and cannot guarantee when I will be able to look at it.
For now I have just split the points.
When I do get time to sort it out, if any of the above answers do not solve the problem....I'll just post a new question.
Thanks to all those who tried to help out.
ASKER
I will try them out as soon as I get back.
Cheers.