Backup Database SmartGuide -- Fields and controls

Database page
Availability
Protection
Rate of Change
Recommendation
Database Image
" " Back
" " Next
" " Done
" " Show Command
" " Cancel



Database page

" " Database

" " Database

This field confirms the database you want to backup. To choose a different database, click on Cancel and invoke the Backup Database SmartGuide from the pop-up menu of another Database object.



Availability page

" " 5 days a week, 8 hours a day
" " 5 days a week, 24 hours a day
" " 7 days a week, 24 hours a day

" " 5 days a week, 8 hours a day

Click on this radio button if your database is not available exactly eight hours a day, but you can stop it for service at least once a day.

" " 5 days a week, 24 hours a day

Click on this radio button if your database can only be stopped once a week.

" " 7 days a week, 24 hours a day

Click on this radio button if your database is never stopped for service.



Protection page

" " Fast recovery (Circular Logging)
" " Complete recovery (Archive Logging)

" " Fast recovery (Circular Logging)

Click on this radio button to record the changes to your database in a set of logs. When the last log file in a series is filled, the first log file is reused in a circular fashion. Circular logging supports restore--only recovery. (LOG RETAIN = OFF)

" " Complete recovery (Archive Logging)

Click on this radio button to continuously create additional logs to record every transaction since your last backup. Archive logging does not overwrite older log files. This type of logging supports roll-forward recovery. (LOG RETAIN = ON)



Rate of Change page

" " Slider
" " Recommended backup frequency

" " Slider

Use the slider to show the amount of data in the database that changes each day.

" " Recommended backup frequency

This field shows the time between backups. Scheduling a backup is a trade off between the time it takes to backup the database and the amount of data you can recover (circular logging) or the backup time and the time required to recover all the data (archive logging) after a failure.



Recommendation page

" " Type of Logging (Protection Page)
" " Type of backup
" " Schedule (Availability Page)
" " Schedule (Rate of Change Page)

" " Type of backup

Select the type of backup:

Online
The database can be backed up while users or applications are connected. Database performance can be decreased. The backup may take longer.

Offline
No users or applications can be connected to the database. The backup may be faster.

You can do a backup while the database is either online or offline. If it is online, other applications or processes can continue to connect to the database as well as read and modify data while the backup task is running. If the backup is performed offline, only the backup task can be connected to the database. The implication of offline backup is that the rest of your organization cannot connect to the database while the backup task is running. However, online backups are supported only if roll-forward recovery is enabled.



Database Image page

" " Target location
" " Add
" " Change
" " Remove

" " Target location

Use this field to type the name of a folder for your database image.

" " Add

Click on this push button to add a folder to the list.

" " Change

Click on this push button to change a folder in the list.

" " Remove

Click on this push button to remove a folder from the list.