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: 59279
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: 59279
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: 59279
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: 1731
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 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
Previous Topic: ORA-16038: log 2 sequence# 284 cannot be archived
Next Topic: Restore backup at new machine
Goto Forum:
  


Current Time: Tue Sep 30 15:09:14 CDT 2014

Total time taken to generate the page: 0.10435 seconds