Advertisement
thesuhu

Oracle Archive Log

Aug 22nd, 2021
2,776
0
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
Add Comment
Please, Sign In to add comment
Advertisement