While restoring and recovering a database UNTIL TIME which uses the block change tracking file, the recovery may be interrupted.
This was the error –
released channel: ch1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/18/2009 09:33:29
ORA-00283: recovery session canceled due to errors
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile ‘/u02/oradata/flash_recovery_area/TEST/archivelog/2009_02_18/o1_mf_1_117043_4spoq75y_.arc’
ORA-00283: recovery session canceled due to errors
ORA-19755: could not open change tracking file
ORA-19750: change tracking file: ‘/u02/oradata/test/ofsap_blk_change.dbf’
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 3
This file is not backed up by RMAN and not needed for recovery – it is purely used by RMAN for speeding up the incremental backups.
Therefore to workaround this problem simply disable block_change_tracking and restart the recovery .
sql > alter database disable block change tracking ;
RESTART THE RECOVERY UNTIL TIME –
RMAN> run {
SET UNTIL TIME “TO_DATE (’09-02-09 18:00:00′, ‘DD-MM-YY HH24:MI:SS’)”;
allocate channel ch1 type ‘sbt_tape’ parms ‘ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)’;
recover database;
release channel ch1 ;
}
executing command: SET until clause
allocated channel: ch1
channel ch1: sid=310 devtype=SBT_TAPE
channel ch1: Data Protection for Oracle: version 5.4.1.0
Starting recover at 18-FEB-09
starting media recovery
archive log thread 1 sequence 117043 is already on disk as file /u02/oradata/flash_recovery_area/TEST/archivelog/2009_02_18/o1_mf_1_117043_4spoq75y_.arc
archive log thread 1 sequence 117044 is already on disk as thread=1 sequence=117045
channel ch1: starting archive log restore to default destination ==
Recovery continues.
HI my question is:
Can I migrate a IBM DB2 (5.4 version) to Oracle 11g?
Is Oracle SQL Developer the correct tool?
I already read your article about the migration with Oracle SQL Developer, but I read that Oracle SQL Developer support DB2 6, 7, 8 and 9. But Don`t said in any place that I can use that tool with that version (5.4).
Please Can youn help me