AnsweredAssumed Answered

AVUSER database schema restore

Question asked by Gabriele Rusconi on May 17, 2019
Latest reply on May 17, 2019 by Kristian Nordman

After a clean installation and configuration of:

  • RSA IGL 7.1.1 Virtual Appliance
  • Standalone Oracle Database Server (RSA provided)

I performed the database backup, following the "Database Setup and Management Guide V7.1.1" with the following command:

expdp avuser/secret@AVDB DumpFile=AVDB_$(date +%Y%m%d_%H%M%S).dmp Directory=AVEKSA_EXPORTIMPORT_DIRECTORY Schemas=AVUSER LogFile=AVDB_expdp_$(date +%Y%m%d_%H%M%S).log

to be able, in future, to restore that dump for reverting system data to the beginning.

 

Now I would like to restore the database and I tried with 000028204 - How to remove all user data stored in the RSA Identity Governance and Lifecycle application database but it does not work.

 

I also tried with https://community.rsa.com/docs/DOC-45917, in particular:

su - oracle
sqlplus / as sysdba
   drop user AVUSER cascade;
   CREATE USER AVUSER identified by secret profile ACMPROFILE;
   ALTER USER AVUSER DEFAULT TABLESPACE DATA_1M TEMPORARY TABLESPACE TEMP;

but then I can't connect to AVUSER because of lack of grant CREATE SESSION permission and, solved that issu, the AVUSER lacks other permissions to import data, etc.

 

 

 

May you help to find the right procedure to revert the AVUSER database date from scratch?

 

KR,

Gabriele. 

Outcomes