My env is Oracle 9.2.04. RAC and I have to work with LOB-s maxsize 2M.
Is Oracle "saves" LOB in redo log (and archived logs) so it can be recreated with restore and recover?
If answer is No:how can it be done?Is it can bi done?
When defining LOBs in a table, you can specify the tablespace and storage characteristics for each internal LOB. I guess LOGGING (and NOLOGGING) might be interesting for you. Read a little bit more about it here.
Shortly, when LOGGING is set, Oracle generates full redo for LOB data pages.