Restore Ranger KMS Database

Restoring Ranger KMS involves steps for restoring MSQL, POSTGRES, and Oracle databases.

MySQL

To restore the database, perform the folllowing:

Delete the existing database.
Create an empty new database on the Database host.

Restore the database using below msyql command.

mysql -u root
drop database rangerkms;
create database rangerkms;
GRANT ALL PRIVILEGES ON rangerkms.* TO 'rangerkms'@'localhost';
$ mysql -u [username] -p  existing_empty_db_name < dump_fileName.sql

Example

mysql -u rangerkms -p rangerkms < /root/backups/ranger/db/kms/rangerkms.sql

Press the Enter key. Type the database password when the password prompts.

POSTGRES

To restore data, perform the folllowing:

Delete the existing database.
Create an empty new database in its place.
Run the below command on postgres database host.

dropdb -U owner_username dbname; [Enter db owner password at the prompt]

Example

dropdb -U rangerkms  rangerkms;

su  -  postgres
psql 
create database rangerkms; 
ALTER DATABASE rangerkms OWNER TO rangerkms;
\q
exit
psql -U rangerkms rangerkms < /root/backups/ranger/db/kms/rangerkms.sql 
[Enter db owner password at the prompt as rangeradmin]

For Oracle

rm -rf del_kms_tbl_cmd.sql
        	sqlplus -s rangerkms/rangerkms << EOF
               spool on
        	spool del_kms_tbl_cmd.sql
        	SELECT 'DROP TABLE "' || TABLE_NAME || '" CASCADE CONSTRAINTS;' FROM user_tables
        			union ALL
        			select 'drop '||object_type||' '|| object_name || ';' from user_objects 
        			where object_type in ('VIEW','PACKAGE','SEQUENCE', 'PROCEDURE', 'FUNCTION')
        			union ALL
        			SELECT 'drop '
        			||object_type
        			||' '
        			|| object_name
        			|| ' force;'
        			FROM user_objects
        			WHERE object_type IN ('TYPE');
        	spool off
	@del_kms_tbl_cmd.sql
	exit;
EOF

Press Enter and then run the following command.

imp rangerkms/rangerkms file=backups/ranger/db/kms/orcl12c.sql 
log=backups/ranger/db/kms/restore.log