Tag: Database

Exporting Security Out of Hyperion Planning Application via Oracle Database Repository

I found the below article after hours of searching for a solution for us. I hope this helps others.   EPM 11.1.2 – Exporting Security out of Hyperion Planning application By Ruben Verghese on Sep 03, 2011 copied from https://blogs.oracle.com/pa/entry/exporting_security_out_of_hyperion You...

Oracle Database: Remove old archive files from RMAN

rman target / CROSSCHECK BACKUP; CROSSCHECK COPY; CROSSCHECK ARCHIVELOG; DELETE EXPIRED BACKUP; DELETE EXPIRED COPY; DELETE EXPIRED ARCHIVELOG; RMAN> report obsolete; RMAN> delete obsolete; recent commands: delete archivelog all completed before 'sysdate -1'; backup archivelog all; crosscheck backupset; crosscheck archivelog all;...