Please log into your user account or create a new one

Solution for: #36: How to change an Oracle database to noarchivelog mode

Restart database unmounted and alter.

2

- 3bd1a9d59a360e10be3d1a9f98b3c48b_small jo on April 16, 2009, 07:10 PM UTC

Become the oracle user. Then:

% sqlplus /nolog

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SP2-0640: Not connected
SQL> connect / as sysdba;
Connected.
SQL> shutdown immediate;
Database closed.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 2141162968 bytes
Fixed Size 744920 bytes
Variable Size 1375731712 bytes
Database Buffers 738197504 bytes
Redo Buffers 26488832 bytes
SQL> alter database mount;

Database altered.

SQL> alter database noarchivelog;

Database altered.

SQL> alter database open;

Database altered.




.... hurrah. it's generally a good idea to also make sure there are no other sessions running.
Add a Comment