OraFAQ Forum: Backup & Recovery » ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

Home » RDBMS Server » Backup & Recovery » ORA-00265: instance recovery required, cannot set ARCHIVELOG mode (Oracle 9i)

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

ORA-00265: instance recovery required, cannot set ARCHIVELOG mode [message #323382]

Wed, 28 May 2008 06:23

ram anand
Messages: 244
Registered: February 2008
Location: india

Senior Member

Hi,
I need to make my database to ARCHIVELOG mode when i try it it gives below following error

SQL> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

pls help how to resolve this issue

Thanks,

Report message to a moderator

Re: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode [message #323387 is a reply to message #323382]

Wed, 28 May 2008 06:30

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
 *Cause:  The database either crashed or was shutdown with the ABORT
          option. Media recovery cannot be enabled because the online
          logs may not be sufficient to recover the current datafiles.
 *Action: Open the database and then enter the SHUTDOWN command with the
          NORMAL or IMMEDIATE option.

Regards
Michel

Report message to a moderator

Re: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode [message #401525 is a reply to message #323387]

Tue, 05 May 2009 06:31

senged
Messages: 10
Registered: October 2007
Location: asia

Junior Member

Hi Dear friends
i have simillar problem
and with shuting down datbase with immediate it did not solved
pls help me agin i have this error infornt of my face:
ORA_00265
Thanx
ana

Report message to a moderator

Re: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode [message #401527 is a reply to message #401525]

Tue, 05 May 2009 06:36

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Copy and paste your session, all what you did, also post the result of:

select name, value from v$parameter where name like '%archive_dest%';

Post it formatted as describe in OraFAQ Forum Guide, "How to format your post?" section.
Set the columns so that your lines does not exceed 80 characters.
Use the "Preview Message" button to verify.

Regards
Michel

Report message to a moderator

Re: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode [message #401655 is a reply to message #401527]

Wed, 06 May 2009 00:05

senged
Messages: 10
Registered: October 2007
Location: asia

Junior Member

SQL> shutdown immediate
ORA-01109: database not open
HI
I wanted to activate oracle archive mode
i knew these steps
1)connect sys as sysdba
2)startup mount
3)alter database archivelog
4)achive log start
5)alter database open

but after step 3 i faced to error 00265
detail of this matter presented below:

SQL> shutdown immediate
ORA-01109: database not open

Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 527290368 bytes
Fixed Size 1314520 bytes
Variable Size 469762344 bytes
Database Buffers 50331648 bytes
Redo Buffers 5881856 bytes
Database mounted.
SQL> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

****then the answer for that quary [select name,value from v$parameter where name like '%archive_dest%']

no rows found!!!
PLS HELP ME
ANA

[Updated on: Wed, 06 May 2009 00:58]

Report message to a moderator

Re: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode [message #401663 is a reply to message #401655]

Wed, 06 May 2009 00:53

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You must:
startup
shutdown normal
startup mount
...

Regards
Michel

Report message to a moderator

Re: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode [message #401666 is a reply to message #401663]

Wed, 06 May 2009 01:15

senged
Messages: 10
Registered: October 2007
Location: asia

Junior Member

hi Dear Michel

i did shutdown with two options:immediate and normal
but no result
but to day after your mail
i did it again
and it works !!
the only variance between this time and last time was
the capital command i , mean i entered command in capital letter!
any way it works
and thank u so much

Best regards
ana

[Updated on: Wed, 06 May 2009 01:16]

Report message to a moderator

Re: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode [message #444376 is a reply to message #323382]

Sun, 21 February 2010 04:38

javeedfaq
Messages: 1
Registered: February 2010
Location: NANDED

Junior Member

1.you must shutdown your database gracefully/cleanly(normal,transaction or immediate)

2.Open your database in mount stage.

3.SQL>alter database archivelog;

4.SQL>alter database open;

5.Take physical full database backup COLD/HOT for using archiving features while crash your database in future.

Report message to a moderator

Re: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode [message #444704 is a reply to message #444376]

Tue, 23 February 2010 10:39

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

Quote:

the only variance between this time and last time was
the capital command i , mean i entered command in capital letter!

Is it true ?

Report message to a moderator

Re: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode [message #569979 is a reply to message #444704]

Sun, 04 November 2012 02:36

mushtaqparvez
Messages: 1
Registered: November 2012
Location: india

Junior Member

shutdown database gracefully and quite the window/command prompt and then open new command prompt set the sid and home then start it works

Report message to a moderator

Re: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode [message #625683 is a reply to message #569979]

Mon, 13 October 2014 03:45

lio8145
Messages: 1
Registered: October 2014
Location: Belgique

Junior Member

Hello all,

I had the same issue and after reading all your posts here is what unblocked me :
It took a while to execute a shutdown immediate so I ha done a shutdown abort (bad, I know ^^)
so trying to reactivate the archivelog I had the same error message.
when database shut down (after immediate or abort)
- startup mount
- ALTER DATABASE OPEN (if you don't do this, shutdown immediate won't unblock you)
- shutdown immediate
- startup mount
- alter database archivelog;

I guess most of you did the shutdown immediate from the startup mount without opening the database so it didn't recalculate the archivelog status.

and there we are, hope it helps ! Smile

cheers guys

Report message to a moderator

Re: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode [message #625790 is a reply to message #625683]

Tue, 14 October 2014 04:48

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Yes, the ALTER DATABASE OPEN starts instance recovery allowing you to perform a clean shutdown afterwards. A small point but you could have achieved the same as follows:

STARTUP;
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER DATABASE ARCHIVELOG;
ALTER DATABASE OPEN;

HTH
-g

Report message to a moderator

Previous Topic:	RMAN-03002: failure of restore command at 10/08/2014 14:24:25
Next Topic:	RMAN Level0 Backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 01 21:19:02 CST 2025