1. Using Oracle Database Cloud Schema Service
  2. Develop Applications for Oracle Database Cloud Schema Service
  3. Application Archiving

Application Archiving

Modifications to your Oracle Application Express applications can be archived to tables in your database schema. Applications that belong to Oracle Database Cloud Schema Service with automatic archiving enabled are archived when they are created and when they are changed.

The Oracle APEX Application Archive packaged application manually archives applications to view, manage and restore application archives.

Note:

The archived application content is counted against your tablespace quota. By default, only 5 application versions are maintained. However, you can adjust this value from the Oracle APEX Application Archive packaged application. See View and Manage Application Archives.

Topics:

Schedule Daily Automatic Application Archiving

You can schedule daily automatic archiving for all applications that belong to your Oracle Database Cloud Schema Service. Automatic daily archiving is enabled and disabled from the Service Details page, under Administration. A Schema Service enabled with application archiving generates an archive for applications when they are created and when they are changed.

You can also manually archive from the Oracle APEX Application Archive packaged application. To learn more, see Manually Archiving Applications.

To view and manage archives, use the Oracle APEX Application Archive packaged application. To learn more, see Install the Oracle APEX Application Archive Packaged App and View and Manage Application Archives.

Attention:

If you are a legacy customer who purchased the Schema Service before August 2017, please see Schedule Daily Automatic Application Archiving for Legacy Customers.

To schedule automatic application archiving:

  1. Go to the Service Console for your Schema Service instance. See Access the Service Console.
    The Service Console page displays.
  2. Click the Manage tile.
    The service console manage options display.
    Description of manage_options.png follows
    Description of the illustration manage_options.png
  3. Click App Archiving.
    If application archiving is not yet enabled, the App Archiving dialog displays asking if you want to enable application archiving.
    Description of apparchiving.png follows
    Description of the illustration apparchiving.png
  4. Click Enable App Archiving.

    Note:

    The archived application content is counted against your tablespace quota. By default, only 5 application versions are maintained. However, you can adjust this value from the Oracle APEX Application Archive packaged app. See View and Manage Application Archives.

Schedule Daily Automatic Application Archiving for Legacy Customers

You can schedule daily automatic archiving for all Application Express applications that belong to your Oracle Database Cloud Schema Service. Automatic daily archiving is enabled and disabled from the Manage page in the service console. A Schema Service enabled with application archiving generates an archive for applications when they are created and when they are changed.

You can also manually archive from the Oracle APEX Application Archive packaged application. To learn more, see Manually Archiving Applications.

To view and manage archives, use the Oracle APEX Application Archive packaged application. To learn more, see Install the Oracle APEX Application Archive Packaged App and View and Manage Application Archives.

Attention:

This section is applicable only for the legacy customers who purchased the Schema Service before August 2017.

To schedule automatic application archiving:

  1. Navigate to the Service Details for your Schema Service. See Access Service Details.

    The Service Details page appears.

  2. Under Administration, click Application Archiving.

    The Application Archiving page displays.

  3. Click Enable Application Archiving.

    Note:

    The archived application content is counted against your tablespace quota. By default, only 5 application versions are maintained. However, you can adjust this value from the Oracle APEX Application Archive packaged app. See View and Manage Application Archives.

Manage and View Application Archives

The Oracle APEX Application Archive packaged app views and manages archives. Application archives are performed when theOracle Database Cloud Schema Service is enabled for automatic application archiving or when a manual archive is performed.

Topics:

To learn more, see Schedule Daily Automatic Application Archiving and Manually Archive Applications.

Install the Oracle APEX Application Archive Packaged App

Before you can use the Oracle APEX Application Archive packaged app, it must be installed.

To install the Application Archive packaged application:

  1. Access the Service Console for your Schema Service. See Access the Service Console.
    The Service Console appears.
  2. If the Service Console includes the Develop icon, click Develop. Otherwise, skip this step.

    Note:

    If you purchased the service prior to August 2017, the Service Console is the Oracle Application Express home page and will not include the Develop icon.
  3. Click Packaged Apps.

    The Packaged Apps home page appears.

    Description of packaged_apps_gallery.jpg follows
    Description of the illustration packaged_apps_gallery.jpg
  4. Locate and click the APEX Application Archive app.

    The application information page displays.

    Description of archive_app_info5.jpg follows
    Description of the illustration archive_app_info5.jpg
  5. Click Install Application.
  6. For Authentication, select one of the following and click Next:

    • Oracle Cloud Identity Management (default) - Users of this packaged application are managed through the Identity Console. See Adding Users and Assigning Roles in Getting Started with Oracle Cloud.

    • Application Express Accounts - Users of this packaged application are managed from the Application Express Administration. See Managing Users in a Workspace in Oracle Application Express Administration Guide.

  7. On the confirmation page, click Install Application.
  8. If you selected Application Express authentication, you need to add users from Oracle Application Express Administration before running the application. See Managing Users in a Workspace in Oracle Application Express Administration Guide.
  9. If you selected Oracle Cloud Identity Management, the users currently authorized to have access to your Oracle Database Service have access to this application. Use the Oracle Cloud portal to add users. See Adding Users and Assigning Roles in Getting Started with Oracle Cloud.
  10. To test the application, from the APEX Application Archive app information page, click Run icon Run icon.

Run the Oracle APEX Application Archive App

The Oracle APEX Application Archive packaged app views and manages application archives. Before you can run this application, it must be installed.

To run the Oracle APEX Application Archive packaged app:

  1. Access the Service Console for your Schema Service. See Access the Service Console.
    The Service Console appears.

    Note:

    If you purchased the service prior to August 2017, the Service Console is the Oracle Application Express home page and will not include the Develop icon.
  2. If the Service Console includes the Develop icon, click Develop. Otherwise skip this step.
  3. Click App Builder.

    The Application Builder home page displays.

  4. For APEX Application Archive, click the Run icon.

    Run icon

    The APEX Application Archive app home page appears.

    To learn how to use this application, see Install the Oracle APEX Application Archive Packaged App.

View and Manage Application Archives

The Oracle APEX Application Archive packaged app views and manages application archives. Before you can run this app, it must be installed.

To view and manage application archives:

  1. Run the Oracle APEX Application Archive app as described in Run the Oracle APEX Application Archive App.
  2. Click the Manage Archives button.

    The Archives page displays.

  3. To change the maximum number of archives, under Version Retention, click Adjust.

    The Adjust Preferences page appears.

  4. For Max Versions, enter the maximum number of archive versions to save, then click Apply Changes.
  5. To remove archives, under Administration on left panel, click Purge All Archives.

    The Purge page appears.

  6. For Purge Action, select the action to perform.
  7. Click Purge Archive(s).

Manually Archive Applications

You can manually archive applications from the APEX Application Archive packaged app.

For further instructions on how to use this application to create an on-demand archive and schedule archives, click the help Help icon icon at the top of the APEX application Archive home page.

To manually archive applications:

  1. Install the APEX Application Archive packaged app as described in Install the Oracle APEX Application Archive Packaged App.
  2. Run APEX Application Archive as described in Run the Oracle APEX Application Archive App.

    The APEX Application Archive home page appears.

  3. Click Archive Applications.

    The Create Application Archive wizard appears.

  4. Follow wizard on-screen instructions for each page to name the archive and select the applications to archive and click Create Archive.

    The Archives page displays.