Re: Db stat change query

2001-03-28 Thread Winnie_Liu


Yes, it is necessary to take a full backup when you change your database
from noarchivelog mode to archivelog mode. Or else you will never have a
"base" to perform recovery if it is needed.

Winnie





"Seema Singh" [EMAIL PROTECTED]@fatcity.com on 03/28/2001 01:25:26
PM

Please respond to [EMAIL PROTECTED]

Sent by:  [EMAIL PROTECTED]


To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:



Hi gurus
Is it necessary to take full backup when we change the database from
archivelog mode to noarchivelog mode and vice versa.
Thanks
-seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seema Singh
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



RE: Db stat change query

2001-03-28 Thread Armstead, Michael A

Yes. Unless you can risk having a time where you can't recover your
database.

Michael Armstead
Database Administrator, OCP-Certified
Corporate  Finance Information Systems
Glaxo SmithKline


 -Original Message-
 From: Seema Singh [SMTP:[EMAIL PROTECTED]]
 Sent: Wednesday, March 28, 2001 3:25 PM
 To:   Multiple recipients of list ORACLE-L
 Subject:  Db stat change query
 
 Hi gurus
 Is it necessary to take full backup when we change the database from 
 archivelog mode to noarchivelog mode and vice versa.
 Thanks
 -seema
 _
 Get your FREE download of MSN Explorer at http://explorer.msn.com
 
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.com
 -- 
 Author: Seema Singh
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
 San Diego, California-- Public Internet access / Mailing Lists
 
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Armstead, Michael A
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).