Backup restoration

[Former Member]

Hi,

I have my Production Database <b>Oracle 8i</b>,SAP 4.6C Windows Server 2003.

Also one Test m/c on <b>Oracle 9i</b>,SAP 4.6C Windows Server 2003.

I do have Production offline backup taken by DB13.So is it possible to restore the Production backup in Test m/c ignoring this <b>Oracle version mismatch</b>?

Please reply asap its urgent.

Regards,

Mofizur

[Former Member]

Hi Mofizur

As far as my lnowledge goes, restoration of adata onto a lower version from a higher version of Oracle is possible althought the vice versa is not possible.

One simple way is to go to transfer the offline backup file and the back<SID>.log file and run the restore and recovery through SAPDBA utility. It will tell you of the status.

Hope it helps.

Lokesh Gupta

[fidel_vales]

Hello,

that is NOT correct.

You cannot open directly a "restored" backup from a lower Oracle version.

Note that Oracle 8i is not supported by Oracle on W2003. Running such combination on a production system is highly dangerous.

You must upgrade your system first to Oracle 9i

[Former Member]

Hi Guruz,

I have

1) Restored the datafiles,redolog files from PRD system(offline backup) to TEST system.

2) Created control file successfully in TEST system.

3) Mounted the database successfully.

4) Alter Database Open is not working.

We are getting the error:::

SQL> startup nomount;

ORACLE instance started.

Total System Global Area 1078657492 bytes

Fixed Size 455124 bytes

Variable Size 469762048 bytes

Database Buffers 607248384 bytes

Redo Buffers 1191936 bytes

SQL> alter database mount;

Database altered.

SQL> alter database open;

alter database open

*

ERROR at line 1:

ORA-01092: ORACLE instance terminated. Disconnection forced

Please guide me.

Regards,

Mofizur

[fidel_vales]

1) you get more information about the error you get on the alert log

2) I think I already mentioned that you <b>cannot</b> restored backup from Oracle 8i on a 9i installation and open it, it will <b>NOT</b> work. As it is happening to you now.

If you look at the alert log it will tell you something like "you have to open the database in "restricted/migrate" mode" because oracle detects that you are trying to open an old oracle database

[Former Member]

Hi,

I think u r right.

I have tried that option also...

SQL>startup migrate and startup restrict.

But after mounting the database same error is coming.

Is there any way to restore or it is<b> NOT POSSIBLE</b>.

Regards,

Mofizur

[fidel_vales]

What EXACT error are you getting?

I mean, the real one on the Alert log

[Former Member]

Fri Nov 30 16:29:34 2007

Starting ORACLE instance (normal)

Disable cache advisory with old cache parameters

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

SCN scheme 2

LICENSE_MAX_USERS = 0

SYS auditing is disabled

Starting up ORACLE RDBMS Version: 9.2.0.6.0.

System parameters with non-default values:

processes = 100

sessions = 115

timed_statistics = TRUE

shared_pool_size = 411041792

shared_pool_reserved_size= 40483422

control_files = I:\oracle\ARQ\sapdata1\cntrl\cntrlARQ.dbf, J:\oracle\ARQ\sapdata2\cntrl\cntrlARQ.dbf, K:\oracle\ARQ\sapdata3\cntrl\cntrlARQ.dbf

db_block_buffers = 74127

db_block_size = 8192

compatible = 9.2.0

log_archive_start = TRUE

log_archive_dest = W:\oracle\ARQ\saparch\ARQarch

log_buffer = 1048576

log_checkpoint_interval = 300000

log_checkpoint_timeout = 0

db_files = 254

db_file_multiblock_read_count= 8

control_file_record_keep_time= 30

row_locking = always

max_rollback_segments = 400

rollback_segments = PRS_0, PRS_1, PRS_2, PRS_3, PRS_4, PRS_5, PRS_6, PRS_7, PRS_8, PRS_9, PRS_10, PRS_11, PRS_12, PRS_13, PRS_14, PRS_15, PRS_16, PRS_17, PRS_18, PRS_19

transaction_auditing = FALSE

cursor_space_for_time = FALSE

create_bitmap_area_size = 33554432

bitmap_merge_area_size = 33554432

parallel_max_servers = 4

parallel_execution_message_size= 8192

hash_join_enabled = TRUE

hash_area_size = 4194304

background_dump_dest = Q:\oracle\ARQ\saptrace\background

user_dump_dest = Q:\oracle\ARQ\saptrace\usertrace

max_dump_file_size = 20000

optimizer_features_enable= 9.2.0

sort_area_size = 2097152

sort_area_retained_size = 0

db_name = ARQ

open_cursors = 800

optimizer_mode = choose

star_transformation_enabled= true

PMON started with pid=2

DBW0 started with pid=3

LGWR started with pid=4

CKPT started with pid=5

SMON started with pid=6

RECO started with pid=7

Fri Nov 30 16:29:36 2007

ARCH: STARTING ARCH PROCESSES

ARC0 started with pid=8

ARC0: Archival started

ARC1 started with pid=9

Fri Nov 30 16:29:37 2007

ARC1: Archival started

Fri Nov 30 16:29:38 2007

ARCH: STARTING ARCH PROCESSES COMPLETE

Fri Nov 30 16:29:38 2007

ARC1: Thread not mounted

Fri Nov 30 16:29:38 2007

