| Archive log mode -problem [message #50505] |
Tue, 19 March 2002 01:48  |
jp
Messages: 11
Registered: August 2000
|
Junior Member |
|
|
hi ,
while I am trying to make the database in ARCHIVE LOG MODE , I am getting the following error.
steps:
C:>svrmgrl
Oracle Server Manager Release 3.1.7.0.0 - Production
Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
SVRMGR> connect sys as sysdba
Password:
Connected.
SVRMGR> startup mount exclusive
ORACLE instance started.
Total System Global Area 93165596 bytes
Fixed Size 75804 bytes
Variable Size 60485632 bytes
Database Buffers 32526336 bytes
Redo Buffers 77824 bytes
Database mounted.
SVRMGR> alter database archivelog;
alter database archivelog
*
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
SVRMGR>
Pls tell me where I am making the mistake
Thanx-
jose
|
|
|
|
| Re: Archive log mode -problem [message #50510 is a reply to message #50505] |
Tue, 19 March 2002 03:27  |
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
|
Senior Member |
|
|
Looks like the database was not shut down properly. Do the following.
1. startup (normal)
2. shutdown immediate
3. change the init.ora file
3. startup nomount ...and then the steps shown above.
Here are the details for errors:
00265, 00000, "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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
