第31和第32次：2014-08-30

botang

ttio.rcv

1. run{
   
2. set newname for datafile 5 to '/home/oracle/examplettio.dbf';
   
3. restore datafile 5;
   
4. delete datafilecopy '/home/oracle/examplettio.dbf';
   
5. }

复制代码

2014-08-30-plsql.sql:

1. select  * from v$block_change_tracking;
   
2. 
   
3. SELECT file#, avg(datafile_blocks),
   
4.         avg(blocks_read),
   
5.       avg(blocks_read/datafile_blocks)
   
6.             * 100 AS PCT_READ_FOR_BACKUP,
   
7.     avg(blocks)
   
8.   FROM   v$backup_datafile
   
9. WHERE  used_change_tracking = 'YES'
   
10. AND    incremental_level > 0
    
11. GROUP  BY file#;
    

复制代码