Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Why is on-line backup one tablespace a time?

Re: Why is on-line backup one tablespace a time?

From: Andy <enzoweb_at_hotmail.com>
Date: 26 Aug 2001 15:20:22 -0700
Message-ID: <8d4033cd.0108261420.4a8a122d@posting.google.com> 





As Sean said, this is not a requirement but is certainly the
recommended way as not only does it reduce redo but can also help in
the event of problems - if all the tablespaces are placed in BEGIN
BACKUP mode and the backup fails, you may be left with several
tablespaces in BACKUP mode which will cause problems when the database
is restarted.



It's more efficient and "best practice" to do them one at a time,
IMHO.


Andy
Received on Sun Aug 26 2001 - 17:20:22 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US