How to Backup APEX Applications using Oracle APEX Application Archive

Backup APEX applications using APEX APPLICATION ARCHIVE

We have been receiving many requests for a step by step tutorial on installing and using Oracle APEX backup archive application: APEX Application Archive. For any additional help on how to backup APEX applications, feel free to contact the Revion APEX team.

So here we go:

Installing APEX (backup) Application Archive:

1. Once logged in to your workspace, navigate to Application builder -> Packaged Applications

APEX Application Builder with the Packaged Applications menu item selected.

2. There you will see a list of productivity applications. Click on APEX Application Archive and then click on the Install Application button

The Packaged Applications list of productivity applications, with APEX Application Archive and its Install Application button.

3. On the next screen you will be asked to choose Authentication method. You may chose the default method, Application Express Accounts

The install screen asking which authentication method to use, with the default Application Express Accounts option selected.

4. On the summary page, verify your information and click Install Packaged App

The installation summary screen with the Install Packaged App button.

5. You should see the application installed successfully. Hit the Run Application to start backing up your applications.

Confirmation that APEX Application Archive installed successfully, with the Run Application button.

Backing up applications using APEX Applications Archive:

1. Once you run APEX Application Archive, you will be prompted to enter a username/password. Since you chose \”Application Express Accounts\” as your method earlier, you may use your Apex workspace username and password to login.

The APEX Application Archive sign-in prompt asking for the APEX workspace username and password.

2. Next step you will need to setup access control (one time process). You have the choice of different levels of access control

The one-time access control setup screen offering different levels of access control.

3. Once logged in, you will see an overview of your archived applications. To start archiving, click on**\”Applications\”** on the top left hand side of the screen.

The APEX Application Archive overview of archived applications, with the Applications tab at the top left.

4. To archive individual applications, click on the archive button (right side of screen) for the application you want to archive (backup). Then click on Archive Application on the Archive summary screen.

The application list with the archive button on the right of each row and the Archive Application summary screen.

5. To archive more than application at a time, click on Applications on the left hand side of the screen. Then click on \”Archive Application(s)\”. On the next screen, you will see a the archive name and message to the location of the application archive (table APEX$)

6. On the next screen, you will need to choose which applications to archive. HINT: Choose by moving the apps to backup to the right column. Hit next.

The multi-application archive step, choosing which applications to archive by moving them into the right-hand column.

7. Next you will see is a summary of the application being backed up. Be sure the applications are listed to be archived.

The final summary listing the applications that will be archived. Here is a link to the next article which explains how to restore your application:

How to restore APEX applications

For the latest Oracle APEX developments, click the following link:

https://www.oracle.com/database/technologies/appdev/apex.html

Revion offers a full suite of managed services such Oracle APEX and AWS management:

Oracle APEX hosting from Revion

Cookie	Duration	What it does, and who sets it
revion_consent	12 months	Set by revion.com. Remembers which categories you allowed here, and which version of this notice you were shown, so that we do not ask again until it changes. It holds a setting and nothing else: no visitor identifier, and nothing that follows you between visits.
__cf_bm	30 minutes	Set by Cloudflare, inside the Cal.com booking calendar, on the cal.com domain. Tells automated traffic apart from real visitors so that the calendar stays available to people. It reads how the request was made, not who made it. Measured at 29 to 30 minutes.
__Secure-next-auth.callback-url	Until you close your browser	Set by Cal.com, on the cal.com domain. Part of the sign-in machinery of Cal.com's own application, which the calendar page is built on. You are not signing in to anything, and it holds no account of yours. It is deleted when you close your browser.
__Secure-next-auth.csrf-token	Until you close your browser	Set by Cal.com, on the cal.com domain. A one-visit token that lets Cal.com tell a form you submitted apart from one another site submitted on your behalf. It is deleted when you close your browser.
uid	Until you close your browser	Set by Cal.com, on the app.cal.com domain, and only once you pick a time slot: opening the page does not write it. It holds the slot Cal.com has put on hold for you while you fill the booking form in, so that two people cannot be given the same time. It is deleted when you close your browser.

Cookie	Duration	What it does, and who sets it
_ga	400 days	Set by Google Analytics, on the revion.com domain. Tells one visitor apart from another so that visits can be counted without identifying anyone. Two page views from the same browser count as one visitor rather than two. Written only after you allow this category.
_ga_T94F03YGES	400 days	Set by Google Analytics, on the revion.com domain. Keeps track of the visit you are in the middle of, for our own measurement property: the letters on the end are that property, and no other site shares it. Written only after you allow this category.

Backup APEX applications using APEX APPLICATION ARCHIVE

We value your privacy