-- https://orabliss.blogspot.com/2016/02/oracle-rat-demo-part-1.html

CREATE PLUGGABLE DATABASE KENOBI ADMIN USER pdbdmin IDENTIFIED BY "RunDatab1218ase#1985Go!";
alter pluggable database KENOBI open;
alter pluggable database KENOBI save state;
alter session set container=KENOBI;
show con_name

@?/rdbms/admin/utlrp



CREATE PLUGGABLE DATABASE MAUL ADMIN USER pdbdmin IDENTIFIED BY "RunDatab1218ase#1985Go!";
alter pluggable database MAUL open;
alter pluggable database MAUL save state;
alter session set container=MAUL;
show con_name

@?/rdbms/admin/utlrp




run
{
  set nocfau;
  allocate channel ch01 device type disk format '/mnt/yavin4/tmp/_oracle_/orabackup/temp/rat1/JEDIPRD/%d_%U_%s_%t.bck';
  allocate channel ch02 device type disk format '/mnt/yavin4/tmp/_oracle_/orabackup/temp/rat1/JEDIPRD/%d_%U_%s_%t.bck';
  allocate channel ch03 device type disk format '/mnt/yavin4/tmp/_oracle_/orabackup/temp/rat1/JEDIPRD/%d_%U_%s_%t.bck';
  allocate channel ch04 device type disk format '/mnt/yavin4/tmp/_oracle_/orabackup/temp/rat1/JEDIPRD/%d_%U_%s_%t.bck';
  backup as compressed backupset incremental level 0 database section size 2G include current controlfile plus archivelog delete input;
  release channel ch01;
  release channel ch02;
  release channel ch03;
  release channel ch04;
  allocate channel ch01 device type disk format '/mnt/yavin4/tmp/_oracle_/orabackup/temp/rat1/JEDIPRD/%d_%U_%s_%t.controlfile';
  backup current controlfile;
  release channel ch01;
}

run
{
  set nocfau;
  allocate channel ch01 device type disk format '/mnt/yavin4/tmp/_oracle_/orabackup/temp/rat1/SITHPRD/%d_%U_%s_%t.bck';
  allocate channel ch02 device type disk format '/mnt/yavin4/tmp/_oracle_/orabackup/temp/rat1/SITHPRD/%d_%U_%s_%t.bck';
  allocate channel ch03 device type disk format '/mnt/yavin4/tmp/_oracle_/orabackup/temp/rat1/SITHPRD/%d_%U_%s_%t.bck';
  allocate channel ch04 device type disk format '/mnt/yavin4/tmp/_oracle_/orabackup/temp/rat1/SITHPRD/%d_%U_%s_%t.bck';
  backup as compressed backupset incremental level 0 database section size 2G include current controlfile plus archivelog delete input;
  release channel ch01;
  release channel ch02;
  release channel ch03;
  release channel ch04;
  allocate channel ch01 device type disk format '/mnt/yavin4/tmp/_oracle_/orabackup/temp/rat1/SITHPRD/%d_%U_%s_%t.controlfile';
  backup current controlfile;
  release channel ch01;
}



create or replace directory RAT_WORKLOAD as '/home/or




create or replace directory RAT_WORKLOAD as '/home/oracle/rat';
execute dbms_workload_capture.start_capture('RAT_CAPTURE','RAT_WORKLOAD');
-- execute Workload
execute dbms_workload_capture.finish_capture();

SQL> col name for a12
SQL> col status for a10
SQL> col dir_path for a25
SQL> set lines 300acle/rat';
execute dbms_workload_capture.start_capture('RAT_CAPTURE','RAT_WORKLOAD');
-- execute Workload
execute dbms_workload_capture.finish_capture();

col name for a12
col status for a10
col dir_path for a25
set lines 300

select id,name,status,start_time,end_time,connects,user_calls,dir_path from dba_workload_captures
where id = (select max(id) from dba_workload_captures) ;
 



set pagesize 0 long 30000000 longchunksize 1000
select dbms_workload_capture.report(2,'TEXT') from dual;
 
export PATH=$ORACLE_HOME/jdk/bin:$PATH
java -classpaexport PATH=$ORACLE_HOME/jdk/bin:$PATHth $ORACLE_HOME/jdbc/lib/ojdbc7.jar:$ORACLE_HOME/rdbms/jlib/dbrparser.jar:$ORACLE_HOME/rdbms/jlib/dbranalyzer.jar: oracle.dbreplay.workload.checker.CaptureChecker /home/oracle/rat jdbc:oracle:thin:@taris:1521/KENOBI