6、重放相关

##开启、关闭
```
create directory CAPTURE_DIR as '/data6/capture';

--开启
BEGIN
  DBMS_WORKLOAD_CAPTURE.START_CAPTURE(
    name => 'dbm01_capture',
    dir  => 'CAPTURE_DIR'
  );
END;
/

--关闭
BEGIN
  DBMS_WORKLOAD_CAPTURE.FINISH_CAPTURE;
END;
/

BEGIN
  DBMS_WORKLOAD_REPLAY.INITIALIZE_REPLAY(
    replay_name => 'my_replay',
    replay_dir  => 'REPLAY_DIR'
  );
END;
/

wrc mode=replay replaydir=/path/to/replay_dir

BEGIN
  DBMS_WORKLOAD_REPLAY.START_REPLAY;
END;
/

BEGIN
  DBMS_WORKLOAD_REPLAY.CANCEL_REPLAY;
END;

```

##定时任务
```bash
#startup.sh
#!/bin/bash

export ORACLE_SID=dbm011

mkdir -p /data6/capture/dbm01
chown oracle:oinstall /data6/capture
chown oracle:oinstall /data6/capture/dbm01

# 开始捕获
sqlplus -s / as sysdba  <<EOF
BEGIN
  DBMS_WORKLOAD_CAPTURE.START_CAPTURE(
    name => 'dbm01_capture',
    dir  => 'CAPTURE_DIR'
  );
END;
/
EXIT;
EOF

echo $(date +%Y%m%d%H%M) >> /data6/capture.log
echo "Capture started." >> /data6/capture.log

#stop.sh
#!/bin/bash

export ORACLE_SID=dbm011

sqlplus -s / as sysdba  <<EOF
    BEGIN
      DBMS_WORKLOAD_CAPTURE.FINISH_CAPTURE;
    END;
    /
    EXIT;
EOF

mv /data6/capture /data6/capture_$(date +%Y%m%d%H)

echo $(date +%Y%m%d%H%M) >> /data6/capture.log
    echo "Capture finished." >> /data6/capture.log

#0 12 18 * * su - oracle -c "sh /data6/capture_start.sh"
#0 10 17 * * su - oracle -c "sh /data6/capture_stop.sh && sh /data6/capture_start.sh"
#0 12 17 * * su - oracle -c "sh /data6/capture_stop.sh && sh /data6/capture_start.sh"
#0 14 17 * * su - oracle -c "sh /data6/capture_stop.sh && sh /data6/capture_start.sh"
#0 16 17 * * su - oracle -c "sh /data6/capture_stop.sh && sh /data6/capture_start.sh"
30 18 18 * * su - oracle -c "sh /data6/capture_stop.sh"
```

DBLOG

导航1234

最近发表

友情链接