Unit of competency Outline
Date retreived
23/07/2026 10:38 PM AWST
23/07/2026 10:38 PM 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
ICTDBS402
ICTDBS402
State Code
AUT45
AUT45
TGA Status
Replaced
Replaced
DTWD Status
Replaced
Replaced
State Implementation and Classification
Approved Date
16/09/2015
Field of Education
020303 - Database Management
Original Release Date
16/09/2015
Nominal Hours
25
Description
This unit describes the skills and knowledge required to establish backup and recovery 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. Review the database architecture to plan backup and recovery
- 1.1 Examine the architecture of a database file system
- 1.2 Determine the most appropriate methods for backup and recovery
- 1.3 Identify and examine the likely or possible risk and failure scenarios
- 1.4 Prepare a backup maintenance schedule
- 1.5 Prepare a contingency plan
2. Determine backup methods appropriate to database requirements
- 2.1 Evaluate the range of backup and restoration methods, based on organisational and security standards, and on the assessment of likely, or possible, failure scenarios
- 2.2 Complete full off-line backups according to organisational and security standards, with minimal down time
- 2.3 Complete online file backups, as determined by organisational and security standards, with minimal down time
- 2.4 Employ disk mirroring and redundant array of inexpensive disks (RAID) hard disk configurations to keep copies of files
- 2.5 Arrange off-site copies of backup files
3. Establish recovery points and disaster-recovery procedures
- 3.1 Determine database recovery points based on the backup arrangements, according to organisational guidelines
- 3.2 Test the restore process to ensure that the database can be restored to a given recovery point, with minimal down time
- 3.3 Complete the restoration of the database to the point of failure, without loss of committed transactions
4. Create and deploy a standby database
- 4.1 Create or set up a standby database, in order to meet organisational guidelines
- 4.2 Implement a standby database to support critical business functions
- 4.3 Prepare the documentation for a standby database
No information
No information
Replaces
| State Code | National Code | Title | Type |
|---|---|---|---|
| D7768 | ICADBS402A | Complete database backup and restore | Unit of competency |
Replaced By
| State Code | National Code | Title | Type |
|---|---|---|---|
| OAQ03 | ICTDBS414 | Complete database backup and restore | Unit of competency |
| State Code | National Code | Title | Type |
|---|---|---|---|
| AVY7 | ICT40215 | Certificate IV in Information Technology Support | Qualification |