Use DBCA to Create an Image of the Single-Instance Database

Use DBCA to create a preconfigured image of your single-instance database by using the following procedure:

  1. Navigate to the bin directory in $ORACLE_HOME, and start DBCA.

  2. At the Welcome page, click Next.

  3. On the Operations page, select Manage Templates, and click Next.

  4. On the Template Management page, select Create a database template and From an existing database (structure as well as data), then click Next.

  5. On the Source Database page, select the database name in the Database instance list, and click Next.

  6. On the Template Properties page, enter a name for your template in the Name field. Oracle recommends that you use the database name.

    By default, the template files are generated in the directory $ORACLE_HOME/assistants/dbca/templates. You can enter a description of the file in the Description field, and change the template file ___location in the Template data file field.

    When you have completed the entries, click Next.

  7. On the Location of Database Related Files page, select Maintain the file locations, so that you can restore the database to the current directory structure, and click Finish.

DBCA generates two files: a database structure file (template_name.dbc), and a database preconfigured image file (template_name.dfb).