Table of Contents

Search

  1. Preface
  2. Starting Data Archive
  3. System Configuration
  4. Database Users and Privileges
  5. Source Connections
  6. Target Connections
  7. Archive Store Configuration
  8. Datatype Mapping
  9. Database Optimization
  10. SAP Application Retirement
  11. z/OS Source Data Retirement
  12. Seamless Data Access
  13. Data Discovery Portal
  14. Security
  15. SSL Communication with Data Vault
  16. LDAP User Authentication
  17. Auditing
  18. Running Jobs from External Applications
  19. Salesforce Archiving Administrator Tasks
  20. Upgrading Oracle History Data
  21. Upgrading PeopleSoft History Data
  22. Data Archive Maintenance
  23. Storage Classifications
  24. Appendix A: Datetime and Numeric Formatting
  25. Appendix B: Data Archive Connectivity

Administrator Guide

Administrator Guide

Target Database Requirements

Target Database Requirements

Verify the target database requirements when you archive to another database. The target database is the location where you archive data to and is typically referred to as the history or archive database. You can verify the requirements before or after the installation.
The target database must be on the same platform and version as the source database. For example, if you archive from an Oracle 10g database, the target database must be Oracle 10g.
Create the following history tablespaces when you archive to another database:
  • History data tablespace. For example, AM_HISTORY_D. The history data tablespace stores the archived data.
  • History index tablespace. For example, AM_HISTORY_X. The history index tablespace stores the associated indexes of the archived data.
The history tablespace requirements depend on the size of the data and indexes in the archive job. Configure the tablespace size to at least the same size of the source instance to store all data and the associated indexes to be archived.

0 COMMENTS

We’d like to hear from you!