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:

• "Mercadante, Thomas F" <thomas.mercadante_at_labor.state.ny.us> wrote:
  > Dennis,
  >
  > I don't see why Oracle even provides this type of
  > backup (database in
  > mount-only mode using Rman). To me, if I was
  > considering this, I would just
  > shut the database down and perform a cold backup.
  > Using Rman in this
  > situation is a waste of time (unless someone can
  > give me a good reason why
  > it is useful).
  >
  > Rman's biggest strength is point in time recovery,
  > and that the db is up and
  > available all the time.
  >
  > Anything else just seems like a waste to me - no
  > practicality to it.
  >
  > Tom Mercadante
  > Oracle Certified Professional
  

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