Re: Partial Database Recovery

From: Jim Robertson <jroberts_at_ees.enron.com>
Date: 1997/10/01
Message-ID: <01bcce74$7d3cdc40$471118ac@ees-971089>#1/1

You can manually do in Oracle 7 what Oracle does for you in Oracle8

You Recover the Database to a Test or Devel Server

You Recover the System Tablespace and any Tablespaces that have the data that was lost in them (Keep in mind any referential integrity issues)

Basicly once the files are restored to a second server you 1) Modify the init{sid}.ora file Comment out the rollback_segments parameter and

        replace it with the _corrupted_rollback_segments = ( )

2) Startup mount    the database
3) Offline ALL Datafiles that were not recovered
4) Open the database
5) Export the Table/Tables and Indexes that were dropped in the Production

instance

6) Move the .dmp file to your production server 
7) Truncate the Table/Tables in Production
8) Import the .dmp file into your production server

Note: One other step that you may need to do is once the Recovered database
 	is opened you may need to create a larger rollback segment than what
	your system rollback segment is  in order for the export to work properly.

Mark E. Porterfield <portrfld_at_nauticom.net> wrote in article <34229607.A993360E_at_nauticom.net>...
> masint_at_istar.ca wrote:
>
> > In article <342229de.11605833_at_news.centroin.com.br>,
> > lsantos_at_pobox.com,lsantos_at_bancointeratlantico.com.br wrote:
> > >
> > > Hello all!
> > >
> > > Is it possible to do a partial tablespace recovery? Let's
> > > suppose that one user accidently drop a table. The table are located
 

> > > in tablespace A. Then, I recover from last backup then datafile of
> > > tablespace A and recover it until one minute before the drop.
> > >
> > > I got the information that this is only possible with a FULL
> > > tablespace recovery, when I restore ALL datafiles... If I restore
 just
> > > one tablespace datafile I can just do FULL recovery.
> > >
> > > I think this is a bad implementation of recovery, and I really
 

> > > can't believe this limitation is true...
> > >
> > > Best Regards,
> > > --
> > > Luis Santos
> > > Banco InterAtlântico
> >
> > With release 8.0.3 and up, you can perform point-in-time tablespace
> > recovery from line-mode server manager NOT the Enterprise Manager. I
> > have
> > no details other that the technical PR I have seen. Ken Jacobs from
> > Oracle Corp. said the facility is technically complicated for Oracle
> > to
> > have implemented, but it should be looked at if and when required.
> >
> > Michael
> >
> > +-------------------------------------------------------
> > + Michael Abbey Author of 5 works in the Oracle Press Series
> > +-------------------------------------------------------
> >
> > -------------------==== Posted via Deja News
> > ====-----------------------
> > http://www.dejanews.com/ Search, Read, Post to Usenet
>
> Oracle cannot do this (at least previous to Oracle8). I believe that if
> you are utilizing partial backup and your archive log mode is true (You
> are using the archive redo logs) you could recover the database (not
> tablespace for relational integrity reasons) to a particular archive
> redo log. Of course, you have to know what is in that log and I can't
> help you there. What I do know is that point-in-time recovery is
> explicity usefull and CA-Ingres and CA-OpenIngres have been able to do
> this since Oh about 1987-88 or thereabouts. If Oracle 8 can do this it
> will be a nice feature. Of course you will likely have to take the hit
> on using archive logs.
>
>
>
  Received on Wed Oct 01 1997 - 00:00:00 CDT