|
|
|
 |
O8BARWOracle8: Practical work on backup and restoring of databases
The course is devoted to planning and implementation of the strategy of a backup and restoring of databases. Various methods of a backup and restoring are considered. Some scripts of restoring after various refusals are researched. One day is completely devoted by practical occupations during which students define reasons of damages of a "alive" database and practically her restore. Practical occupations are oriented to databases of a level of large firms and organizations. Upon termination of course students should be able to name key questions for development of the strategy of a backup and restoring of a database, to enumerate components of the architecture of server Oracle, concerning to backup and restoring, to name components of Recovery Manager architecture, to use various methods of a backup of a database with the help of toolkit of the database administrator (physical copying with help Recovery Manager or logical copying with the help of utility Export) to fulfil complete and partial restoring a database to configurate the backup database for minimizing down time of a database.
Circle of students:
Managers of databases
Experts on technical support
System administrators
Developers of
Necessary preliminary preparation:
Introduction in Oracle: SQL and PL/SQL
Oracle8: Administration of databases
the Program of course:
-
- Structures of the RAM and the processes of server Oracle participating in restoring of a database
- the Configuration of a backup and restoring
- Oracle Recovery Manager Architecture
- the Physical backup without usage Oracle Recovery Manager
- the Physical backup with help Oracle Recovery Manager
- Refusals of databases Oracle and troubleshooting
- Restoring of databases Oracle with the switched off archiving mode
- Restoring of databases Oracle with the included mode архивирования
- Utilities Export and Import
- Other questions of restoring of databases Oracle
- the Backup database and conditions of its usage
- Scripts of restoring databases (practical work)
- Support of the directory of restoring Oracle
For familiarity are recommended the Strategy of a backup and restoring courses:
Introduction in Oracle8: SQL and PL/SQL
Oracle8: Administration of databases
Oracle8: Development of program units on PL/SQL
For the further training courses are recommended:
Oracle8: Administration in network environment
Oracle8: Seminar on customization of productivity.
Education coast on cource - USD 750
Cource duration (days) - 3
|
|
