Setting ORACLE DB into noarchivelog mode

Steps when the database state is down:
1. Login to sqlplus
  -sqlplus /nolog
  -connect / as sysdba

2. The db must be mounted EXCLUSIVE and not open for operation
  -startup mount;
3. Check the log mode status of the database
  -select log_mode from v$database;
4. Setting it to noarchivelog mode
  -alter database noarchivelog;
5. Setting db open for user operation
  -alter database open;
6. Reverting back to archivelog mode
  -alter database archivelog;

About these ads

3 Responses to “Setting ORACLE DB into noarchivelog mode”


  1. 3 Yasmin Friday, 18 October 2013 at 7:29 am

    It’s very straightforward to find out any matter on web
    as compared to books, as I found this article at this web page.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




Pages

My Favorites

SAP
February 2007
S M T W T F S
« Jan   Mar »
 123
45678910
11121314151617
18192021222324
25262728  

Previous Entries


Follow

Get every new post delivered to your Inbox.

%d bloggers like this: