第87/88/89/90次：2016-03-05双休日

admin

克隆脚本
http://124.16.180.178:8080/studentguide_sec_O11g/1Z0-053-20/

游客，本帖隐藏的内容需要积分高于 100 才可浏览，您当前积分为 0

2016-03-05a.sql：

1. select  * from dba_flashback_archive;
   
2. 
   
3. select  * from dba_flashback_archive_ts;
   
4. 
   
5. select  * from dba_flashback_archive_tables;
   
6. 
   
7. create tablespace tbsnew19 datafile size 50M  autoextend on ;
   
8. 
   
9. select object_id  from dba_objects
   
10. where object_name='TNEW19' and owner='HR';
    
11. 
    
12. select  * from hr.sys_fba_hist_80166;
    
13. 
    
14. alter flashback archive fba2  modify retention 31 day;
    
15. 
    
16. alter flashback archive fba2 modify tablespace users quota 11M ;
    
17. 
    
18. alter flashback archive fba1 purge before timestamp sysdate-1/144;
    
19. 
    
20. alter flashback archive fba2 add tablespace  tbsnew19 quota 20M;
    
21. 
    
22. alter flashback archive fba2 remove  tablespace tbsnew19;
    
23. 
    
24. create undo tablespace undotbs1 datafile size 20M autoextend on ;
    
25. 
    
26. alter system set undo_tablespace=undotbs1;
    
27. 
    
28. drop tablespace undotbs2;
    
29. 
    
30. alter system flush buffer_cache;

复制代码

2016-03-05b.sql：

1. select * from dba_flashback_archive_tables;
   
2. 
   
3. begin
   
4.    dbms_flashback_archive.disassociate_fba(owner_name => 'HR',
   
5.    table_name => 'TNEW19_4') ;
   
6.    end;
   
7.   
   
8.    begin
   
9.    dbms_flashback_archive.reassociate_fba(owner_name => 'HR',
   
10.    table_name => 'TNEW19_4') ;
    
11.    end;
    
12.    
    
13. 
    
14.      select   dbms_flashback.get_system_change_number from dual;
    
15.      
    
16.      ---
    
17.      
    
18.      select  
    
19.        d.SUPPLEMENTAL_LOG_DATA_MIN,
    
20.        d.SUPPLEMENTAL_LOG_DATA_PK,
    
21.        d.SUPPLEMENTAL_LOG_DATA_UI,
    
22.        d.SUPPLEMENTAL_LOG_DATA_FK,
    
23.        d.SUPPLEMENTAL_LOG_DATA_ALL,
    
24.        d.SUPPLEMENTAL_LOG_DATA_PL
    
25.       from v_$database d;
    
26.      
    
27.      
    
28.      alter database add supplemental log data;
    
29.      
    
30.      alter database add supplemental log data ( primary key)  columns;   
    
31.      
    
32.      
    
33.    
    
34.        alter database add supplemental log data ( foreign key)  columns;
    
35.       
    
36.        select  * from dba_flashback_txn_state;
    
37.       
    
38.    
    
39.       
    
40.        grant execute on sys.xid_array to hr;
    
41.       
    
42.        grant execute on dbms_flashback to hr;
    
43.       
    
44.        alter database drop supplemental log data ( foreign key)  columns;
    
45.      
    
46.             select      *   from dba_flashback_txn_report;
    
47.             
    
48.                select      *  from dba_flashback_txn_report  order by commit_time desc;
    

复制代码

2016-03-06a.sql：

1. select  
   
2.        d.SUPPLEMENTAL_LOG_DATA_MIN,
   
3.        d.SUPPLEMENTAL_LOG_DATA_PK,
   
4.        d.SUPPLEMENTAL_LOG_DATA_UI,
   
5.        d.SUPPLEMENTAL_LOG_DATA_FK,
   
6.        d.SUPPLEMENTAL_LOG_DATA_ALL,
   
7.        d.SUPPLEMENTAL_LOG_DATA_PL
   
8.       from v_$database d;
   
9.       
   
10. alter database add supplemental log data ( foreign key ) columns;
    
11. 
    
12. 
    
13. alter database drop supplemental log data ( foreign key ) columns;
    
14. 
    
15. select  * from dba_directories;
    
16. 
    
17. 
    
18. select  index_name from dba_indexes i where i.owner='HR' and i.table_name='DEPARTMENTS';
    
19. 
    
20. select  
    
21.     dbms_metadata.get_ddl('INDEX','DEPT_LOCATION_IX','HR') from dual;

复制代码

my2.par：

1. directory=dir1
   
2. dumpfile=my2.dmp  
   
3. schemas=hr
   
4. job_name=my2_job  
   
5. exclude=table:"in ('T_BANK_INVOICE')", procedure:"in ('SECURE_DML')"  
   
6. query='employees:where department_id=90'
   
7. flashback_time='2014-10-14:20:34:12'

复制代码

rc.local：

1. #!/bin/sh
   
2. #
   
3. # This script will be executed *after* all the other init scripts.
   
4. # You can put your own initialization stuff in here if you don't
   
5. # want to do the full Sys V style init stuff.
   
6. 
   
7. touch /var/lock/subsys/local
   
8. losetup /dev/loop0 /u01/loop/device/loop0.img
   
9. losetup /dev/loop1 /u01/loop/device/loop1.img
   
10. losetup /dev/loop2 /u01/loop/device/loop2.img
    
11. losetup /dev/loop3 /u01/loop/device/loop3.img
    
12. losetup /dev/loop4 /u01/loop/device/loop4.img
    
13. losetup /dev/loop5 /u01/loop/device/loop5.img
    
14. losetup /dev/loop6 /u01/loop/device/loop6.img
    
15. losetup /dev/loop7 /u01/loop/device/loop7.img
    
16. losetup /dev/loop8 /u01/loop/device/loop8.img
    
17. losetup /dev/loop9 /u01/loop/device/loop9.img
    
18. oracleasm scandisks
    
19. 
    
20. /u01/app/oracle/product/11.2.0/grid/bin/acfsload
    
21. 
    
22. 
    
23. 
    
24. su - oracle -c "export ORACLE_SID=+ASM; export ORACLE_HOME=/u01/app/oracle/product/11.2.0/grid; asmcmd volenable -G ACFS  ACFS_DB1"
    
25. mount.acfs -o all
    
26. 
    
27. 
    
28. su - oracle -s "crsctl start res ora.orcl.db"

复制代码