How to revert back if Oracle Upgrade from 10.2.0.4...

Former Member · ‎07-23-2011

Dear Experts,

I am in a process to upgrade oracle 10.2.0.4 to 11G Database upgrade. During the Mid of the upgrade from 10.2.0.4 to 11G the upgrade immediately got terminated. DBUA is in step upgrading oracle server. It was almost all 50% completed. suddenly got terminated unknowingly. I checked the alertSID.log and all other relavant log files. rather i didnt find any root cause for the cause of the termination.

I suspect it might have got terminated due to inactive session security levied by our unix team.

I tried to restart the DBUA once again. I am getting the error ora-00600. I checked the alertSID.log. here is the log file for your reference.

I checked the trace.log. The last few lines for the trace.log, i will post it in the following thread.

I also checked oracleserver.log.

I will post the logfile followed by this thread.

However the current situation is

I tried to recover the oracle binaries with the option FLASH BACK.

1. startup nomount

2. FLASHBACK DATABASE TO RESTORE POINT BEFORE_11G_UPGRADE;

while i give that command I am getting the error end of file of communication channel. when i check the alertSID.log i see ora-600 error. the log files is as follows.

First i checked alertSID.log

Successful mount of redo thread 1, with mount id 3602317500

Fri Jul 22 16:54:24 2011

Allocated 3981120 bytes in shared pool for flashback generation buffer

Starting background process RVWR

RVWR started with pid=13, OS id=7594040

Fri Jul 22 16:54:25 2011

Database mounted in Exclusive Mode

Completed: ALTER DATABASE MOUNT

Fri Jul 22 16:54:29 2011

FLASHBACK DATABASE TO RESTORE POINT BEFORE_11G_UPGRADE

Flashback Restore Start

Fri Jul 22 16:54:35 2011

Errors in file /oracle/HR2/saptrace/background/hr2_dbw0_7782512.trc:

ORA-00600: internal error code, arguments: [999], [0x70000003D7B9FBA], [], [], [], [], [], []

Fri Jul 22 16:54:35 2011

Errors in file /oracle/HR2/saptrace/background/hr2_dbw0_7782512.trc:

ORA-00600: internal error code, arguments: [999], [0x70000003D7B9FBA], [], [], [], [], [], []

Fri Jul 22 16:54:35 2011

DBW0: terminating instance due to error 471

Instance terminated by DBW0, pid = 7782512

I have also checked the file Errors in file /oracle/HR2/saptrace/background/hr2_dbw0_7782512.trc: Here is the logfile data which gives the error.

Dump file /oracle/HR2/saptrace/background/hr2_dbw0_7782512.trc

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, Data Mining and Real Application Testing options

ORACLE_HOME = /oracle/HR2/102_64

System name: AIX

Node name: kftdeedcbx12

Release: 3

Version: 5

Machine: 00C95BEE4C00

Instance name: HR2

Redo thread mounted by this instance: 1

Oracle process number: 5

Unix process pid: 7782512, image: oracle@kftdeedcbx12 (DBW0)

2011-07-22 16:54:35.137
SERVICE NAME:() 2011-07-22 16:54:35.135
SESSION ID:(167.1) 2011-07-22 16:54:35.135

Block Checking: DBA = 402665978, Block Type = Undo data block

ERROR: Undo Block Corrupted. Error Code = 2005

ktu4ubck: Undo Record addr did not aligned to boundary

record number=1, addr=3d7b9fba, aligned addr=3d7b9fbc

UNDO BLK HEADER:

xid: 0x0000.01c.000001fa seq: 0x176 cnt: 0x6a irb: 0x6a icl: 0x0 flg: 0x0000

Rec Offset | Rec Offset | Rec Offset | Rec Offset | Rec Offset

-

0x00 0x1fe8 | 0x01 0x1fa6 | 0x02 0x1f54 | 0x03 0x1f12 | 0x04 0x1ec0

0x05 0x1e7e | 0x06 0x1e2c | 0x07 0x1dea | 0x08 0x1d98 | 0x09 0x1d56

0x0a 0x1d04 | 0x0b 0x1cc2 | 0x0c 0x1c70 | 0x0d 0x1c2e | 0x0e 0x1bdc

0x0f 0x1b9a | 0x10 0x1b48 | 0x11 0x1b06 | 0x12 0x1ab4 | 0x13 0x1a72

What can we do at this current situation. I am not that much expert in ORACLE DBA. However know a few things how to manage. Can any of the experts guide me how can we resolve the error at this current sitaution and move forward with the upgrade. What i need to know now is

1. How to revert back to the healthy 10.2.0.4 oracle now?

2. how to restart and complete the upgrade successfully at this situation.

Edited by: Hemanth Kumar on Jul 23, 2011 7:12 AM

Edited by: Hemanth Kumar on Jul 23, 2011 7:16 AM

stefan_koehler · ‎07-23-2011

Hello Hemanth,

