Oracle Cloud Infrastructure Documentation

Creating an Application Data Extract

A copy of your applications data can be requested after your subscription service period has expired.

If you don't renew your Fusion Applications subscription before the renewal due date, you'll have the ability to extract a copy of your applications data from your production environments. This option is available only post the renewal due date of your subscription as described in the Oracle Cloud Hosting and Delivery Policies and related Oracle Pillar document applicable to your Cloud Service, which are available at http://oracle.com/contracts.

To Request an Application Data Extract

For a period of time after your subscription is past its renewal date, your production environment displays an option for you to request an application data extract. The application data extract is made available through a pre-authenticated request (Par) URL to provide temporary and controlled access to the data extract.

  1. On the Environments list page, select your production environment. If you need help finding the list page, see To list environments.
  2. On the production environment details page, select Extract data.
  3. Select Request data extraction.
  4. On the Request data extract panel, type in the production environment name and then select Submit.

    A job is submitted to create the data extract. The job might take several hours to complete, depending on the size of your Fusion Applications database.

If you don't see an option to request application data, the self-service request period has passed, and you must file a service request (SR) with Oracle Support to create the application data extract.

To Download an Application Data Extract

When the data extract is available after the completion of a self-service request or a service request through Oracle Support, you can download the extract from the details page of the environment.

  1. Go to your production environment details page.
  2. On the production environment details page, select Extract data.

    The completed request is displayed as Succeeded.

  3. Select the Actions menu (three dots) for the line item, and then select Show extract data link.
  4. On the View extracted data panel, the data extract files from your production environment are listed along with the password to later decrypt the data extract. Ensure to retain the password.
  5. Select the checkbox for each file you want to download and then select Download.

    The data extract contains many files. Be sure to navigate through the entire list of extracts to download them all.

The PAR URL to access the data extract is valid for 15 minutes for you to start downloading files. Some data extract files might take longer to download. If you need more time to download all the files, select Regenerate, or refresh the browser page to reset the timer for another 15 minutes.

Working with the Application Data Extract

The data extract that you download is a compressed, encrypted TAR archive file, for example, Archive.tar.gpg or filename.bar.gpg, or filename.dmp.

Decrypt the archive file by running decryption software, such as GnuPG, available at https://gnupf.org/download/. Install the appropriate version for your operating system. Follow the software instructions for decrypting the file.

To extract (or untar) the files from the archive, run the following command:

gpg --output an_output_file_name --decrypt filename.tar.gpg

Enter the password provided on the View extracted data panel to start the extract. The extract files can be imported to a prepared database where the prerequisite users and tablespaces have been created. To get the current prerequisites, log a support request with Oracle Support.