Direct-Path INSERT with Logging - Oracle Tables

Q.  In which mode Oracle Database performs full redo logging for instance and media recovery. If the database is in ARCHIVELOG mode, then you can archive redo logs to tape. If the database is in NOARCHIVELOG mode, then you can recover instance crashes but not disk failures?
- Published on 12 Aug 15

a. Direct-path INSERT without Logging
b. Direct-Path INSERT with Logging
c. Both A & B
d. None of the above

ANSWER: Direct-Path INSERT with Logging

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 01 Sep 15
    - Direct-path INSERT lets you choose whether to log redo and undo information during the insert operation.

    - Direct-Path INSERT with Logging - In this mode, Oracle Database performs full redo logging for instance and media recovery.
    - If If the database is in ARCHIVELOG mode, then you can archive redo logs to tape.
    - If the database is in NOARCHIVELOG mode, then you can recover instance crashes but not disk failures.

    - Direct-Path INSERT without Logging - In this mode, Oracle Database inserts data without redo or undo logging.
    - (Some minimal logging is done to mark new extents invalid and data dictionary changes are always logged.)
    - This mode improves performance.
    - However, if you subsequently must perform media recovery, the extent invalidation records mark a range of blocks as logically corrupt, because no redo data was logged for them.
    - Therefore,it is important that you back up the data after such an insert operation.

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