000038185 - 'ORA-39246: cannot locate master table within provided dump files' error restoring an RSA Identity Governance & Lifecycle oracle database

Document created by RSA Customer Support Employee on Nov 26, 2019
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000038185
Applies ToRSA Product Set: Identity Governance and Lifecycle
RSA Product/Service Type: Appliance
RSA Version/Condition: All

 
IssueWhen restoring an RSA Identity Governance & Lifecycle oracle database, the following errors occur and the restoration of the database fails:
 

ORA-39002: invalid operation
ORA-39059: dump file set is incomplete
ORA-39246: cannot locate master table within provided dump files
CauseWhen a database export occurs, the first table created at the startup of the export process is a master table which maintains the location of database objects inside the dump file. This error occurs when the import cannot find this file either because the exported database dump file is corrupt or because not all the exported dump files were supplied at the time of the import, specifically the one containing the master table.

 
ResolutionIf this is a non RSA-supplied database, please check with your oracle DBA.

If this is an RSA-supplied database, check the export log file (/home/oracle/AveksaExportImportDir/Export_AVDB_avuser-YYYY-MM-DD-##-##) that was generated during the database export for a list of dump files created. If multiple dump files were created, make sure all of the exported files are copied to  /home/oracle/AveksaExportImportDir for import.

If that does not resolve the issue or if there is only one dump file, then your backup is corrupt and another backup needs to be used for import.

For more information on exporting and importing an RSA Identity Governance & Lifecycle oracle database, please see RSA Knowledge Base Article 000038174 -- How to backup (export) and restore (import) an RSA Identity Governance & Lifecycle oracle database.

Attachments

    Outcomes