Unable to open database

[Former Member]

Dear experts,

i am refrshing my datase 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]

1. start a new sqlplus session

2. fire the following command on sqlplus

STARTUP UPGRADE

3. The database now opens successfully after which catalog and cataproc

sql's can be fired.

4. Now shutdown and startup the database as the database was started

with UPGRADE option.

pupbld sql can be executed after step 4.

[Former Member]

The database now opens successfully after which catalog and cataproc

sql's can be fired.

4. Now shutdown and startup the database as the database was started

with UPGRADE option.

pupbld sql can be executed after step 4.

my question is ..

what impact of catalog and cataproc sql's

if this is making a new database , my works losts..

pupbld sql can be executed after step 4.???

kindly guide me.....

Regards,

Siva.

[Former Member]

Please check note 582427