Tag: validate

Using RMAN to validate backup

When using VALIDATE option, Oracle will validate backup and not create backups and will not restore when this option is used. # Validate if datafile exists and have no physical or logical corruptions that would prevent RMAN from running. If "archivelog" is specified it will also check if archive logs are valid too RMAN> backup … Continue reading Using RMAN to validate backup

How to check physical and logical data corruption using RMAN?

If you are not using RMAN to backup data and use technologies like NetApp snapshot which doesn't check for physical and logical corruption, one can still use RMAN to check for physical and logical corruption in the datafiles and not back the data up. connect target / run { # set disk to be default … Continue reading How to check physical and logical data corruption using RMAN?