9/04/2012

ORACLE DB into noarchivelog mode

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;

No comments:

Post a Comment

Popular Posts