nologging in Oracle

Long time ago when i was still an apprentice doing my fist ETL for one i learned about the good and common practice that specific tables in data warehouse should be loadedĀ in NOLOGGING mode. Reasoning for doing this were sound, we did it for the tables that can always be repopulated with ETL. It won’t … Read more

Validate RMAN Backups

I just had a task to validate rman backup of a production database without actually having to restore it somewhere. Although i prefer to do something like clone the database from backup and see for myself if the instance will actually open and work, there is a way to do simple validationĀ from rman. RMAN allows … Read more