About thiago_cavalheiro

thiago_cavalheiro

Hello all,I recently released a tool in a shell script that aims to help with corrupted blocks.Of course it can only help with the recovery process itself, as it will still need a good backup of the database.To identify corrupted blocks and recover t...

thiago_cavalheiro

Hello Everyone,My post for the Data Geek Challenge is about music. I’ve picked a list of some of the best rock’n’roll history album with their sales numbers in millions. So here is the data I used for this blog:I have taken this information from thi...

thiago_cavalheiro

Hello All,I am here to share some scripts that might be useful for some situations. For creating regular SQL trace on Oracle generation we usually have transaction ST05. In case it is unavailable there, is an option to create it directly on sqlplus. ...

thiago_cavalheiro

Hi,For Oracle it is certainly good to check O2O migration for this purpose. It requires a paid service, but it is certainly the fastest option. It replicates the data during runtime, then switches over as if it were a stand by database.1508271 - Orac...

thiago_cavalheiro

Hello Prakash,Several times it is just easier to completely deinstall and reinstall the whole RDBMS, but you may try detaching and reattaching it. There's a list of steps for the in the note below, you may attemp the detach -> attach first, if it doe...

thiago_cavalheiro

Hello Fresh,If a small downtime is the most important requisite, you might want to check this: 1508271 - Oracle Lifecycle Migration Service (formerly O2O/Triple-O)Please note that this a paid service as explained in the note, but it is certainly the ...

thiago_cavalheiro

Eduardo Rezende: eduardo.rezende

thiago_cavalheiro

Hello Pavol,You need to adjust TAORA, IAORA and TSORA for TABART USER2. You can read more in the wiki page below:http://wiki.sdn.sap.com/wiki/x/v41RCwBest regards,Thiago

User Statistics

User Activity

Block corruption - Tool

Biggest Rock Albums Sales

Creating SQL traces directly on the Oracle level

Re: Large data footprint for OS/DB Migration

Re: OPatch failed with error code 73 durring SBP

Re: Oracle upgrade from 11 to 19

Re: Appreciation Awards - Cast Your Vote!

Re: Hetorogenous copy Import problems