Oracle generally recommends running a database with ArchiveLog mode enabled. To enable ArchiveLog mode:
- To View current ArchiveLog Mode setting, go to the database home page and view the usage monitor. Log Archiving will be shown at the bottom of the window.
- Launch a CMD window and connect as the Oracle DBA: SQLPLUS / AS SYSDBA
- Shutdown the database: SHUTDOWN IMMEDIATE
- Mount the database: STARTUP MOUNT
- Turn on ARCHIVELOG Mode: ALTER DATABASE ARCHIVELOG;
- Open database: ALTER DATABASE OPEN;
- Make sure the Flash Recovery size is at least 20G: ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 20G;
Oracle includes a batch file (C:\oraclexe\app\oracle\product\10.2.0\server\BIN\Backup.bat) that does the flash backup. Unfortunately, they include a pause command in it so it's not much use for a Scheduled Task. Copy the file to BackupNoPause.bat, edit out the pause commands, and add a Scheduled Task that performs the flash backup on a daily basis.