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

Home -> Community -> Mailing Lists -> Oracle-L -> RE:

RE:

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Fri, 4 Jun 2004 14:44:01 -0400
Message-ID: <DE8A21F8F1D0254EA4A9214D52AB2FEDAD5BFB@exchsen0a1ma>


Paul,

>1. block checking (inline). don't need to run dbv.

OK. This makes sense. Although the risk is probably small - how many times have we
experienced corrupted blocks?

>2. doesn't backup blocks that have not been written to.

Grudgingly ok. I would keep the free space small for any database that I am not running in archivelog mode. I would *never* run a prod db in noarchivelog mode.

>3. operation is in the controlfile (or rman catalog).

I guess.

>4. not platform-specific.

*Everything* is platform specific.

I guess is comes down to personal preference. I don't think I'd put myself in the position to allow this to happen. I'd argue like hell against it!

Have a good weekend!

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
From: Paul Drake [mailto:discgolfdba_at_yahoo.com] Sent: Friday, June 04, 2004 2:31 PM
To: oracle-l_at_freelists.org
Subject: RE:

Tom,

  1. block checking (inline). don't need to run dbv.
  2. doesn't backup blocks that have not been written to.
  3. operation is in the controlfile (or rman catalog).
  4. not platform-specific.

we've got some development dbs that are running in noarchivelog for the time being, so full rman backups while mounted is the way to go for them for now.

Pd                          



Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Fri Jun 04 2004 - 14:58:21 CDT

Original text of this message

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