Re: ORACLE Backups

In article 777144673snz_at_keithl.demon.co.uk, Keith_at_keithl.demon.co.uk (Keith Leng) writes:
> In article <32b6pl$506_at_larch.cc.swarthmore.edu>
> stauffer_at_cc.swarthmore.edu "R Glenn Stauffer" writes:
>
> > bzy_at_ornl.gov writes:
> > >
> > >
> > > Once you do the "shutdown abort", you should bring the database back up again > > and do a regular shutdown. Then do your file backups.
> > >
> > > Beverly
> > >
> >
> > Why is this? ....
>
> Good question. I don't follow the logic of the above advice myself. What
> difference does it make if you do the startup on the database as it stands
> immediately before you do a backup or immediately after a restore? In either
> case you are running the startup against exactly the same files, so, surely,
> you will get exactly the same result.
>
> Keith

The reason I gave this advice can be found in the Oracle documentation. It may be in earlier versions, but the one I'm looking at now is "Oracle7 Server Administrator's Guide", page 18-7.

"A full backup cannot be taken if the database is open or has been shut down because of an instance failure or abort; in such cases, a backup is not a full backup because the files are not consistent with respect to the current point- -time."

Beverly  

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 
+                                    +                             +
+  Beverly Cather Zygmunt            +  Phone: (615) 574-1007      +
+  Oak Ridge National Laboratory     +  email: zygmuntbc_at_ornl.gov  +
+  Building 4500N, MS 6274           +         bzy_at_ornl.gov        +
+  Oak Ridge, TN 37831-6274          +                             +
+                                    +                             +
+                                    +                             +
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+                                                                  +
+  "If you torture your data long enough, they will tell you what  +
+  you want to hear." -- James L. Mills                            +
+                                                                  +
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++