Read Pro Oracle Database 11g Administration for Free Online Page B

................................................................................................... 408
    Altering a Materialized View Refresh Group . ...................................................................................... 409
    Refreshing a Materialized View Group . ............................................................................................... 409
    DBMS_MVIEW vs. DBMS_REFRESH . ................................................................................................... 409
    Determining Materialized Views in a Group . ....................................................................................... 410
    Adding an MV to a Refresh Group . ...................................................................................................... 410
    Removing Materialized Views from a Refresh Group . ........................................................................ 411
    Dropping a Materialized View Refresh Group ..................................................................................... 411
    Summary . ................................................................................................................... 411
    ■Chapter 16: User-Managed Backup and Recovery ........................................... 413
    Implementing a Cold-Backup Strategy for a Noarchivelog-Mode Database .............. 414
    Making a Cold Backup of a Noarchivelog-Mode Database ................................................................. 414
    Restoring a Cold Backup in Noarchivelog Mode with Online-Redo Logs . .......................................... 416
    Restoring a Cold Backup in Noarchivelog Mode Without Online-Redo Logs . ..................................... 417
    Scripting a Cold Backup and Restore . ................................................................................................. 418
    Implementing Archivelog Mode .................................................................................. 420
    Making Architectural Decisions . ......................................................................................................... 421
    Setting the Archive-Redo File Location . .............................................................................................. 421
    Enabling Archivelog Mode .................................................................................................................... 426
    Disabling Archivelog Mode ................................................................................................................... 427
    Reacting to a Lack of Disk Space in Your Archive Log Destination . ................................................... 427
    Backing Up Archive-Redo Log Files . ................................................................................................... 428
    Making a Cold Backup of an Archivelog-Mode Database ................................................................... 428
    Implementing a Hot-Backup Strategy . ....................................................................... 430
    xx

    ■ CONTENTS
    Making a Hot Backup ......................................................................................................................... 430
    Scripting Hot Backups ........................................................................................................................ 434
    Understanding the Split-Block Issue .................................................................................................. 436
    Understanding the Need for Redo Generated During Backup ............................................................ 439
    Understanding that Datafiles Are Updated ......................................................................................... 440
    Performing a Complete Recovery of an Archivelog-Mode Database .......................... 441
    Restoring and Recovering with the Database Offline