Skrevet av Emne: Oracle: Temporarily disabling archive logs  (Lest 4275 ganger)

ATC

  • Gjest
Oracle: Temporarily disabling archive logs
« på: 16. Juni 2009, 20:24 pm »
  • [applaud]0
  • [smite]0
  • The database itself can be placed in NOARCHIVELOG mode, which disables the process of redo log archiving which can otherwise slow down a bulk load into a warehouse. How?



    ATC

    • Gjest
    [Solved] Oracle: Temporarily disabling archive logs
    « Svar #1 på: 16. Juni 2009, 20:24 pm »
  • [applaud]0
  • [smite]0
  • 1. shutdown;
    2. startup mount;
    3. alter database noarchivelog;
    4. alter database open;

    To resume archive logging:
    5. alter database archivelog;