Re: Recovery scenario

Well, I'm holding....and your assumption is unfortunately wrong :-(. I'm in the process of re-defining the backup and recovery needs, practices, etc. as I've only been here two weeks.
hahahaha.....poor finance guys.
Anyhoo, I'm going to change the archive log mode aspect of this database, and just do hot backups......I don't feel like finance data should be trusted to cold backups -- non - archived.

Thanks for the response tho -- I'll use this in the future -- great site BTW.

"Howard J. Rogers" wrote:

> Hold on to your hat, as this isn't easy.
>
> First clone your production database (I'm assuming that you are in
> archivelog mode, even if only doing cold backups. Forget everything else
> from this point on if not). Steps on cloning the database are on the Backup
> and Recovery page of my web site.
>
> Now blow away the datafiles of the clone, and restore from the cold backup
> taken X days ago.
>
> Try and start up, and the thing should say that your files need medai
> recovery. Recover database until cancel, and then cancel when appropriate
> (ie, apply just so many archives as are required to get the clone to the
> point your Finance Manager wants). Open with a resetlogs.
>
> Now you can export whatever tables etc you need.
>
> Take your new dump file back to your development type database, and import
> appropriate tables and data.
>
> It's basically a TSPITR (tablespace point in time recovery). You might want
> to search through the Oracle documentation on TSPITR before leaping in, but
> it's a fairly standard way of recovering from User errors that go unreported
> for days or weeks on end without having to roll your entire production
> system days or weeks.
>
> And when all that's done, you might want to ask your Finance Manager what
> the hell he wants to stuff you around like this for, and if he's going to be
> doing this very often, maybe a second server might be a good idea... he
> writes the cheques, after all. Have fun!
>
> Regards
> HJR
> --
>
> ---------------------------------------------------------------------------
> Opinions expressed are my own, and not those of Oracle Corporation
> Oracle DBA Resources: http://www.geocities.com/howardjr2000
> ---------------------------------------------------------------------------
>
> "ohno" <ohno_at_yahoo.com> wrote in message news:3A083CCF.9D4F49F9_at_yahoo.com...
> > Running Oracle 805 on Solaris 2.6.
> >
> > We have two instances on the same box -- one is a production instance,
> > the
> > other is a development type instance. They are both very similar in
> > scope, but there
> > are some minor differences (a couple of different tablespaces, etc.).
> > Finance Manager just came and wants the data from the production
> > instance
> > restored from a few days ago to the development instance -- however,
> > there isn't exports done, only cold backups (yeah, I know...but I just
> > got here two weeks ago).
> >
> > So, there really isn't a way to do what he wants done that I can see,
> > because restoring the cold backup from the production instance would
> > only restore to
> > the production instance, not development.
> >
> > YIKES!
> >
> > Suggestion?
> >
  Received on Tue Nov 07 2000 - 18:32:59 CST