BRTOOLS to turn off archive log:

BRTOOLS to turn off archive log:

Firstly you check acrhivelog status

1. BRTOOLS
2. 1 = Instance management
   
3. 6 - Show instance status
4. Continue x2
5. 2 - Show instance status
   
   Information about the status of database instance R53
   
    1 - Instance number (number) ........... 1
    2 - Instance thread (thread) ........... 1
    3 - Instance status (status) ........... OPEN
    4 - Instance start time (start) ........ 2009-11-07 02.34.33
    5 - Oracle version (version) ........... 10.2.0.2.0
    6 - Database creation time (create) .... 2009-10-12 04.09.24
    7 - Last resetlogs time (resetlogs) .... 2009-08-20 07.11.28
    8 - Archivelog mode (archmode) ......... ARCHIVELOG
    9 - Archiver status (archiver) ......... STARTED
   10 - Current redolog sequence (redoseq) . 18914
   11 - Current redolog SCN (redoscn) ...... 16310535260
   12 - Number of SAP connections (sapcon) . 26
   
   Standard keys: c - cont, b - back, s - stop, r - refr, h - help
   -------------------------------------------------------------------------------
   
   
   
6. To turn achive log off,
7. Brtools
8. 1 = Instance management
9. 3 - Alter database instance
10. Continue x 2
11. Now you see the screen below
    BR0280I BRSPACE time stamp: 2009-11-07 02.41.24
    BR0656I Choice menu 207 - please make a selection
    -------------------------------------------------------------------------------
    Alter database instance main menu
    
     1 - Switch redolog file
     2 - Force database checkpoint
     3 - Set archivelog mode
     4 - Set noarchivelog mode
     5 - Show instance status
     6 * Exit program
     7 - Reset program status
    
    Standard keys: c - cont, b - back, s - stop, r - refr, h - help
    -------------------------------------------------------------------------------
    BR0662I Enter your choice:
    
12. Choose 3 to set achive log, choose 4 to set noacrhivelog
13. Once done, press C to continue until Brtools will execute alter database command and restart database
14. Completed