Month: March 2007

Data Guard today

Today had noticed that redo logs were not being applied to standby. Checking live database alert log showed errors like:

Posted in Rman

Bug? with wrong results from all_objects in stored plsql procedures

Wouldn’t it be nice if sql code produced the same result, regardless of whether it is inside a stored procedure or is a standalone plsql block? But that’s not what happens when the all_ views are used. Run this code

Posted in Bugs, Scripts