-
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....
-
Mount the database and recover system datafile.
SQL> alter database recover datafile 1;
As Dave said, if there is any mess-up with redo log files then you will screwed else you will be fine.
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
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
|