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.
Hi,
Aveksa ships with two commands available for dealing with database backup/restore: avdbexport and avdbimport
Export for your case would look like this:
Which creates the file "Export_AVDB_avuser_20190517_113136.dmp"
Importing it:
Where "_20190517_113136" is whatever is between "Export_AVDB_avuser" and ".dmp"
I have not had any problems with grants while using these. Try them and see if they solve your problems.