BRTOOLS to turn off archive log
Firstly you check acrhivelog status
- BRTOOLS
- 1 = Instance management
- 6 - Show instance status
- Continue x2
- 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
-------------------------------------------------------------------------------
- To turn achive log off,
- Brtools
- 1 = Instance management
- 3 - Alter database instance
- Continue x 2
- 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:
- Choose 3 to set achive log, choose 4 to set noacrhivelog
- Once done, press C to continue until Brtools will execute alter database command and restart database
- Completed