课程第25次（2017-04-17星期一）

botang · 发表于 2017-4-21 16:12:13

上完1Z0-053的第10章
1Z0-051共12章（上完10章），1Z0-052共19章（上完10章），1Z0-053共21章（上完3章）
总共上完全部52章中的23章

select d.SUPPLEMENTAL_LOG_DATA_MIN,
d.SUPPLEMENTAL_LOG_DATA_UI,
d.SUPPLEMENTAL_LOG_DATA_PK,
d.SUPPLEMENTAL_LOG_DATA_FK,
d.LOG_MODE
from v_$database d;
alter database add supplemental log data;
alter database add supplemental log data ( primary key ) columns;
select * from flashback_transaction_query ftq
where ftq.logon_user='HR' and ftq.table_name='T_NOCASCADE'
and ftq.table_owner='HR'
order by ftq.commit_scn desc;
begin
dbms_flashback.transaction_backout(1,xid_array('01000700AD020000'));
end;
select * from flashback_transaction_query ftq
where ftq.logon_user='HR' and ftq.table_name='T_CASCADE'
and ftq.table_owner='HR'
order by ftq.commit_scn desc;
begin
dbms_flashback.transaction_backout(1,xid_array('050021009A030000'),
dbms_flashback.cascade);
end;
select * from hr.t_cascade;
select * from dba_flashback_txn_report;
select * from dba_flashback_txn_state;
commit;
----------------
select * from flashback_transaction_query ftq
where ftq.logon_user='HR' and ftq.table_name='T_NOCASCADE_FORCE'
and ftq.table_owner='HR'
order by ftq.commit_scn desc;
begin
dbms_flashback.transaction_backout(1,xid_array('0200190077030000'),
dbms_flashback.nocascade_force);
end;
select * from dba_flashback_txn_state;
select * from hr.t_nocascade_force;
select * from dba_flashback_txn_report;
commit;
--------------------
select * from flashback_transaction_query ftq
where ftq.logon_user='HR' and ftq.table_name='T_NONCONFLICT_ONLY'
and ftq.table_owner='HR'
order by ftq.commit_scn desc;
begin
dbms_flashback.transaction_backout(1,xid_array('080018004C040000'),
dbms_flashback.nonconflict_only);
end;
select * from dba_flashback_txn_state;
select * from hr.t_nocascade_force;
select * from dba_flashback_txn_report;
commit;
-----
select * from dba_flashback_archive;
create flashback archive fda1
tablespace users quota 10M retention 2 year;
create flashback archive default fda2
tablespace users quota 10M retention 3 day;
alter flashback archive fda1 set default;
select * from dba_flashback_archive_ts;
alter flashback archive fda1 add tablespace example quota 5M ;
alter flashback archive fda1 modify tablespace users quota 20M;
alter flashback archive fda1 modify retention 1 year;
--revoke flashback archive on fda1 from hr;
select * from dba_flashback_archive_tables;
grant flashback archive on fda1 to hr;
select * from hr.SYS_FBA_HIST_73933;
create undo tablespace undotbs2 datafile size 10M ;
----------------
alter flashback archive fda1 purge before timestamp
(systimestamp - interval '0 00:00:01' DAY TO SECOND ) ;
alter table hr.employees no flashback archive ;

复制代码