Thursday, December 31, 2020

 How to restore RAC Thread archive logs using commvault libobk library 


rman 


connect target sys/******@db_name


connect catalog rmancatalogowner/********@rcat12c



Connect to RMAN 


run


{


  allocate channel ch1 DEVICE TYPE SBT


  PARMS="SBT_LIBRARY=/opt/commvault/Base/libobk.so,BLKSIZE=262144";


  restore archivelog from sequence  37807 thread 2 until sequence 37864 thread 2;


  release channel ch1;


}


 To Restore Thread 2 using commvault SBT_LIBRARY

 

 /opt/commvault/Base/libobk.so

Monday, December 28, 2020

Purge Unified Audit Trail

 

As the sys or system user 


select  count(*) from unified_audit_trail

/


BEGIN

DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL(

audit_trail_type         =>  DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED,

use_last_arch_timestamp  =>  FALSE);

END;

/


select  count(*) from unified_audit_trail

/