Backing up and RESTORING Oracle Database XE is based on protecting the physical FILES that make up the database:

There are 6 files in C:oraclexeoradataXE: CONTROL.DBF, SYSAUX.DBF, SYSTEM.DBF, TEMP.DBF, UNDO.DBF and USER.DBF.

The control file SPFILE is in C: oraclexe app oracle product 10.2.0 server dbs.

If in ARCHIVELOG MODE, the REDO log files should be backed up. Two redo log files are in

C: oraclexe app oracle Vlash_recovery_areaVE ONLINELOG.

Cold back up is when you stop the database and zip up all those 9 files (in NOARCHIVEMOD). When you restore the database copy all 9 files back to the same folders.

If the application is in ARCHIVEMOD and should run 24X7 then use HOT backup.

Backing up and restoring Oracle Database XE is based on protecting the physical files that make up the database:

There are 6 files in C:oraclexeoradataXE: CONTROL.DBF, SYSAUX.DBF, SYSTEM.DBF, TEMP.DBF, UNDO.DBF and USER.DBF.

The control file SPFILE is in C: oraclexe app oracle product 10.2.0 server dbs.

If in ARCHIVELOG mode, the redo log files should be backed up. Two redo log files are in

C: oraclexe app oracle Vlash_recovery_areaVE ONLINELOG.

Cold back up is when you stop the database and zip up all those 9 files (in NOARCHIVEMOD). When you restore the database copy all 9 files back to the same folders.

If the application is in ARCHIVEMOD and should run 24X7 then use hot backup.