Home » RDBMS Server » Backup & Recovery » ORA-00265: instance recovery required, cannot set ARCHIVELOG mode (Oracle 9i)
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode [message #323382] Wed, 28 May 2008 06:23 Go to next message
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,
Re: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode [message #323387 is a reply to message #323382] Wed, 28 May 2008 06:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode [message #401525 is a reply to message #323387] Tue, 05 May 2009 06:31 Go to previous messageGo to next message
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
Re: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode [message #401527 is a reply to message #401525] Tue, 05 May 2009 06:36 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
icon8.gif  Re: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode [message #401655 is a reply to message #401527] Wed, 06 May 2009 00:05 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You must:
startup
shutdown normal
startup mount
...

Regards
Michel
Re: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode [message #401666 is a reply to message #401663] Wed, 06 May 2009 01:15 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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.
Re: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode [message #444704 is a reply to message #444376] Tue, 23 February 2010 10:39 Go to previous messageGo to next message
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!


Smile Is it true ?
icon9.gif  Re: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode [message #569979 is a reply to message #444704] Sun, 04 November 2012 02:36 Go to previous messageGo to next message
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
Re: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode [message #625683 is a reply to message #569979] Mon, 13 October 2014 03:45 Go to previous messageGo to next message
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
Re: ORA-00265: instance recovery required, cannot set ARCHIVELOG mode [message #625790 is a reply to message #625683] Tue, 14 October 2014 04:48 Go to previous message
gazzag
Messages: 1118
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
Previous Topic: RMAN-03002: failure of restore command at 10/08/2014 14:24:25
Next Topic: RMAN Level0 Backup
Goto Forum:
  


Current Time: Thu Mar 28 17:16:50 CDT 2024