Re: Full backup after shutdown immediate

Roy Brokvam wrote in message ...
>The Oracle7 Server Administrator's Guide (which I got with my 7.1.3
>distibution) says that I cannot rely on a full backup if the database has
>not been shut down with normal priority. In particular, it says I cannot use
>shutdown immediate.
>The 7.3.4 Online Generic Documentation CD-ROM says: To perform a Full
>Backup, first shut down the database with normal or immediate priority...
>Has this changed somewhere between 7.1.3 and 7.3.4? Is the 7.3.4 text
>correct?

I'm also a bit confused. 7.3 documentation is not very consistent with that clue. Also it contains several other annoying errors. In theory, shutdown immediate should checkpoint all datafiles so they are not left in "fuzzy" state.
On the other hand, I would prefer not to verify it is really sufficient for backup purposes on production databases. So before cold backup I shutdown db with immediate priority, stop SQL*Net listeners (if another instances don't need them), startup in restricted mode and shutdown normal just after and start SQL*Net.

HTH,
--
Piotr Kolodziej pkol_at_otago.gda.pl
Just my private opinion. Received on Tue Apr 06 1999 - 10:26:28 CDT