Home » RDBMS Server » Backup & Recovery » Error 00265 - Instance recovery
Error 00265 - Instance recovery [message #294799] Sat, 19 January 2008 05:29 Go to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
Guys,

I am getting this error when trying to set my database in Archivelog mode

Error 00265 - instance recovery required, cannot set ARCHIVELOG mode

Here are the steps I did

- Startup mount
- alter database dbase archivelog

What is the reason for this?
What remedial steps should be taken?

- Das
Re: Error 00265 - Instance recovery [message #294800 is a reply to message #294799] Sat, 19 January 2008 05:36 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
startup
shutdown immediate
startup mount
The command is
alter database archivelog;

[Updated on: Sat, 19 January 2008 05:38]

Report message to a moderator

Re: Error 00265 - Instance recovery [message #294801 is a reply to message #294800] Sat, 19 January 2008 05:44 Go to previous messageGo to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
I did exactly as you said..but the problem still persists

Any other way to do it?

- Das
Re: Error 00265 - Instance recovery [message #294802 is a reply to message #294799] Sat, 19 January 2008 05:48 Go to previous messageGo to next message
varu123
Messages: 754
Registered: October 2007
Senior Member
Do it again
Re: Error 00265 - Instance recovery [message #294803 is a reply to message #294802] Sat, 19 January 2008 05:53 Go to previous messageGo to next message
durgadas.menon
Messages: 365
Registered: December 2007
Location: Nowhere
Senior Member
MAGIC.....



IT WORKED....now atleast tell me why it did not happen before and why now..what exactly is instance recovery.?

Hope this may the same solution if I come across the problem in 10g.

Thanks a lot

- Das
Re: Error 00265 - Instance recovery [message #294813 is a reply to message #294803] Sat, 19 January 2008 07:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Concepts
Chapter 12 Database and Instance Startup and Shutdown
Section Overview of Instance and Database Startup
Subsection What Happens When You Open a Database
Paragraph Instance Recovery

Regards
Michel

95% of your questions are answered in Concepts.
Re: Error 00265 - Instance recovery [message #294834 is a reply to message #294799] Sat, 19 January 2008 22:21 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
MAGIC.....

No magic, Either you issued shutdown abort or something abnormal things happened to database , like power off suddenly.
Previous Topic: 06171 - not connected to target database
Next Topic: Backup principles
Goto Forum:
  


Current Time: Sun Dec 04 10:57:08 CST 2016

Total time taken to generate the page: 0.09065 seconds