- shut down production ;o) heh heh
- backup production data files then back them up again
- blow away production data files
- restore from last (or desired ) production backup
- bring db up and do full export
- take db down, blow away files, restore from backup in 2
- refresh dev/test using the export
- convince management that you need a separate box for the dev/test stuff
HTH ;o)
--
Jim Gregory
Principal Consultant for Keane, Inc.
Currently assigned to NCR
"Opinions are my own and do not reflect
those of Keane or my clients"
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 - 14:22:51 CST
