This discussion is archived
1 Reply Latest reply: Sep 27, 2013 1:26 PM by Mike Kutz RSS

APEX Backup

Test2 Newbie
Currently Being Moderated

Hello,

 

I am working on Oracle 11.2.0.3. 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 ??

Regards,

  • 1. Re: APEX Backup
    Mike Kutz Expert
    Currently Being Moderated

    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.

     

    MK

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points