advertisements
_____________________________________________________________________________________________________________________
- Veryfy the current log mode using below mentioned query
SELECT log_mode FROM gv$database;
LOG_MODE
------------
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
- Check the Cluster status
$ srvctl status database -d testdb1
Instance TESTDB11 is running on node rotexdb01
Instance TESTDB12 is running on node rotexdb02
- Stop the database
$ srvctl stop database -d testdb1
- Check the status again
$ srvctl status database -d testdb1
Instance TESTDB11 is running on node rotexdb01
Instance TESTDB12 is running on node rotexdb02
- Connect to sqlplus / as sysdba
SQL> Shutdown immediate;
SQL> startup mount exclusive;
SQL> alter database noarchivelog;
Database altered.
- 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
- Open the database and verify
SQL> alter database open;
SQL> SELECT log_mode FROM gv$database;
LOG_MODE
------------
NOARCHIVELOG
NOARCHIVELOG
- Shutdown the database and startup with SRVCTL utility
SQL> shut immediate;
srvctl start database -d testdb1
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment