Bugman ( RMAN ) validate restore “bug”

Posted by oraclue on August 28, 2009 · 3 Comments 

If you are using RMAN (BUGMAN) like I do then you probably used VALIDATE command.Validate command is used to verify integrity of backups without performing backups etc. There are some “issues” with validate command.Actually Oracle intentionally did it but nevertheless it can be potential problem if you do not pay attention to it. Let me … Read more

Filed under Backup&Recovery

Tracking DDL changes in 11g

Posted by oraclue on August 20, 2009 · 6 Comments 

As you know Oracle provides DDL triggers to track changes to the database.Data from these triggers are used for auditing, change controls etc. But Oracle 11g also provides specific event for tracking DDL changes.It uses target called SQL_DDL. These events can be enabled on session or system level.This is shortest command: SQL> alter session set … Read more

Filed under Internals

Issues with upgrade to 11g

Posted by oraclue on August 13, 2009 · 5 Comments 

I was doing  manual upgrade from version 10.2.0.3 to 11.1.0.7 .Really  did not expect any big issues since I did it many times.So after doing all pre-upgrade steps ( or I taught I did all of them) I started database in upgrade mode and fired catupgrd.sql : SQL> startup upgrade ORACLE instance started. Total System … Read more

Filed under Troubleshooting