Ransomware attackers specifically target and attempt to destroy backup systems to increase the probability of payment. Hardening your system is critical. Please ensure you have reviewed your platform security using the Security Hardening Checklist
Cohesity

COHESITY Documentation

Explore our documentation to get started, discover products & new features, access troubleshooting guides, register sources, platforms support.

Products
Data Security Alliance
Visit Cohesity.com
Demos
Support
Blogs
Developers
Partner Portals
Cohesity Community
© 2026 Cohesity, Inc. All Rights Reserved.
Terms of Use|
Privacy Policy|
Legal|
  1. Home
  3. IT Analytics Help
  5. Section XVI. System Administration
  7. Backing Up and Restoring Data
  9. Manual steps for database import / export using data pump

Manual steps for database import / export using data pump

Manual steps for Linux Data Pump Export (CDB and non-CDB environments)

Follow the steps to execute the Data Pump Export in a Linux environment

  1. Login to the Linux database server and switch to user aptare.
  2. Ensure that file /opt/aptare/database/tools/expdp_scdb.par is owned by aptare user and has 755 permissions.
  3. Ensure Oracle listener and Oracle services are running.
  4. Run following commands:
    su - aptare
source <INSTALL_PATH>/aptare/bin/aptare_env.sh
sqlplus / as sysdba
alter session set container=scdb;

    Note:

    The alter session set container=scdb; command is required for a container database. Please ignore it for a non-cdb environment.

    CREATE OR REPLACE DIRECTORY datapump_dir AS '/tmp';

    In case of a preferred folder such as new_directory_path:

    CREATE OR REPLACE DIRECTORY datapump_dir AS '/new_directory_path';

  5. Export the database using following command: 
    /opt/aptare/oracle/bin/expdp parfile=/opt/aptare/database/tools/expdp_scdb.par
  6. You can also choose to ignore the par file and include parameters in the expdp command directly. In other words, the above command can be replaced by the following command which can also be executed from aptare user. 
    /opt/aptare/oracle/bin/expdp system/aptaresoftware@//localhost:1521/scdb FULL=Y directory=datapump_dir dumpfile=aptare_scdb.exp logfile=export_scdb.log CONTENT=ALL flashback_time=systimestamp

    After successful completion, the data pump export file aptare_scdb.exp is saved in /tmp directory of the Linux Database server.

    In case you have specified a preferred directory, aptare_scdb.exp is saved to that preferred location (such as /new_directory_path).

  7. This step is required only if the database is exported from an IT Analytics version of 10.5 or above. Execute cp /opt/aptare/datarcvrconf/aptare.ks /tmp command to copy the aptare.ks file to /tmp folder
Manual steps for Linux Data Pump Import (CDB and non-CDB environments)

Follow the steps to execute Data Pump Import in a Linux Environment

  1. Place the export file aptare_scdb.exp created using data pump export in /tmp directory.

    If you have a different preferred directory (for example /new_directory_path), then place aptare_scdb.exp in your preferred directory (/new_directory_path).

  2. Ensure the aptare_scdb.exp file is owned by the aptare user and has 755 permissions.
  3. Ensure that files /opt/aptare/database/tools/unlock_portal_linux.sql and /opt/aptare/database/tools/impdp_scdb.par are owned by aptare user and have 755 permissions.
  4. Using root user, stop all Oracle and Aptare services by running following command: /opt/aptare/bin/aptare stop from root user.
  5. Using root user start Oracle services by running following command: /opt/aptare/bin/oracle start
  6. Ensure Oracle listener is running. Using aptare user check for status of Listener using following command: lsnrctl status
  7. Run following commands:
    su - aptare
source <INSTALL_PATH>/aptare/bin/aptare_env.sh
sqlplus / as sysdba
alter session set container=scdb;

    Note:

    The alter session set container=scdb; command is required for a container database. Please ignore it for a non-cdb environment.

    drop user aptare_ro cascade;

    drop user portal cascade;

    CREATE OR REPLACE DIRECTORY datapump_dir AS '/tmp';

    In case of a preferred folder such as new_directory_path:

    CREATE OR REPLACE DIRECTORY datapump_dir AS '/new_directory_path';

  8. Run the following command using aptare user
    /opt/aptare/oracle/bin/impdp parfile=/opt/aptare/database/tools/impdp_scdb.par
  9. You can also choose to ignore the par file and include parameters in the impdp command directly. In other words, the above command can be replaced by the following command which can also be executed from aptare user.
    /opt/aptare/oracle/bin/impdp system/aptaresoftware@//localhost:1521/scdb schemas=portal,aptare_ro directory=datapump_dir dumpfile=aptare_scdb.exp logfile=import_scdb.log
  10. When import completes in a non-CDB environment, remove first command 'alter session set container = scdb;' from the file unlock_portal_linux.sql and run following command from aptare user.

    Note:

    The removal of the 'alter session set container = scdb;' is required only for a non-CDB environment and no change is required if it is a Container database.

    sqlplus / as sysdba
@/opt/aptare/database/tools/unlock_portal_linux.sql
  11. After exiting from sqlplus, execute following command from aptare user 
    sqlplus portal/portal@//localhost:1521/scdb
@/opt/aptare/database/tools/validate_sp.sql
Post procedure steps

  1. Go to /tmp directory and check the file import_scdb.log.

    In case you have specified a preferred directory, check for import_scdb.log in your preferred location.

  2. Check the log file for the compilation warnings for the packages: view apt_v_solution_history_log, cmv_adaptor_pkg, avm_common_pkg, sdk_common_pkg, server_group_package, load_package, common_package, util. These compilation warnings are addressed by the script itself and no action is required from the user.

    Note:

    If you are importing DB from 10.4, upgrade the portal after the import to 10.5 build.

  3. This step is required only if the database is exported from an IT Analytics version of 10.5 or above. Run the following commands to copy the aptare.ks file to datarcvrconf folder.

    cp /tmp/aptare.ks /opt/aptare/datarcvrconf/
