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 Service (Database Schema) 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 Viewing and Managing Application Archives.

Topics:

Scheduling Daily Automatic Application Archiving

You can schedule daily automatic archiving for all applications that belong to your Oracle Database Cloud Service (Database Schema). Automatic daily archiving is enabled and disabled from the Service Details page, under Administration. Oracle Database Cloud Services (Schema) enabled with application archiving generate 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 Installing the APEX Application Archive Packaged Application and Viewing and Managing Application Archives.

To schedule automatic application archiving:

  1. From the Oracle Cloud home page, click Sign In.

    The Sign In page appears.

  2. In the My Services box, select the data center and click Sign In to My Services.
  3. If not already signed in, the Sign in dialog displays. Enter Oracle Database Cloud Service (Schema) credentials and click Sign In.

    My Services appears.

  4. Click Platform Services.
  5. Click the name of the Oracle Database Cloud Service (Schema).

    The Service Detail page displays.

  6. Under Administration, click Application Archiving.

    The Application Archiving page displays.

  7. Click Application Archiving Update.

    The Application Archiving information displays.

  8. Select 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 application. See Viewing and Managing Application Archives.

Managing and Viewing Application Archives

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

Topics:

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

Installing the Oracle APEX Application Archive Packaged Application

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

To install the Application Archive packaged application:

  1. Access Oracle Database Cloud Service (Schema). See Accessing Oracle Database Cloud Service (Database Schema).

    The Oracle Application Express home page displays.

  2. Click the Application Builder.

    The Application Builder home page displays.

  3. Click the Packaged Applications tab.

    The Packaged Applications page displays showing all available packaged applications and sample code.

  4. Locate and click the APEX Application Archive application.

    The application information page displays.

  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 Managing Users and Roles in Getting Started with Oracle Cloud.

    • Application Express Accounts - Users of this packaged application are managed from the Application Express Administration. See Managing Application Express Users 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 Application Express Users 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 Managing Users and Roles in Getting Started with Oracle Cloud.
  10. To test the application, click Run Application.

Running the Oracle APEX Application Archive Application

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

To run the Oracle APEX Application Archive packaged application:

  1. Access Oracle Database Cloud Service (Schema). See Accessing Oracle Database Cloud Service (Database Schema).

    The Oracle Application Express home page displays.

  2. Click Application Builder.

    The Application Builder home page displays.

  3. For APEX Application Archive, click Run.

    The APEX Application Archive application home page appears.

    To learn more, see Installing the APEX Application Archive Packaged Application.

Viewing and Managing Application Archives

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

To view and manage application archives:

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

    The Archives page displays.

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

    The Preferences dialog appears.

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

    The Purge dialog appears.

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

Manually Archiving Applications

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

To manually archive applications:

  1. Install the Oracle APEX Application Archive packaged application as described in Installing the APEX Application Archive Packaged Application.
  2. Run the Oracle APEX Application Archive application as described in Running the APEX Application Archive Application.

    The Oracle APEX Application Archive home page appears.

  3. Click Archive Applications.
  4. Follow on-screen instructions.
  5. Click the Archive tab.

    The Archives page displays.

  6. To start the archive process, click Archive.

    The Create Application Archive Options page appears.

  7. For Archive Type, select one of the following:
    • Incremental - This option archives only selected applications belonging to this service.

    • Full - This option archives all applications belonging to this service.

  8. Click Next.

    The Create Application Archive Contents page appears.

  9. Use the arrows between the two panels to move the applications you want to archive to the left panel under Applications to archive and the ones you do not want to archive to the right panel.
  10. Click Next.

    The Create Application Archive Confirm page appears.

  11. Enter any comments you want to describe this archive under Archive Comments.
  12. Click Create Archive.

    The Archive page appears and lists the new archive.