Once the storage option is selected, click Next. The Recovery Configuration screen is displayed.
This screen is used to set up the database backup and recovery strategy.
Options available: Flash Recovery options—new in Oracle 10g, and Archive log options.
Flash Recovery options:
Flash Recovery is a new feature in Oracle 10g. Specify the directory location for Flash Recovery area and its size.
Click File Location Variables on the Recovery Configuration screen to display a summary of Oracle file location parameters.
The size of the Flash Recovery area defaults to 2048 MB and can be changed using the Flash Recovery Size setting.
Directory location and the size of the disk area are to be specified for this Flash Recovery Area.
The default location of the directory is ORACLE_BASE\flash_ recovery_area.
On Unix environment, this directory is /u01/ app/oracle/oradata/ORCL/flash_recovery_area.
The size defaults to 2048 MB and can be changed later.
Enabling Archive Logging: Archive logging is the mechanism Oracle uses to enable you to perform point-of-failure recovery of a database.
To enable this, mark the Enable Archiving check box. Once you do so, the button Edit Archive Mode Parameters will be enabled. If you click this button, you are presented with a screen that enables you to set the various parameters that are used to configure archive logging.
After completing the Recovery configuration, Database Content screen is displayed.
This screen is displayed if create custom database option was chosen in the Database Templates screen.
Chose which Oracle database components are to be installed.
These components are described in the right side table.
To select Sample Schemas, click the Sample Schemas tab in the DBCA Database Content screen, mark the Sample Schemas check box, and click Next.
If you choose to create the sample schemas, Oracle creates a tablespace called EXAMPLES and stores all the necessary tables within that tablespace. (Addition of about 130MB to the database definition).
You can also run custom scripts as part of the database creation process. click the Custom Scripts tab in the Database Content screen to enter the names and locations of the custom scripts that you want to run at database creation.
The custom scripts are run using the command-line utility SQL*Plus.
|Oracle Text||Provides support for multimedia content such as audio and video.|
|Oracle OLAP||Provides facilities for creating and deploying online analytical processing applications|
|Oracle Spatial||Provides the components and infrastructure for Oracle to manage and maintain geographic and spatial information such as map coordinates.|
|Oracle Data Mining||Adds a set of analytical tools and extended algorithms to the database to facilitate data mining.|
|Provides capabilities to perform extended text and searches within the Oracle database.|
|Oracle Label Security||Manages and controls access to sensitive information within the database.|
|Sample Schemas||Provides working examples of how to configure and use certain extended features of the Oracle database.|
|Enterprise Manager Repository|| Specifies the location of the schema used to manage the
content of the OEM repository. If you chose to do local
management of your database, this schema is required.
Click the Standard Database Components button to display any
additional standard features that Oracle will automatically
configure for you and recommend as part of a standard
These features are the Oracle JVM, Oracle Intermedia and Oracle XML DB.
The DBCA also lets to install examples of actual working databases. Oracle provides a set of example schemas and applications that use these schemas. These sample schemas now or later by running a series of SQL scripts.