0 Replies Latest reply: Apr 1, 2013 2:56 PM by 1000351 RSS

    i can not open database

    1000351
      Hi
      i hava problem during open database.
      Please can any one help me solve this problem?
      This problem came as a result of power cut

      **********************************
      SQL> startup mount;
      ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
      ORACLE instance started.

      Total System Global Area 1987641344 bytes
      Fixed Size 2254488 bytes
      Variable Size 1006635368 bytes
      Database Buffers 973078528 bytes
      Redo Buffers 5672960 bytes
      Database mounted.
      SQL> alter database open;
      alter database open
      *
      ERROR at line 1:
      ORA-01113: file 1 needs media recovery
      ORA-01110: data file 1: 'D:\ORACLE\PDT\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'


      SQL> recover database using backup controlfile;
      ORA-00283: recovery session canceled due to errors
      ORA-16433: The database must be opened in read/write mode.

      encloesd you will find files "alert_pdt.log" and "pdt_pr00_3884.trc"
      I would be very gratefull if anybody could provide answer to this issue.