chown aptare:tomcat /opt/aptare/datarcvrconf/
chmod 664 /opt/aptare/datarcvrconf/aptare.ks

  4. Run updateUser.sh to change the password of the application account. For example, to change the password for the admin123 application user, run: updateUser.sh admin123 newPassword

  5. Restart all Oracle and Aptare services by running /opt/aptare/bin/aptare restart from root user.

  6. Login to the portal Application using the application account.

Manual steps for Windows Data Pump Export (Both CDB and non-CDB environments)

Follow the steps for Windows Data Pump Export

  1. Login to the Windows database server.
  2. Ensure Oracle TNS listener and Oracle services are running.
  3. Ensure Aptare user has access to the file c:\opt\oracle\database\tools\expdp_scdb_win.par

    Run following commands:

    sqlplus system/aptaresoftware@//localhost:1521/scdb

    create or replace directory datapump_dir as 'c:\opt\oracle\logs';

    Exit

  4. After exiting out of sqlplus, execute the following command: c:\opt\oracle\bin\expdp parfile=c:\opt\oracle\database\tools\expdp_scdb_win.par
  5. You can also choose to ignore the par file and include parameters in the expdp command directly. In other words, the above command can be replaced by the following command: c:\opt\oracle\bin\expdp system/aptaresoftware@//localhost:1521/scdb FULL=Y DIRECTORY=datapump_dir LOGFILE=export_scdb.log DUMPFILE=aptare_scdb.exp CONTENT=ALL FLASHBACK_TIME=systimestamp
  6. After successful completion, the data pump export file aptare_scdb.exp is saved in C:\opt\oracle\logs directory of the Windows Database server.

  7. Copy file c:\opt\datarcvrconf\aptare.ks to c:\opt\oracle\logs folder.

    Note:

    This step is required only if database is exported from an IT Analytics version of 10.5 or above.

Manual steps for Windows Data Pump Import (Both CDB and non-CDB environments)

Follow the steps for Windows Data Pump Import

  1. Login to the Windows database server.
  2. The Aptare user will already have access to import files c:\opt\oracle\database\tools\unlock_portal_win.sql and c:\opt\oracle\database\tools\impdp_scdb_win.par. In case the Oracle user does not have read and execute privileges on these files, please ensure privileges are granted before starting the import.
  3. Place the export file aptare_scdb.exp in c:\opt\oracle\logs directory
  4. In case the name of the export file is capitalized, please change it to lower case. For example, change the name 'APTARE_SCDB.EXP' to 'aptare_scdb.exp'
  5. Stop all Oracle and Aptare services using stopAllServices from windows services tab.
  6. Start OracleServicescdb from windows services tab and ensure Oracle TNS listener is running.

    Run following commands:

    Sqlplus / as sysdba

    Alter session set container = scdb; (note this command is included only for a container database, otherwise switch to container database is not required)

    DROP USER aptare_ro CASCADE;

    DROP USER portal CASCADE;

    CREATE OR REPLACE DIRECTORY datapump_dir AS 'c:\opt\oracle\logs';

    EXIT;

  7. After exiting out of sqlplus execute following command:

    c:\opt\oracle\bin\impdp parfile=c:\opt\oracle\database\tools\impdp_scdb_win.par

  8. You can also choose to ignore the par file and include parameters in the impdp command directly. In other words, the above command can be replaced by the following command: c:\opt\oracle\bin\impdp "sys/*@//localhost:1521/scdb as sysdba" SCHEMAS=portal,aptare_ro DIRECTORY=datapump_dir LOGFILE=import_scdb.log DUMPFILE=aptare_scdb.exp
  9. After import is complete, execute the following command: sqlplus "sys/*@//localhost:1521/scdb as sysdba" @c:\opt\oracle\database\tools\unlock_portal_win.sql
  10. After exiting out of sqlplus, execute the following command: sqlplus portal/portal@//localhost:1521/scdb @c:\opt\oracle\database\tools\validate_sp.sql
Post procedure steps

  • To check for import logs, go to c:\opt\aptare\oracle\logs and check the file import_scdb.log.

  • Check the log file for the compilation warnings for the packages: view apt_v_solution_history_log, cmv_adaptor_pkg, avm_common_pkg, sdk_common_pkg, server_group_package, load_package, common_package, util. These compilation warnings are addressed by the script itself and no action is required from the user.

    Note:

    If you are importing DB from 10.4, upgrade the portal after the import to 10.5 build

  • Copy the saved file from c:\opt\oracle\logs\aptare.ks to c:\opt\datarcvrconf\ folder. Ensure that the file is owned by IT Analytics user and has appropriate Read and Write access to the copied file.

    Note:

    This step is required only if database is exported from an IT Analytics version of 10.5 or above.

  • After successful completion of the import process, run StopAllservices using service tab on Windows.

  • Run startAllServices using service tab on Windows.

  • Run updateUser.bat from utils directory to change the password of the application account. For example, to change the password for the admin123 application user, run: updateUser.bat admin123 newPassword

  • Login to the portal Application using the application account.

Feedback

Was this page helpful?
Previous

Import the Oracle database

Next

Monitoring IT Analytics

Feedback

Was this page helpful?