Home » RDBMS Server » Server Administration » Problem after upgrading
Problem after upgrading [message #337489] Thu, 31 July 2008 01:28 Go to next message
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 #337506 is a reply to message #337489] Thu, 31 July 2008 02:12 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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

Re: Problem after upgrading [message #337523 is a reply to message #337512] Thu, 31 July 2008 02:50 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
Razz

look your error message...ORA-00264: no recovery required
Re: Problem after upgrading [message #337532 is a reply to message #337489] Thu, 31 July 2008 03:09 Go to previous messageGo to next message
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;


Re: Problem after upgrading [message #337569 is a reply to message #337523] Thu, 31 July 2008 05:02 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.
Re: Problem after upgrading [message #337735 is a reply to message #337679] Fri, 01 August 2008 00:03 Go to previous messageGo to next message
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 1111 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 Go to previous messageGo to next message
Michel Cadot
Messages: 68719
Registered: March 2007
Location: Saint-Maur, France, https...
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
Re: Problem after upgrading [message #337763 is a reply to message #337758] Fri, 01 August 2008 01:21 Go to previous messageGo to next message
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?
Re: Problem after upgrading [message #337765 is a reply to message #337763] Fri, 01 August 2008 01:27 Go to previous message
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
Previous Topic: Why patches required?
Next Topic: alter system switch logfile;
Goto Forum:
  


Current Time: Sun Dec 08 19:23:26 CST 2024