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 moreValidate RMAN Backups
Querying tables over database link is very common today. But what happens when we have a table that depends on one or more user defined types? Oracle needs to know the structure of our table and it’s columns when it receives it over the DB link. However, it cannot retrieve that information from remote server … Read moreQuery user defined types over database link
These are the minimum grants needed to execute AWR reports.
I just found a strange behavior in one of our PL/SQL procedures that is designed to load the data from external tables (files that arrive on the server). During one run, I noticed that “session PGA memory” was constantly increasing which made me look for a leak in the first place. To cut the very … Read moreMemory leak when changing external table location
As many of you know default date command on AIX doesn’t support “–date” parameter as Linux systems do. So, what can you do if you want to display another date in your shell script? There are some scripts roaming around the web, but the simplest thing i found is this. Get your time zone (let’s … Read moreGet yesterday’s date into a variable on AIX