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: Effect of NOLOGGING tablespace on hot backup

Re: Effect of NOLOGGING tablespace on hot backup

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 06 Jun 2002 20:47:29 +0200
Message-ID: <0gbvfust155m9de2gu002ups7ve27mn9k9@4ax.com>


On 6 Jun 2002 11:24:50 -0700, jennifer.corliss_at_roche.com (Jenn) wrote:

>If I have a tablespace that is marked NOLOGGING and I do a hot backup,
>what do I get back when I recover?
>
>1. Nothing
>2. Objects as of the time of the backup with no ability to roll
>forward through the logs
>3. Everything
>4. something else?
>
>Thanks, Jenn

The impact of NOLOGGING has been discussed and explained many times here. Please note this group has archives and they are searchable via http://groups.google.com

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jun 06 2002 - 13:47:29 CDT

Original text of this message

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