نحوه بکاپ گیری دربانک اطلاعاتی اوراکل
Oracle Workshop II:
Oracle Database Administrator - Backup and Recovery
Performing User-Managed Backup and Recovery
( ) Recover from a lost TEMP file
( ) Recover from a lost redo log group
( ) Recover from a loss of password file
( ) Perform user- managed complete Database
recovery
( ) Perform user- managed incomplete Database
( ) Perform user- managed and server
Managed backups
( ) Identify the need of backup mode
( ) back up and recover a control file
Using RMAN to Perform Recovery
( ) Perform complete recovery from a
Critical or noncritical data file loss using RMAN
( ) Perform incomplete recovery using RMAN
( ) recover using incrementally updated backups
( ) switch to image copies for fast recovery
( ) Restore a database onto a new host
( ) Recover using a backups control file
( ) Perform Disaster recovery
Using RMAN to Duplicate a Database
( ) Creating a duplicate a database
( ) Using a duplicate a database
Performing Tablespace point-in-Time Recovery
( ) Identify the situations that require TSPITR
( ) Perform automated TSPITR
Monitoring and Tuning RMAN
( ) Monitoring RMAN sessions and jobs
( ) Tuning RMAN
( ) Configure RMAN for Asynchronous I/O
Using Flashback Technology
( ) Restore dropped tables from the recycle bin
( ) Perform Flashback Query
( ) Use Flashback Transaction
Additional Flashback Operations
( ) Perform Flashback Table Operations
( ) Configure,Monitor Flashback database and
Perform Flashback database Operations
( ) Set up and use a Flashback Data Archive
Diagnosing the Database
( ) Set up Automatic Diagnostic Repository
( ) Using Support Workbench
( )
Backup and Recovery Concepts
( ) Identify the types of failure that can occur in an Oracle database
( ) Describe ways to tune instance recovery
( ) Identify the importance of checkpoints redo log files and archived log files
( ) Overview of flash recovery area
( ) Configure ARCHIVELOG mode
Performing Database Backups
( ) Create consistent database Backups
( ) Back up your database without shutting it down
( ) Create incremental Backups
( ) Automate database Backups
( ) Manage Backups view Backup reports and monitor the flash recovery area
Performing Database recovery
( ) Overview of Data Recovery Advisor
( ) Use Data Recovery Advisor to Perform recovery( Control file Redo log file and Data file)
Moving Data
( ) Describe and use methods to move data(Directory objects SQL Loader External Tables)
( ) Explain the general architecture of Oracle Data Pump
( ) Use Data Pump Export and Import to move data between Oracle databases
Databases Architecture and ASM
( ) Describe Automatic Storage Management(ASM)
( ) Set up initialization parameter files for ASM and database instances
( ) Start up and shut down ASM instances
( ) Administer ASM disk groups
Configuring for Recoverability
( ) Configure multiple archive log file destinations to increase availability
( ) Define apply and use a retention policy
( ) Configure the Flash Recovery Area
( ) Use Flash Recovery Area
Using the RMAN Recovery Catalog
( ) Identify situations that require RMAN recovery Catalog
( ) Create and Configure a recovery Catalog
( ) Synchronize the recovery Catalog
( ) Create and Use RMAN stored scrupts
( ) Back up the recovery Catalog
( ) Create and use a virtual private Catalog
Configuring Backup Specifications
( ) Configure Backup settings
( ) Allocate channels to use in backing up
( ) Configure backup optimization
Using RMAN to Create Backups
( ) Create image file backups
( ) Create a whole database backup
( ) Enable fast incremental backup
( ) Create duplex backup and back up backup sets
( ) Create an archival backup for long-term retention
( ) Create a multisection,compressed and encrypted backup
( ) Report on and maintain backups