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 -> Database backup when in readonly mode

Database backup when in readonly mode

From: David Yeung <dyeung_at_ust.hk>
Date: Sun, 05 Oct 2003 09:47:40 +0800
Message-ID: <blnsr7$ii9$1@news.ust.hk> 





I want to do a full backup while there is no
update activities but I want users to be able
to read data from the db. Can I switch the database
to 'read-only' mode:



    alter database open read only;



and then do a full backup (by backing up all the
data files).



Is this a proper backup approach.



My database is not running on archive mode and I
am running Oracle 8i (8.1.7).



Thanks for any advice.



David Yeung
Received on Sat Oct 04 2003 - 20:47:40 CDT












Original text of this message













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