How to Change Oracle 11g 10g RAC database to Noarchivelog mode?

  1. Veryfy the current log mode using below mentioned query
SELECT log_mode FROM gv$database;

LOG_MODE
------------
ARCHIVELOG
ARCHIVELOG

OR

SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     390
Next log sequence to archive   392
Current log sequence           392
  1. Check the Cluster status
$ srvctl status database -d testdb1
Instance TESTDB11 is running on node rotexdb01
Instance TESTDB12 is running on node rotexdb02
  1. Stop the database
$ srvctl stop database -d testdb1
  1. Check the status again
$ srvctl status database -d testdb1
Instance TESTDB11 is running on node rotexdb01
Instance TESTDB12 is running on node rotexdb02
  1. Connect to sqlplus / as sysdba
SQL> Shutdown immediate;
SQL> startup mount exclusive;
SQL> alter database noarchivelog;

Database altered.
  1. Verify the archive status
SQL>  archive log list;
Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     390
Current log sequence           392
  1. Open the database and verify

SQL> alter database open;
SQL> SELECT log_mode FROM gv$database; 

LOG_MODE
------------
NOARCHIVELOG
NOARCHIVELOG
  1. Shutdown the database and startup with SRVCTL utility
SQL> shut immediate;
srvctl start database -d testdb1
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google