ALTER DATABASE MOUNT

Fri Nov 30 16:29:39 2007

ARC0: Thread not mounted

Fri Nov 30 16:29:43 2007

Successful mount of redo thread 1, with mount id 3603780659

Fri Nov 30 16:29:43 2007

Database mounted in Exclusive Mode.

Completed: ALTER DATABASE MOUNT

Fri Nov 30 16:29:43 2007

ALTER DATABASE OPEN MIGRATE

Fri Nov 30 16:29:44 2007

Beginning crash recovery of 1 threads

Fri Nov 30 16:29:44 2007

Started redo scan

Fri Nov 30 16:29:44 2007

Completed redo scan

117 redo blocks read, 5 data blocks need recovery

Fri Nov 30 16:29:44 2007

Started recovery at

Thread 1: logseq 8, block 3, scn 0.0

Fri Nov 30 16:29:44 2007

Recovery of Online Redo Log: Thread 1 Group 13 Seq 8 Reading mem 0

Mem# 0 errs 0: S:\ORACLE\ARQ\ORIGLOGA\LOG_G13M1.DBF

Mem# 1 errs 0: P:\ORACLE\ARQ\MIRRLOGA\LOG_G13M2.DBF

Fri Nov 30 16:29:44 2007

Completed redo application

Fri Nov 30 16:29:44 2007

Ended recovery at

Thread 1: logseq 8, block 120, scn 0.317708883

5 data blocks read, 5 data blocks written, 117 redo blocks read

Crash recovery completed successfully

Fri Nov 30 16:29:44 2007

Thread 1 advanced to log sequence 9

Thread 1 opened at log sequence 9

Current log# 14 seq# 9 mem# 0: O:\ORACLE\ARQ\ORIGLOGB\LOG_G14M1.DBF

Current log# 14 seq# 9 mem# 1: T:\ORACLE\ARQ\MIRRLOGB\LOG_G14M2.DBF

Successful open of redo thread 1

Fri Nov 30 16:29:46 2007

MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set

Fri Nov 30 16:29:46 2007

SMON: enabling cache recovery

Fri Nov 30 16:29:46 2007

ARC0: Media recovery disabled

Fri Nov 30 16:29:47 2007

SMON: enabling tx recovery

Fri Nov 30 16:29:47 2007

Errors in file q:\oracle\arq\saptrace\usertrace\arq_ora_3448.trc:

ORA-00600: internal error code, arguments: [qctstc2o1], [3], [1], [2], [1], [4000], [0], []

Fri Nov 30 16:29:47 2007

Errors in file q:\oracle\arq\saptrace\background\arq_smon_3076.trc:

ORA-00600: internal error code, arguments: [qctstc2o1], [3], [1], [2], [1], [4000], [0], []

Fri Nov 30 16:29:48 2007

Errors in file q:\oracle\arq\saptrace\usertrace\arq_ora_3448.trc:

ORA-00000: normal, successful completion

Fri Nov 30 16:29:48 2007

Error 0 happened during db open, shutting down database

Instance terminated by USER, pid = 3448

ORA-1092 signalled during: ALTER DATABASE OPEN MIGRATE...

[fidel_vales]

OK,

so the error is:

ORA-00600: internal error code, arguments: [qctstc2o1], [3], [1], [2], [1], [4000], [0], []

a small search of notes ( not so difficult to do, even YOU could have done it 😞

<a href="http://service.sap.com/sap/support/notes/613714">613714:Oracle 9i: ORA-00600 [qctstc2o1]</a>

[Former Member]

I have gone thru the note.

<b>Set the following event:

event = "10619 trace name context forever, level 1"</b>

Where I have to set this .In ini<sid>.ora as I am not using spfile.

just simply add this entry in .ora or anything more????

Thanks for ur response.

Regards,

Mofizur

[former_member204746]

a long shot...

try changing :

compatible = 9.2.0

to

compatible = 8.1.7

[fidel_vales]

What about upgrading the DB?????

note says:

The ORA-00600 [qctstc2o1] error occurs when you start the database after an upgrade from Oracle 8i to Oracle 9i if you have the following two conditions:

1. The COMPATIBLE Oracle parameter is already set to 9.x.x.
<b>2. The upgrade scripts do not run successfully</b>

From the beginning I'm telling you that

1) oracle 8i is NOT supported by oracle in Windows 2003

2) it is not possible to directly download an oracle 8i database and open it in oracle 9i

[Former Member]

Hi Eric,

I have changed that one

compatible = 8.1.7

Now:::new error

ORACLE instance started.

Total System Global Area 1078657492 bytes

Fixed Size 455124 bytes

Variable Size 469762048 bytes

Database Buffers 607248384 bytes

Redo Buffers 1191936 bytes

Database mounted.

ORA-01571: redo version 9.2.0.0.0 incompatible with ORACLE version 8.1.7.0.0

We have no time to upgrade to Oracle 9i and then do all these.

Regards,

Mofizur

[former_member204746]

ok,

you have already lost over 10 hours trying to use your ORacle 9 DB on Oracle 8 binaries.. this is enough.

an upgrade to Oracle 9.2.0 binaries should take you less than 1 hour.

you install 9.2.0, install patch for 9.2.0.6. then, you should be able to open you DB correctly. no need to upgrade the DB contents as it was already done.