The acquired bank's data warehouse runs on Oracle Database 10g, which offers a few tools John can use to achieve his objectives. For the first objective, he decides to use the Block Change Tracking feature, new in this version. Block change tracking causes the changed database blocks to be flagged in a special file.
SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/u01/backup/rman/rman.trc';
NOTA: SE ACTIVA CUANDO TENGO UNA ESTRATEGIA DE BACKUP RMAN INCREMENTAL.
SQL> alter database enable block change tracking using file '/u01/backup/rman/tracking.trc';
SQL> alter database disable block change tracking;
MONITOREAR ESTADO BACKUP INCREMENTALES < 20%
SELECT file#, avg(datafile_blocks), avg(blocks_read), avg(blocks_read/datafile_blocks)*100 AS PCT_READ_FOR_BACKUP, avg(blocks)
FROM V$BACKUP_DATAFILE
WHERE used_change_tracking='YES' and incremental_level>0
GROUP BY file#
/
SELECT file#, avg(datafile_blocks), avg(blocks_read), avg(blocks_read/datafile_blocks)*100 AS PCT_READ_FOR_BACKUP, avg(blocks)
FROM V$BACKUP_DATAFILE
WHERE used_change_tracking='YES' and incremental_level>0
GROUP BY file#
/
No hay comentarios:
Publicar un comentario