1 Reply Latest reply on Sep 27, 2013 8:26 PM by Mike Kutz

    APEX Backup




      I am working on Oracle The use of the DB is only for APEX.

      I installed APEX in a separate table space and datafile.

      When taking a full cold backup, is it enough to backup only two datafiles:

      APEX.dbf : Where APEX was installed.

      APEX_2150521780606761.DBF: The workspace datafile.


      Or, what is the most efficient way to take  cold backup for Database that is dedicated for APEX ??


        • 1. Re: APEX Backup
          Mike Kutz

          For a cold backup - You need ALL data files, control files, redo files, parameter files, (and maybe a few other things...)

          Best way for a backup -- RMAN.


          You should be able to enable 'standard scripts' through the use of 'em'.  (enterprise manager)

          (BTW - these will be HOT backup -- the preferred method.)


          also .. "Database dedicated to APEX" makes no sense at all.

          Your database should be dedicated to handling ALL of your data with APEX being one-of-many applications that is installed 'in' the database.