ITI586 Database Administration Fundamentals 2 (8)

This subject covers configuring an Oracle database for multilingual applications and recovering the database by using various methods such as RMAN, SQL, and Flashback technology. Tools to monitor database performance and what steps to take to improve database performance are also introduced in this subject. Using various database technologies such as Resource Manager, the Scheduler, and Automatic Storage Management (ASM) are covered.

Subject Outlines
Current CSU students can view Subject Outlines for recent sessions. Please note that Subject Outlines and assessment tasks are updated each session.

No offerings have been identified for this subject in 2018.

Where differences exist between the Handbook and the SAL, the SAL should be taken as containing the correct subject offering details.

Subject Information

Grading System



One session


School of Computing and Mathematics

Enrolment Restrictions

Only for students enrolled in the following courses:
Master of Database Design and Management
Master of Networking and System Administration
Master of Systems Development
Master of Information Systems Security
Master of Management (IT) - MMgtInfoTech
Graduate Certificate in Management (IT) - GradCertMgtInfoTech



Learning Outcomes

Upon successful completion of this subject, students should:

- be able to use RMAN to create and manage backup sets and image copies;
- be able to recover the database to a previous point in time;
- be able to use Oracle's Flashback technology to recover a database;
- be able to detect block corruptions and take appropriate measures to correct them;
- be able to use the various Database advisors and views to monitor and improve database performance;
- be able to control database resource usage with the Resource Manager;
- be able to simplify management tasks by using the Scheduler;
- be able to improve the security of the listener;
- be able to review database log files for diagnostic purposes;
- be able to customize language-dependent behaviour for the database and individual sessions;


This subject will cover the following topics:

Using Globalization Support;
Securing the Oracle Listener;
Configuring Recovery Manager;
Using Recovery Manager;
Diagnostic Sources;
Recovering from non-critical losses;
Database Recovery;
Flashback database;
Recovering from User Errors;
Dealing with Database Corruption;
Automatic Database Management;
Monitoring and Managing Storage;
Automatic Storage Management;
Monitoring and Managing Memory;
Managing Resources;
Automating Tasks with the Scheduler.


Current Students

For any enquiries about subject selection or course structure please contact Student Central or or phone on 1800 275 278.

Prospective Students

For further information about Charles Sturt University, or this course offering, please contact info.csu on 1800 275 278 (free call within Australia) or enquire online.

The information contained in the 2018 CSU Handbook was accurate at the date of publication: August 2018. The University reserves the right to vary the information at any time without notice.