Advertisement
thesuhu

Oracle Archive Log

Aug 22nd, 2021
1,135
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # How TO Put Oracle DATABASE IN ARCHIVE LOG MODE
  2. # LOG IN AS an Oracle USER WITH SYSDBA equivalent PRIVILEGES
  3. sqlplus
  4. # Shut down Oracle Server
  5. shutdown IMMEDIATE
  6. # Mount DATABASE
  7. startup mount EXCLUSIVE
  8. # ALTER DATABASE
  9. ALTER DATABASE archivelog
  10. ALTER DATABASE OPEN
  11. # START archive LOG
  12. archive LOG START
  13. # shows that ARCHIVELOG MODE IS enabled. IF it IS disabled, the DATABASE LOG MODE IS NOARCHIVELOG
  14. archive LOG list
  15.  
Advertisement
RAW Paste Data Copied
Advertisement