Use this tab to define the contents of a new subclient or to change the contents of an existing subclient. When you back up the subclient, database objects included in the subclient content are backed up.
Selective Online Full
Specifies whether selective online full backups will be performed for this subclient.
Specifies whether data files will be backed up for this subclient, and provides you with a choice of backup modes - Online Database, Online Subset or Offline Database.
- Backup Mode
A choice of modes is provided to specify the manner in which data file backups for this subclient will be conducted.
Specifies the backup of the online database.
Specifies the backup of a subset of database objects. Use the tree displayed in the Current Database View to add new or modify these subsets. The database must be online and in ARCHIVELOG mode when the backup is invoked.
Specifies the backup of the offline database. The database must be in the MOUNT mode when the backup is invoked.
- Current Database View
Displays the subsets (tablespaces and datafiles) that are available in the database associated with this subclient.
Click to refresh the content of the database.
Backup Control File
Specifies whether the control files will be backed up.
Protect backup recovery area
Specifies whether to back up the Flash Recovery Area for Oracle 10g or higher versions.
Back up SP File
Specifies whether the Server Parameter File (SP File) will be backed up.
This box indicates all the tables that are part of the archive. Clicking on the "+" button next to the table expands the view to see the dependent tables. The Arrow buttons indicate the table hierarchy. Right-clicking on a selected table offers the following options.
- Specify Archive Criteria - Specify SQL queries used for archiving the selected table.
- Specify Index Columns - Specify the columns that will be indexed for the selected table.
- Add a Virtual Key - Add a virtual foreign key relationship so that the two tables can be cross-referenced.
- Preview Data - The table rows that will be archived are displayed.
Add Target Table
Click this button to start the Archiving Configuration Wizard to add one or more tables to the archive.
Add Dependent Table
Click this button after selecting a table to start the Archiving Configuration Wizard to add one or more tables associated with the selected table to the archive.
Click this button after selecting a table to remove it from the archive.