2 Replies Latest reply: Feb 12, 2010 2:20 AM by 752995 RSS

    archive logmode

    752382
      Hi,

      How to set the archive logmode to oracle database.

      Thanks
        • 1. Re: archive logmode
          P.Forstmann
          http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/archredo.htm#i1006246
          • 2. Re: archive logmode
            752995
            shutdown immediate
            startup mount

            alter database archivlog;

            alter database open;

            archive log list;

            Output:
            Database log mode     Archive Mode
            Automatic archival     Enabled -----------> Should show as enabled
            Archive destination     /u153/oradata/cache2p/arch/
            Oldest online log sequence 26385
            Next log sequence to archive 0
            Current log sequence     26388