Posted by Kamran Agayev A. on 15th April 2011
I’m planning to present at TROUG (Turkish Oracle User Group) for the next week on April 21 in Istanbul, Turkey. The presentation will be on RMAN 11g New Features with practical demonstrations with Zekeriya Besiroqlu who’s working as a Senior Oracle Instructor for Oracle University Turkey. I can’t wait to meet my best Turkish friends 
For more information (on Turkish language), visit the following link:
http://www.troug.org/?p=406
Posted in Administration | 3 Comments »
Posted by Kamran Agayev A. on 15th April 2011
During testing 11g new feature – Flashback Transaction Backout, I got following internal error :
[code]
ORA-00600: internal error code, arguments: [ktftb_backout_xids_3], [1], [0],[], [], [], [], [], [], [], [], []
[/code]
After a little investigation I find out that I got it because of setting “numtxns” parameter incorrectly. I’ve set it to “2” while was backing out only one transaction:
[code]
declare
trans_arr xid_array;
begin
trans_arr := xid_array(‘08000C00DA000000’);
dbms_flashback.transaction_backout (
numtxns=>2,
xids => trans_arr,
options => dbms_flashback.cascade
);
end;
[/code]
Then I realized it and changed the value to “1” and the process succeeded. Instead of returning a readable error, Oracle throws an undefined internall error and there’s no any information on this error at metalink
Posted in Administration | 4 Comments »
