93 lines
3.5 KiB
Plaintext
93 lines
3.5 KiB
Plaintext
-- 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 |