Problem after upgrading [message #337489] |
Thu, 31 July 2008 01:28 |
diamond
Messages: 26 Registered: July 2008
|
Junior Member |
|
|
Hi,
i have applied a patch to upgrade my oracle to 10.2.0.3.0.
I have manual database.i am not able to upgrade this DB, so evry time i need to give startup upgrade;
(using OUI also i am not able to upgrade)
also,
if i mount the database n then open it(which now i need to do to enable the flashback) the error like:
SQL> alter database flashback on;
alter database flashback on
*
ERROR at line 1:
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
ORA-38714: Instance recovery required.
(in mount state)
Is it that every time i have to giv startup upgrade to a maunally created DB.However, i hav upgraded the DB uisng OUI to the other DBCA created DB.
Thanks
|
|
|
|
|
|
|
Re: Problem after upgrading [message #337569 is a reply to message #337523] |
Thu, 31 July 2008 05:02 |
diamond
Messages: 26 Registered: July 2008
|
Junior Member |
|
|
Yes i know.. no recovery is required by the error message..
but the thing u might have not noticed from my prev post is that the database asked for the instance recovery...
|
|
|
Re: Problem after upgrading [message #337589 is a reply to message #337532] |
Thu, 31 July 2008 06:01 |
diamond
Messages: 26 Registered: July 2008
|
Junior Member |
|
|
Hi @Mohammad Taj,
I tried this.. it gives following error:
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
when i giv
SQL>startup;
the above errors is thrown..
is it that every time i hav to giv startup upgrade to start the database?????
[Updated on: Thu, 31 July 2008 06:04] Report message to a moderator
|
|
|
|
Re: Problem after upgrading [message #337735 is a reply to message #337679] |
Fri, 01 August 2008 00:03 |
diamond
Messages: 26 Registered: July 2008
|
Junior Member |
|
|
My alert log goes like this...
ARC1 started with pid=18, OS id=14558
Fri Aug 1 10:20:35 2008
Thread 1 opened at log sequence 59
Current log# 1 seq# 59 mem# 0: /u02/darsh/redo01.log
Successful open of redo thread 1
Fri Aug 1 10:20:35 2008
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Fri Aug 1 10:20:35 2008
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
Fri Aug 1 10:20:35 2008
ARC1: Becoming the heartbeat ARCH
Fri Aug 1 10:20:35 2008
SMON: enabling cache recovery
Fri Aug 1 10:20:35 2008
Errors in file /u02/darsh/admin/udump/darsh_ora_14554.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Fri Aug 1 10:20:35 2008
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 14554
ORA-1092 signalled during: ALTER DATABASE OPEN...
i've also attached my initfile...
please clear my doubt:
Is it necessary that the database has to be opened with a STARTUP UPGRADE after upgrading the DB every time.The database is manually created
[Updated on: Fri, 01 August 2008 00:05] Report message to a moderator
|
|
|
|
|
Re: Problem after upgrading [message #337765 is a reply to message #337763] |
Fri, 01 August 2008 01:27 |
|
Michel Cadot
Messages: 68719 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
Restore the backup you had before upgrade, correctly upgrade with "startup upgrade" and strictly following the instructions in readme file.
Regards
Michel
|
|
|