Oracle 'SYSTEM01.DBF' error
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 23

Thread: Oracle 'SYSTEM01.DBF' error

Hybrid View

  1. #1
    Join Date
    Jan 2009
    Posts
    10

    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.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    why did you do the alter database rename

    if you dont have the log you will need to do a recovery

  3. #3
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,460

    Cool 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

  4. #4
    Join Date
    Jan 2009
    Posts
    10
    I actually renamed that file back to original one.... Do you think I still need to use this recovery command?

  5. #5
    Join Date
    Jan 2009
    Posts
    10
    SQL> select member from v$logfile;

    MEMBER
    ----------------------------------
    C:\ORACLE\ECC\REDO01.LOG
    C:\ORACLE\ECC\REDO02.LOG
    C:\ORACLE\ECC\REDO03.LOG

  6. #6
    Join Date
    Jan 2009
    Posts
    10
    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'

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    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

  8. #8
    Join Date
    Jan 2009
    Posts
    10
    i used command

    "alter database rename file ''C:\ORACLE\ECC\REDO033.LOG' to 'C:\ORACLE\ECC\REDO03.LOG';"

  9. #9
    Join Date
    Jan 2009
    Posts
    10
    I admit I must have made some serious mistake & do require your assistance for solution....

  10. #10
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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
  •  



Click Here to Expand Forum to Full Width