OraFAQ Forum: Backup & Recovery » Changing from archivelog to noarchivelog mode

Home » RDBMS Server » Backup & Recovery » Changing from archivelog to noarchivelog mode

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

Changing from archivelog to noarchivelog mode [message #156641]

Thu, 26 January 2006 12:06

ujumaka
Messages: 7
Registered: January 2006

Junior Member

My database was running on archivelog mode, when i recovered a datafile. Now i want to change it back to noarchivelog mode. it gave me d error

SQL> alter database noarchivelog;
alter database noarchivelog
*
ERROR at line 1:
ORA-01143: cannot disable media recovery - file 3 needs media recovery
ORA-01110: data file 3: 'C:\ORACLE\ORADATA\DBA\CWMLITE01.DBF'

How do i change it back to noarchivelog mode?

Thanks

Report message to a moderator

Re: Changing from archivelog to noarchivelog mode [message #156649 is a reply to message #156641]

Thu, 26 January 2006 13:51

Frank Naude
Messages: 4579
Registered: April 1998

Senior Member

Try the following:

RECOVER DATAFILE 'C:\ORACLE\ORADATA\DBA\CWMLITE01.DBF';
ALTER DATABASE DATAFILE 'C:\ORACLE\ORADATA\DBA\CWMLITE01.DBF' ONLINE;
ALTER DATABASE NOARCHIVELOG;

Report message to a moderator

Re: Changing from archivelog to noarchivelog mode [message #158571 is a reply to message #156641]

Mon, 13 February 2006 04:32

salmansh
Messages: 14
Registered: June 2005
Location: Al-Khobar

Junior Member

Hi,

I would like to add that you should also execute

> Alter system stop archive log; -- to stop the archiver process

change the parameters corresponding to archive log in the init.ora file and restart the database.

HTH

Report message to a moderator

Previous Topic:	Unable to read from data file
Next Topic:	Solution for 24/7 Db

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 13:29:43 CDT 2024