| 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: Super easy ? for you gurus
The control file and the headers of the datafiles have to be in sync.
while doing a cold backup.
If you are in archivelog mode u can do a hot backup in which case
u do not need to shutdown since datafile is put in a backup mode
and syncing maintained.
Hope this helps.By the way I am not still a guru just an eager learner.
JP Soria <jpsoria_at_saxe.com> wrote in article <33734135.6BF8_at_saxe.com>...
> Our database is actually a datawarehouse 300+ gig. We are not running
> in archivelog mode.
> My question: Why does the database need to be shutdown in order to
> perform a backup? Isn't it a read only process as far as the DB is
> concerned?
> Most of the data is historic and therefore static. Users are not able
> to add, insert or delete.
> Any answer is greatly appreciated.
> --
> JP Soria
> Jr. Oracle7 DBA
> Email: jpsoria_at_saxe.com
> "Failing to plan = planning to fail"
>
Received on Mon May 26 1997 - 00:00:00 CDT
 |
 |