Re: backup & recovery

It is possible, if any "nologging" operations were performed. The Oracle 8 concepts manual says the following:

In NOLOGGING mode, data is modified with minimal logging (to mark new extents invalid and to record dictionary changes). When applied during media recovery, the extent invalidation records mark a range of blocks as logically corrupt, because the redo data is not logged. Therefore, if you cannot afford to lose this index, you must take a backup after the operation in NOLOGGING mode.

If you do any of the following, it is possible to "lose" data during recovery, if the object is set to NOLOGGING:

Only the following operations can make use of no-logging mode:

direct load (SQL*Loader)
direct-load INSERT
CREATE TABLE ... AS SELECT
CREATE INDEX

ALTER TABLE ... MOVE PARTITION
ALTER TABLE ... SPLIT PARTITION
ALTER INDEX ... SPLIT PARTITION
ALTER INDEX ... REBUILD
ALTER INDEX ... REBUILD PARTITION

--
---------------------------------------------------
Alan Moorman
Oracle DBA (7.3.x, 8.0.x, 8.1) (Solaris Intel & SPARC, RH Liinux, NT 4.0)
Oracle ERP DBA (10.7 SC & NCA, 11.0.3) (SPARC DB servers; Solaris Intel apps
servers)
Unisys DMS 2200 DBA (yes, "antiquated" mainframe stuff that still kicks
butt!)
MS SQL Server 7.0 DBA
---------------------------------------------------


zameer2_at_my-deja.com wrote in message <8h8s1i$i1$1_at_nnrp1.deja.com>...


>Hi,

>

>In archive log mode is there any chance that you might loss committed

>data ?

>

>Thanks for your feedback.

>

>Zameer

>

>

>

>Sent via Deja.com http://www.deja.com/

>Before you buy.