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

spraveen2001_at_yahoo.com (Praveen) wrote in message news:<98d8ec76.0310162233.731d11e5_at_posting.google.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_at_eds.com (Mark D Powell) wrote in message news:<2687bb95.0310160635.4f353b3b_at_posting.google.com>...
> > spraveen2001_at_yahoo.com (Praveen) wrote in message news:<98d8ec76.0310152346.2e3e01ab@posting.google.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>_at_<sid> as sysdba
> > >
> > > and i said.. startup pfile=d:\....\init.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...
> > >
> > > 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: 'D:\ORACLE\ORADATA\...\SYSTEM01.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 -- Received on Fri Oct 17 2003 - 15:22:26 CEST