Tuesday, January 12, 2016

How to check block corruption:

How to check block corruption:


BACKUP VALIDATE CHECK LOGICAL DATABASE ARCHIVELOG ALL;

select * from v$database_block_corruption;


How to configure redundancy:


CONFIGURE RETENTION POLICY TO REDUNDANCY 2;(Keep last two backups)

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;(Keep last three days backup)

No comments: