| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Why hot backups?
> > A consultant set up the Oracle Financials database I am managing.
> > Tonight I did my first restore in production and, having never done a
> > restore from a hot backup I called Oracle. They recommended that I
> > restore from my last cold and rolled forward even though I take hot
> > backups every night.
> >
> > Then why the heck am I waisting those expensive tapes on hot backups I
> > am not going to use?
You could have restored from your hot backups. I'm not sure why Support told you to go back to the cold backup. Some database that run 24x7 don't have a recent cold backup to revert to. Like I said, you could have restored from your hot backups.
> Personally, I'm a huge fan of the export utility. I've had systems mulch
> my dbf files (which werent
> caught by the OS backup utilities since the files are always open).
> A quick drop and creation of the affected
> tablespaces followed by an import has saved the day (and the uptime)
While I'm not going to say that exports don't have their place (they do!), I will add that recovering from an export does not let you apply any changes since the last export. Recovering from an export is an incomplete recovery to a point in time whereas recovering from a backup and rolling forward with archived redo logs allows complete recovery to the database crash.
HTH,
Brian
 |
 |