Unit of competency Outline

Date retreived
22/07/2026 9:05 AM AWST

Whilst all efforts are made to provide accurate and timely information from the relevant source/documentation, please be aware that the information supplied may not be the most current version. The accuracy of the detail has not been confirmed by the Department and therefore should not be relied upon without first confirming the contents.

Complete database backup and restore

Complete database backup and restore

Unit of competency
National Code
ICTDBS414
State Code
OAQ03
TGA Status
Current
DTWD Status
Approved
Current Release Number
1.00
Current Release Date
30/01/2019
View on TGA
State Implementation and Classification
Approved Date
22/05/2019
Field of Education
020303 - Database Management
Original Release Date
22/05/2019
Nominal Hours
25
Description
This unit describes the skills and knowledge required to establish database backup and restore procedures in accordance with organisational requirements, and consistent with the database architecture.It applies to individuals who are technical support personnel, such as help desk supervisors, information and communications technology (ICT) support technicians, database support technicians and user-support specialists.No licensing, legislative or certification requirements apply to this unit at the time of publication.
Notes
Elements and Performance Criteria
1. Plan database backup and restore
  • 1.1 Examine architecture of database file systems and determine likely risk and failure scenarios
  • 1.2 Determine methods for database backup and restore to mitigate likely risk and failure scenarios
  • 1.3 Prepare backup maintenance schedules according to organisational backup and restore policy
  • 1.4 Prepare contingency plans according to organisational backup and restore policy
2. Undertake backup methods appropriate to database requirements
  • 2.1 Complete full off-line backups with acceptable downtime according to organisational backup and restore policy and procedure
  • 2.2 Complete online file backups with acceptable downtime according to organisational backup and restore policy and procedure and organisational data security plan
  • 2.3 Deploy redundant array of inexpensive disks (RAID) configuration aligned with the organisational backup and restore policy
  • 2.4 Arrange off-site copies of backup files consistent with organisational back and restore procedure and organisational data protection plan
3. Establish and test recovery points and disaster-recovery procedures
  • 3.1 Determine and document database recovery points based on backup methods, according to organisational backup and restore policy and procedure
  • 3.2 Test restore process to ensure database can be restored to given recovery points with acceptable down time as specified in organisational backup and restore policy
  • 3.3 Complete and document restoration of databases to point of failure, without loss of committed transactions
4. Create and deploy a standby database
  • 4.1 Create and deploy standby databases to support critical organisational functions according to organisational back and restore policy and procedure
  • 4.2 Prepare documentation for standby databases that meet requirements of organisational backup and restore policy
No information
No information
Replaces
State Code National Code Title Type
AUT45 ICTDBS402 Complete database backup and restore Unit of competency