Re: backup question

In article <3A7548E9.7D69FEE3_at_crpa.it>,
  Cristian Veronesi <c.veronesi_at_crpa.it> wrote:
> Every night I run a task that exports my oracle database on a DMP file
> first and then saves every single file stored on the the server (SCO
> Openserver 5.0.4 + Oracle RDBMS 7.3.4) on a tape.
> I am wondering whether, after a system crash, restoring all the Oracle
> files (data files, control files, etc.) would be enough for having
> Oracle up and running again or have I to reinstall Oracle and then
> import all the DMP files?
> If I'd shut down the database before to save the files something would
> change?
>
> Sorry for my ingenuousness :)
> Best regards, Cristian
>
> -- =
>
> Cristian Veronesi ><((((=BA> http://www.crpa.it
>
> If Bill Gates had a dime for every time a Windows box crashed...
> Oh, wait a minute... he _already_ does! ;)
>

You simply MUST shutdown the databse for this action, or you have to enable archivelog (assuming you run in noarchivelog) and use the hotbackup scenario.
Your current backup is inconsistent and you can be sure you will be forced to recreate the database from an export when you need to recover from a crash.

Regards,

--
Sybrand Bakker, Oracle DBA

All standard disclaimers apply
------------------------------------------------------------------------


Sent via Deja.com
http://www.deja.com/