2 Replies Latest reply: May 15, 2012 9:47 AM by 937441 RSS

    Taking Physical backup


      I am using oracle 10g database. using oracle 10g database and .net technology i build an application.my application is working well and huge amount of data is stored in my database.now i am facing the the problem that how to take physical backup of the database in which already two years of data is stored.before i never take any physical backup of this database, i am just taking logical backup of it.

      Please Help me ..

      Thanks in Advance.
        • 1. Re: Taking Physical backup

          If are you planning to take a cold backup, you should copy the datafiles, control files, redo logs (spfile/pfile and passwords file are optional).

          You may want to check this note:

          How to Do an OFFLINE (COLD) BACKUP. [ID 159452.1]

          Hope that helps,
          • 2. Re: Taking Physical backup
            There are three ways of backing up an Oracle database.

            1. User-managed backups: These are the traditional "hots" and "colds". In a "hot" backup, you place the tablespaces into backup mode and then copy the data files using cp on *nix operating systems or cntl-c/cntl-v on windows systems.  Once the data files are copied, you take the tablespaces out of backup mode.  In a "cold" backup, you take the database down completely and then copy the files.  When the datafiles are copied, you can bring the database back online.

            2. RMAN backups: This is Oracle's recommended backup strategy. The benefit of this type of backup is that RMAN is kernelized or part of the database itself. This means that you no longer need to worry about placing tablespaces into backup mode or bringing down the database. Backing up a database is as easy as the following:

            RMAN target /
            backup database;

            3. The final way you can back up a database is using some type of storage backup such as tape backups of the entire filesystem or mirroring the array offsite.