Re: recovery aproach ...

gallasr_at_post.sk wrote:
> Hello,
>
> Sorry about starting new thread but this question is about another
> aproach.
>
> - we have the latest datafiles about 1 hour long
> - only problematic tablespace/datafile is, let`s say system01.dbf
>
> Question is:
> Is there any possibility to create new database and then replacing good
> datafiles and then do some "magic"?
>
> Is there any kind of "magic" step?
>
> Sorry, I know it looks crazy but trying everythink.
>
> Thanks for answers
> Robert
>

The "magic" you are referring to is a solid backup and recovery plan, implemented for your database long before you encounter a problem. Each application has its own set of backup and recovery needs and your backup and recovery strategy should take these requirements into account. Once the backup and recovery strategy is designed to meet these requirements, it should be thoroughly tested. And by "it" I mean both backup *and* recovery.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown