SQL*Plus: Release 10.2.0.1.0 - Production on Mon Feb 6 01:36:08 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> set line 9090
SQL> SHOW USER
USER is "SYS"
Step -1) Check the Existing mode in your Database
SQL> SELECT LOG_MODE FROM V$DATABASE;
LOG_MODE
------------
ARCHIVELOG
Step -2) Shut Down Your Database Cleanly to Disable Archiving Mode .
SQL> SHUT IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
Step -3) Start up Your Database in Mount Stage .
SQL> STARTUP MOUNT;
ORACLE instance started.
Total System Global Area 603979776 bytes
Fixed Size 1250380 bytes
Variable Size 281021364 bytes
Database Buffers 314572800 bytes
Redo Buffers 7135232 bytes
Database mounted.
Step -4)
SQL> ALTER DATABASE NOARCHIVELOG;
Database altered.
SQL> ALTER DATABASE OPEN;
Database altered.
DONE :-)