How to do Media Recovery for System01.dbf????

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Praveen
    #1

    How to do Media Recovery for System01.dbf????

    Hi All,

    I'm using Oracle 8.1.7 on Win2k Prof. Today morning because of power
    problem, my system has restarted 8 times. When the power became stable
    and switch on my system, the oracle says 'Oracle initialization or
    shutdown in progress'. Then i tried by connecting....
    sqlplus /nolog
    connect sys/<pwd>@<sidas sysdba

    and i said.. startup pfile=d:\....\i nit.ora
    The database instance started and mounted also.But after that it is
    showing this error...

    ORACLE instance started.

    Total System Global Area 302086172 bytes
    Fixed Size 75804 bytes
    Variable Size 107839488 bytes
    Database Buffers 194093056 bytes
    Redo Buffers 77824 bytes
    Database mounted.
    ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

    Then i did...

    SQLalter database open resetlogs;
    alter database open resetlogs
    *
    ERROR at line 1:
    ORA-01113: file 1 needs media recovery
    ORA-01110: data file 1: 'D:\ORACLE\ORAD ATA\...\SYSTEM0 1.DBF'

    Can anybody please him me out, what i have to do?

    **This is just a development db. So, i did not kept db in archive
    Mode.

    Thanks in advance,
    Praveen
    Tags: None
    • Mark D Powell
      #2
      Re: How to do Media Recovery for System01.dbf??? ?

      spraveen2001@ya hoo.com (Praveen) wrote in message news:<98d8ec76. 0310152346.2e3e 01ab@posting.go ogle.com>...
      Hi All,
      >
      I'm using Oracle 8.1.7 on Win2k Prof. Today morning because of power
      problem, my system has restarted 8 times. When the power became stable
      and switch on my system, the oracle says 'Oracle initialization or
      shutdown in progress'. Then i tried by connecting....
      sqlplus /nolog
      connect sys/<pwd>@<sidas sysdba
      >
      and i said.. startup pfile=d:\....\i nit.ora
      The database instance started and mounted also.But after that it is
      showing this error...
      >
      ORACLE instance started.
      >
      Total System Global Area 302086172 bytes
      Fixed Size 75804 bytes
      Variable Size 107839488 bytes
      Database Buffers 194093056 bytes
      Redo Buffers 77824 bytes
      Database mounted.
      ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
      >
      Then i did...
      >
      SQLalter database open resetlogs;
      alter database open resetlogs
      *
      ERROR at line 1:
      ORA-01113: file 1 needs media recovery
      ORA-01110: data file 1: 'D:\ORACLE\ORAD ATA\...\SYSTEM0 1.DBF'
      >
      Can anybody please him me out, what i have to do?
      >
      **This is just a development db. So, i did not kept db in archive
      Mode.
      >
      Thanks in advance,
      Praveen
      Praveen, The meaning of the error message is very simple: your system
      tablespace datafile is not up to date and requires recovery. Since
      your system is in noarchive log mode you need to overlay all database
      data files with their backup copies and then open the database using
      reset logs. An alternate solution would be to rebuild your db from a
      full export file.

      HTH -- Mark D Powell --

        Comment

        • Praveen
          #3
          Re: How to do Media Recovery for System01.dbf??? ?

          Thanks for the response Mark,

          I have full export of my DB. if i do simple exp from the command
          prompt is it ok? as i dont have the backup of datafiles.

          praveen

          Mark.Powell@eds .com (Mark D Powell) wrote in message news:<2687bb95. 0310160635.4f35 3b3b@posting.go ogle.com>...
          spraveen2001@ya hoo.com (Praveen) wrote in message news:<98d8ec76. 0310152346.2e3e 01ab@posting.go ogle.com>...
          Hi All,

          I'm using Oracle 8.1.7 on Win2k Prof. Today morning because of power
          problem, my system has restarted 8 times. When the power became stable
          and switch on my system, the oracle says 'Oracle initialization or
          shutdown in progress'. Then i tried by connecting....
          sqlplus /nolog
          connect sys/<pwd>@<sidas sysdba

          and i said.. startup pfile=d:\....\i nit.ora
          The database instance started and mounted also.But after that it is
          showing this error...

          ORACLE instance started.

          Total System Global Area 302086172 bytes
          Fixed Size 75804 bytes
          Variable Size 107839488 bytes
          Database Buffers 194093056 bytes
          Redo Buffers 77824 bytes
          Database mounted.
          ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

          Then i did...

          SQLalter database open resetlogs;
          alter database open resetlogs
          *
          ERROR at line 1:
          ORA-01113: file 1 needs media recovery
          ORA-01110: data file 1: 'D:\ORACLE\ORAD ATA\...\SYSTEM0 1.DBF'

          Can anybody please him me out, what i have to do?

          **This is just a development db. So, i did not kept db in archive
          Mode.

          Thanks in advance,
          Praveen
          >
          Praveen, The meaning of the error message is very simple: your system
          tablespace datafile is not up to date and requires recovery. Since
          your system is in noarchive log mode you need to overlay all database
          data files with their backup copies and then open the database using
          reset logs. An alternate solution would be to rebuild your db from a
          full export file.
          >
          HTH -- Mark D Powell --

            Comment

            • Mark D Powell
              #4
              Re: How to do Media Recovery for System01.dbf??? ?

              spraveen2001@ya hoo.com (Praveen) wrote in message news:<98d8ec76. 0310162233.731d 11e5@posting.go ogle.com>...
              Thanks for the response Mark,
              >
              I have full export of my DB. if i do simple exp from the command
              prompt is it ok? as i dont have the backup of datafiles.
              >
              praveen
              >
              Mark.Powell@eds .com (Mark D Powell) wrote in message news:<2687bb95. 0310160635.4f35 3b3b@posting.go ogle.com>...
              spraveen2001@ya hoo.com (Praveen) wrote in message news:<98d8ec76. 0310152346.2e3e 01ab@posting.go ogle.com>...
              Hi All,
              >
              I'm using Oracle 8.1.7 on Win2k Prof. Today morning because of power
              problem, my system has restarted 8 times. When the power became stable
              and switch on my system, the oracle says 'Oracle initialization or
              shutdown in progress'. Then i tried by connecting....
              sqlplus /nolog
              connect sys/<pwd>@<sidas sysdba
              >
              and i said.. startup pfile=d:\....\i nit.ora
              The database instance started and mounted also.But after that it is
              showing this error...
              >
              ORACLE instance started.
              >
              Total System Global Area 302086172 bytes
              Fixed Size 75804 bytes
              Variable Size 107839488 bytes
              Database Buffers 194093056 bytes
              Redo Buffers 77824 bytes
              Database mounted.
              ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
              >
              Then i did...
              >
              SQLalter database open resetlogs;
              alter database open resetlogs
              *
              ERROR at line 1:
              ORA-01113: file 1 needs media recovery
              ORA-01110: data file 1: 'D:\ORACLE\ORAD ATA\...\SYSTEM0 1.DBF'
              >
              Can anybody please him me out, what i have to do?
              >
              **This is just a development db. So, i did not kept db in archive
              Mode.
              >
              Thanks in advance,
              Praveen
              Praveen, The meaning of the error message is very simple: your system
              tablespace datafile is not up to date and requires recovery. Since
              your system is in noarchive log mode you need to overlay all database
              data files with their backup copies and then open the database using
              reset logs. An alternate solution would be to rebuild your db from a
              full export file.

              HTH -- Mark D Powell --
              When I have recovered test databases using a full import I have always
              first written (or reran) a script to create the database. Once you
              create the system tablespace, run catalog and catproc, the imp file=x
              full=y destroy=y buffer=1048576 ought to do the job.

              Before doing anything please look at the Utilities manual chapter on
              IMP. You should also glance at the Backup and Recovery Guide chapter
              on general backup and recovery procedures. Reviewing the referenced
              material should allow you to proceed with some confidence that what
              you are doing will work.

              HTH -- Mark D Powell --

                Comment

                Previous template Next
                Working...