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

advertisements

_____________________________________________________________________________________________________________________

The Eucharistic Miracles of the World
  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

_____________________________________________________________________________________________________________________

Website Stats

0 comments:

Post a Comment

Labels

Oracle (629) Script (86) General (77) Unix (47) Blog (23) Technology (19) gadget (6) games (6) Business (3) OCI (3) SQL* Loader (3) Datapump (2)
 

acehints.com Copyright 2011-23 All Rights Reserved | Site Map | Contact | Disclaimer