Application Archiving

Modifications to your Oracle Application Express applications can be archived to tables in your database schema. Applications that belong to Oracle Database Exadata Express Cloud 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

• Manage and View Application Archives

• Manually Archiving Applications

Schedule Daily Automatic Application Archiving

You can schedule daily automatic archiving for all applications that belong to your Oracle Database Exadata Express Cloud Service. Automatic daily archiving is enabled and disabled from the Service Details page, under Administration. A Exadata Express 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.

To schedule automatic application archiving:

1. Access your Exadata Express console. See Access the Service Console.

   The Service Console appears.

2. Click Manage Application Express.

   The Manage Application Express dialog appears.

3. Click Application Archiving.

   The Application Archiving dialog appears.

   Note:

    If application archiving is disabled the Enable button is visible, otherwise the disable application archiving button is displayed.
4. Click Enable.

   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 the Oracle Database Exadata Express Cloud Service is enabled for automatic application archiving or when a manual archive is performed.

Topics:

• Install the Oracle APEX Application Archive Packaged App

• Run the Oracle APEX Application Archive App

• View and Manage Application Archives

• Restore Oracle APEX Applications

To learn more, see Schedule Daily Automatic Application Archiving and Manually Archiving 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 Productivity Apps from the Oracle Database Exadata Express Cloud Service console. See Access Oracle Application Express.

   The Packaged Apps Gallery appears.

   
   

   
   Description of the illustration packaged_apps_gallery-1.jpg

   
   
2. Locate and click the APEX Application Archive app.

   The application information page displays.

   
   

   
   Description of the illustration archive_app_info5-1.jpg

   
   
3. Click Install Application.

4. 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 .

5. On the confirmation page, click Install Application.

6. 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 .

7. 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.

8. To test the application, from the APEX Application Archive app information page, click 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 Oracle Application Express Application Builder from the Oracle Database Exadata Express Cloud Service console. See Access Oracle Application Express

   The Application Builder home page displays.

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

   

   The APEX Application Archive app home page appears.

   To learn how to use this application, see View and Manage Application Archives.

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).

   To learn more, see Install the Oracle APEX Application Archive Packaged App.

Manually Archiving 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 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.

Restore Oracle APEX Applications

The Oracle APEX Application Archive packaged app can be used to restore Oracle APEX applications.

To restore the Oracle APEX applications:

1. Once the APEX Application Archive app is installed, run the application. See Run the Oracle APEX Application Archive App.
2. Click Restore.
   
   
   Description of the illustration apex_packaged_app_restore.jpg
   
3. Select the archive from the Archived Content list and click Restore.
   You can restore workspace files by first downloading the script from Archived Content list and then import the script. See Importing an Application, Page or Component Export in Oracle Application Express App Builder User’s Guide.
4. On the following page, review the settings and click Restore Content.

   An archived copy of the application is added to the repository available to Application Builder.

5. Navigate to Oracle Application Express home page. See Access Oracle Application Express.
6. Click Application Builder.
7. Click Workspace Utilities.
8. Click Export.
9. Click Export Repository on the right hand navigation under Tasks.
10. Locate your file and click Install next to it.