课程第19/20次（2017-08-19星期六上下午）

botang

上完1Z0-052第5章，1Z0-053第10章
1Z0-052共19章（上完10章），1Z0-053共21章（上完3章）和1Z0-063多租户部分共9章（上完0章）
总共上完全部49章中的13章

t05310.sql.zip (291 Bytes, 下载次数: 329)

2017-8-19 18:02 上传

点击文件名下载附件

1. select  * from v$log;
   
2. 
   
3. select  * from v$logfile;
   
4. 
   
5. alter database drop logfile group 3;
   
6. 
   
7. alter database add logfile group 3  '/u01/app/oracle/oradata/orcl/redo03.log'
   
8.     size 52428800;
   
9.    
   
10. alter system checkpoint;
    
11. alter database drop logfile group 1;  
    
12. 
    
13.   alter database add logfile group 1  '/u01/app/oracle/oradata/orcl/redo01.log'
    
14.     size 52428800;
    
15.    
    
16.     alter system switch logfile;
    
17.    
    
18.      alter system checkpoint;
    
19.      
    
20.       alter database drop logfile group 2;  
    
21.         alter database add logfile group 2  '/u01/app/oracle/oradata/orcl/redo02.log'
    
22.     size 52428800;
    
23.    
    
24.     -----
    
25.    
    
26.     select  * from v$datafile;
    
27.    
    
28.     select  * from v$controlfile;
    
29.    
    
30.     --------------
    
31.     select  * from v$log;
    
32.    
    
33.     alter database drop logfile group 3 ;
    
34.    
    
35.     alter database add logfile group 3  ('+data','+fra') size 50M ;
    
36.    
    
37.     alter database drop logfile group 1;
    
38.    
    
39.      alter database add logfile group 1  ('+data','+fra') size 50M ;
    
40.      
    
41.      alter system switch logfile;
    
42.      
    
43.      alter system checkpoint;
    
44.      
    
45.         alter database drop logfile group 2;
    
46.         
    
47.              alter database add logfile group 2  ('+data','+fra') size 50M ;
    
48.             
    
49.             
    
50.          select  * from v$logfile;
    
51.      
    
52.    
    
53.    
    
54.    
    
55.    
    
56.    
    
57.    
    
58.       

复制代码

1. select  * from flashback_transaction_query ftq
   
2. where ftq.table_name='EMPLOYEES' ;
   
3. 
   
4. --0A000D00BC020000
   
5. 
   
6. select xid  from v$transaction ;
   
7. 
   
8. --1133493

复制代码

DDL commands are seen as dictionary updates:

1. select  * from flashback_transaction_query ftq
   
2. where ftq.table_name='T_NOCASCADE'
   
3. order by ftq.commit_scn desc ;
   
4. 
   
5. ----01000C00D7020000
   
6. 
   
7. begin
   
8.    dbms_flashback.transaction_backout(numtxns => 1,
   
9.    xids => sys.xid_array('01000C00D7020000') );
   
10. end;
    
11.    
    
12. select  * from flashback_transaction_query ftq
    
13. where ftq.table_name='T_CASCADE'
    
14. order by ftq.commit_scn desc ;
    
15. 
    
16. ----0600030087030000
    
17. 
    
18. begin
    
19.    dbms_flashback.transaction_backout(numtxns => 1,
    
20.    xids => sys.xid_array('0600030087030000'),
    
21.    options => dbms_flashback.cascade
    
22.    
    
23.      
    
24.     );
    
25. end;
    
26.    
    
27. select  * from dba_flashback_txn_report;
    
28. 
    
29. 
    
30. select  * from dba_flashback_txn_state;
    
31. 
    
32. commit;

复制代码