Unable to open database

[Former Member]

Dear experts,

i am refrshing my database from source(10.2.0.4) to test(10.2.0.2).

all the files are migrated, created control file.

then

SQL> recover database using backup controlfile until cancel;

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

CANCEL

Media recovery cancelled.

SQL> alter database open resetlogs;

now my logs is................

Identified logfile 18 as thread 1 sequence 172806

Logfile 18 is not current

... NOSWITCH ARCH archival in progress

NOSWITCH archival processing for any existing Async LNS processes

ALTER SYSTEM ARCHIVE LOG ALL USING BACKUP CONTROLFILE complete

• 2011-01-03 11:34:25.624

• 2011-01-03 11:35:46.226

tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x1)

tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x1)

ORA-00704: bootstrap process failure

ORA-39700: database must be opened with UPGRADE option

please suggest....

advance thanks,

Regards,

Siva.

[Former Member]

y

[Former Member]

i am refrshing my database from source(10.2.0.4) to test(10.2.0.2).

I don't think this could work.

Make sure source and target system have got the same version.

I haven't a system copy guide at hand just now, but what does it tell you?

[Former Member]

Dear loe,

I haven't a system copy guide at hand just now, but what does it tell you????????

please provide some documentation on ORACLE system copy..

plz suggest some solution on this

Regards, Siva

[Former Member]

You should definitely check the system copy guides available under service.sap.com/swdc -> Installation + Upgrades -> Installation + Upgrade Guides. There you will find all the necessary information.

Kind regards,

[Former Member]

>>>>>>>>>> am refrshing my database from source(10.2.0.4) to test(10.2.0.2).

you have two options:

1. for refresing the database (copying the database files of a different database to a target system) you need to have exactly the same version of software installed (Oracle patchset, Oracle minipatch) on the target system as on the source system in order to be able to perform the recovery.

2. If you refresh using an offline backup it should be possible to downgrade the database on the target system (how to see the readme.html provided with the 10.2.0.4 patchset).

But it is much easier to go with option 1, just install patchset 10.2.0.4 and the same mini patch installed on the source system. After that the recover database should finish fine.

regards

peter