-
Oracle 'SYSTEM01.DBF' error
Hi,
I'm facing some problems with oracle 9i on my test machine. It seems the database has badly crashed. While using 'startup mount;' command I was receiving some error for REDO03.LOG file, which I solved somehow by using 'alter database rename file 'old path' to 'new path';' command.
On using 'alter database open resetlogs;' command, I receive error message as below:
SQL> 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: 'C:\ORACLE\ECC\SYSTEM01.DBF'
Please advice how to resolve this error. Secondly, please post your replies with commands as I'm not too used to Oracle.
-
why did you do the alter database rename
if you dont have the log you will need to do a recovery
-
Recover...
Maybe this will work:
Code:
ALTER DATABASE RECOVER DATAFILE '{the file you renamed}';
If not, you may need to do recovery as davey23uk posted.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
-
I actually renamed that file back to original one.... Do you think I still need to use this recovery command?
-
SQL> select member from v$logfile;
MEMBER
----------------------------------
C:\ORACLE\ECC\REDO01.LOG
C:\ORACLE\ECC\REDO02.LOG
C:\ORACLE\ECC\REDO03.LOG
-
Even after this change I receive the same error message:
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: 'C:\ORACLE\ECC\SYSTEM01.DBF'
-
what do you mean renamed the file back to the original one
what exactly did you do and why
if you overwrote the online log - you are screwed
-
i used command
"alter database rename file ''C:\ORACLE\ECC\REDO033.LOG' to 'C:\ORACLE\ECC\REDO03.LOG';"
-
I admit I must have made some serious mistake & do require your assistance for solution....
-
why did you do the rename - for what purpose?
why did it have the wrong name
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|