-- создать таблицу
drop SEQUENCE seq_id;
CREATE SEQUENCE seq_id START WITH 1 INCREMENT BY 1;
drop TABLE tab_01;
CREATE TABLE tab_01 (
id NUMBER DEFAULT seq_id.NEXTVAL PRIMARY KEY,
dt_reg DATE DEFAULT SYSDATE,
hostname VARCHAR2(100),
status VARCHAR2(100),
fail_date date,
error VARCHAR2(256)
);
-- процедура наполения таблицы во время экспемента
truncate table tab_01;
SET SERVEROUTPUT ON
DECLARE
v_hostname varchar2(100);
v_status VARCHAR2(100);
v_fail_date date;
v_error VARCHAR2(256);
BEGIN
LOOP
--
select host_name into v_hostname from v$instance;
SELECT status,fail_date, error into v_status,v_fail_date, v_error FROM v$archive_dest WHERE dest_id = 2;
--
INSERT INTO tab_01(hostname,status,fail_date,error) VALUES (v_hostname, v_status, v_fail_date, v_error);
COMMIT;
DBMS_LOCK.SLEEP(1);
END LOOP;
END;
/
-- примеры включение-выключение доступности между серверами
iptables -I OUTPUT -d 192.168.0.32 -j DROP
iptables -I INPUT -s 192.168.0.32 -j DROP
iptables -D INPUT 1
iptables -D OUTPUT 1
