This course gives
the oracle database administrator (DBA) a firm
foundation in day-to-day database administrative
tasks. This course helps the database
administrator to configure a network environment
for a client-server system and develop network
configuration and recovery techniques for
databases.
| · |
Learn about backup and recovery procedures
using RMAN to resolve database |
| · |
Learn about oracle network architecture |
| · |
Learn about export and import utilities to
transport data between databases. |
| · |
Backup concepts |
| · |
Hot Backup / Online Backup |
| · |
Cold Backup / Offline Backup |
| · |
Data pump and Export Import |
| · |
RMAN Setups and Backup using RMAN |
| · |
Creating RMAN respository |
| · |
Taking different kinds of Backup using RMAN (Incremental level 0, level 1, cumulative |
| · |
Flash Back options of database |
| · |
Dataguard setup strategy |
· |
Recovery concepts |
| · |
Recovery of non-system datafile |
| · |
Recovery from loss of system datafile |
| · |
Recovery of UNDO tablespace |
| · |
Oracle
Recovery from TEMP files |
| · |
Recovery from loss of online redologs |
| · |
Recovery from loss of single controlfile |
| · |
Recovery noarchieve log database
|
| · |
Complete and Incomplete recovery (Both Manual and using RMAN will be covered) |
| · |
Recovery of whole database |
| · |
Recovery of database: Time Based |
| · |
Recovery of database: Change based
|
| · |
Recovery of database: Cancel based |
| · |
Recovery of read only tablespace |
| · |
Partial Recovery of daabase |
| · |
Recovery from Hot Backup |
| · |
Recovery from Cold Backup |
| · |
Recovery while database crushed during Hot Backup |
| · |
Handling No-logging operations (Both Manual and using RMAN) |