OraFAQ Forum: Server Administration » Problem after upgrading

Home » RDBMS Server » Server Administration » Problem after upgrading

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: Problem after upgrading [message #337506 is a reply to message #337489]

Thu, 31 July 2008 02:12

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Instance recovery required, so recover database, then open that database.
Then shutdown
Then mount and turn on flashback and then open database.

[Updated on: Thu, 31 July 2008 02:23]

Report message to a moderator

Re: Problem after upgrading [message #337512 is a reply to message #337506]

Thu, 31 July 2008 02:21

diamond
Messages: 26
Registered: July 2008

Junior Member

I tired this..

the following error is thrown:

SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-00264: no recovery required

Report message to a moderator

Re: Problem after upgrading [message #337523 is a reply to message #337512]

Thu, 31 July 2008 02:50

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

look your error message...ORA-00264: no recovery required

Report message to a moderator

Re: Problem after upgrading [message #337532 is a reply to message #337489]

Thu, 31 July 2008 03:09

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Apply below work around.

SQL> alter database open;
SQL> shutdown immediate;
SQL> startup mount;
SQL> alter database flashback on;
SQL> alter database open;

Report message to a moderator

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...

Report message to a moderator

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 #337679 is a reply to message #337589]

Thu, 31 July 2008 11:09

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

post here last 20 lines from alertlog or better if you attach alertlog file in TEXT format.

also post here init.ora file or better if you attach.

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

Attachment: initdarsh.ora
(Size: 0.83KB, Downloaded 1073 times)

[Updated on: Fri, 01 August 2008 00:05]

Report message to a moderator

Re: Problem after upgrading [message #337758 is a reply to message #337735]

Fri, 01 August 2008 01:06

Michel Cadot
Messages: 68675
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Is it necessary that the database has to be opened with a STARTUP UPGRADE after upgrading the DB every time.

It is necessary to use STARTUP UPGRADE to upgrade.

Regards
Michel

Report message to a moderator

Re: Problem after upgrading [message #337763 is a reply to message #337758]

Fri, 01 August 2008 01:21

diamond
Messages: 26
Registered: July 2008

Junior Member

but in this way i cannot giv startup mount and alter database open...

wat should i do?

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: 68675
Registered: March 2007
Location: Nanterre, France, http://...

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

Report message to a moderator

Previous Topic:	Why patches required?
Next Topic:	alter system switch logfile;

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Sep 08 23:36:15 CDT 2024