well you did the wrong things at the wrong time.

Depending on the error and the situation you have to use this procedure:

-> [http://download.oracle.com/docs/cd/E11882_01/server.112/e10897/software.htm#CHDDBDHC]

<div class="jive-quote">If you stop the upgrade, but do not restore the database, then you should not restart DBUA until you start the database instance in UPGRADE mode using the Oracle Database 11g release 2 (11.2) software. You cannot go back to the original software version unless you restore your database.

</div>

1. How to revert back to the healthy 10.2.0.4 oracle now?

-> Restore a backup of your 10.2.0.4 database with your oracle 10.2.0.4 binaries and recover to point-in-time before upgrade.

2. how to restart and complete the upgrade successfully at this situation.

-> No way - need to revert to the start and try again.

Regards

Stefan

Former Member · ‎07-23-2011

Please find the last few lines of Oracle server.log.

create or replace public synonym v$rman_backup_job_details for v_$rman_backup_job_details;

Synonym created.

grant select on v_$rman_backup_job_details to select_catalog_role;

Grant succeeded.

create or replace view v_$backup_set_details as select * from v$backup_set_details;

View created.

create or replace public synonym v$backup_set_details for v_$backup_set_details;

Synonym created.

grant select on v_$backup_set_details to select_catalog_role;

Grant succeeded.

create or replace view v_$backup_piece_details as select * from v$backup_piece_details;

View created.

create or replace public synonym v$backup_piece_details for v_$backup_piece_details;

Synonym created.

grant select on v_$backup_piece_details to select_catalog_role;

Grant succeeded.

create or replace view v_$backup_copy_details as select * from v$backup_copy_details;

View created.

create or replace public synonym v$backup_copy_details for v_$backup_copy_details;

Synonym created.

grant select on v_$backup_copy_details to select_catalog_role;

Grant succeeded.

create or replace view v_$proxy_copy_details as select * from v$proxy_copy_details;

View created.

create or replace public synonym v$proxy_copy_details for v_$proxy_copy_details;

Synonym created.

grant select on v_$proxy_copy_details to select_catalog_role;

Grant succeeded.

create or replace view v_$proxy_archivelog_details as select * from v$proxy_archivelog_details;

View created.

create or replace public synonym v$proxy_archivelog_details for v_$proxy_archivelog_details;

Synonym created.

grant select on v_$proxy_archivelog_details to select_catalog_role;

Grant succeeded.

create or replace view v_$backup_datafile_details as select * from v$backup_datafile_details;

View created.

create or replace public synonym v$backup_datafile_details for v_$backup_datafile_details;

Synonym created.

grant select on v_$backup_datafile_details to select_catalog_role;

Grant succeeded.

create or replace view v_$backup_controlfile_details as select * from v$backup_controlfile_details;

View created.

create or replace public synonym v$backup_controlfile_details for v_$backup_controlfile_details;

Synonym created.

grant select on v_$backup_controlfile_details to select_catalog_role;

Grant succeeded.

create or replace view v_$backup_archivelog_details as select * from v$backup_archivelog_details;

View created.

create or replace public synonym v$backup_archivelog_details for v_$backup_archivelog_details;

Synonym created.

grant select on v_$backup_archivelog_details to select_catalog_role;

Grant succeeded.

create or replace view v_$backup_spfile_details as select * from v$backup_spfile_details;

View created.

create or replace public synonym v$backup_spfile_details for v_$backup_spfile_details;

Synonym created.

grant select on v_$backup_spfile_details to select_catalog_role;

Grant succeeded.

create or replace view v_$backup_set_summary as select * from v$backup_set_summary;

View created.

create or replace public synonym v$backup_set_summary for v_$backup_set_summary;

Synonym created.

grant select on v_$backup_set_summary to select_catalog_role;

Grant succeeded.

create or replace view v_$backup_datafile_summary as select * from v$backup_datafile_summary;

View created.

create or replace public synonym v$backup_datafile_summary for v_$backup_datafile_summary;

Synonym created.

grant select on v_$backup_datafile_summary to select_catalog_role;

Grant succeeded.

create or replace view v_$backup_controlfile_summary as select * from v$backup_controlfile_summary;

View created.

create or replace public synonym v$backup_controlfile_summary for v_$backup_controlfile_summary;

Synonym created.

grant select on v_$backup_controlfile_summary to select_catalog_role;

Grant succeeded.

create or replace view v_$backup_archivelog_summary as select * from v$backup_archivelog_summary;

How to revert back if Oracle Upgrade from 10.2.0.4 to 11G failed.

Accepted Solutions (0)

Answers (2)

Answers (2)

Re: BusinessObjects 4.2 SP9 to 4.3 latest version

Re: BusinessObjects 4.2 SP9 to 4.3 latest version

Re: Consuming on-Premise Service in CAP Project

Re: Abap code to get data from table EKKO

Re: CF Deployment Error: Error getting tenant t0