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
|
|
|
|
|