Banner 468 x 60px

Tuesday, February 5, 2013

Oracle Archive log trun off

0 comments
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


0 comments: