Oracle database: Export backups
This is the preferred method of ensuring that your database is backed up on a regular basis.
The database user Aptare must have access to the export files stored in the directory:
c:\opt\oracle\database\tools
Verify that Oracle user has read and execute privileges on these files before starting the database export.
Log into the Windows database server.
Ensure Oracle TNS Listener and Oracle services are running.
At the command prompt execute the script:
c:\opt\oracle\database\tools\expdp_database_template.bat
After successful completion, the export file
aptare_scdb.expis saved on the Windows database server in the directory:c:\opt\oracle\logsCopy the
c:\opt\aptare\datarcvrconf\aptare.kstoc:\opt\oracle\logsfolder. This file will be required during the database import.Note:
This step is required only if database is exported from an IT Analytics version of 10.5 or above.
Copy the
c:\opt\aptare\datarcvrconf\aptare_external_password.propertiesfile toc:\opt\oracle\logsfolder. This file will be required during the database import.Note:
This step is required only if database is exported from an IT Analytics version 11.0 or above.
To schedule the export task refer to the following.
See Scheduling the Export Job (Windows).
The database user Aptare must have access to the export files stored in the directory:
/opt/aptare/database/tools
Verify that Oracle user has read and execute privileges on these files before starting the database export.
IT Analytics installer supports Portal and database installation on custom path. If your Portal or database is installed in a non-default location, replace \opt with the respective absolute installation path in the commands and procedures provided in this section.
Log into the Linux database server and switch to user Aptare.
Ensure Oracle Listener and Oracle services are running.
Change to the directory:
/opt/aptare/database/tools
Execute the command:
./export_database_template.sh
After successful completion, the export file aptare_scdb.exp is saved in the /tmp directory on the Linux database server.
Run the cp /opt/aptare/datarcvrconf/aptare.ks /tmp command. This file will be required during the database import.
Note:
This step is required only if database is exported from an IT Analytics version of 10.5 or above.
Run the cp /opt/aptare/datarcvrconf/aptare_external_password.properties /tmp command. This file will be required during the database import.
Note:
This step is required only if database is exported from an IT Analytics version 11.0 or above.
To schedule the export task refer to the following.