Portal
Language
 
Home>Knowledge Base>Root>Configure Oracle XE with ArchiveLog and daily backup
User Login
Username
Password
 
 Login
Information
Article ID194
Created On3/21/2011
Modified3/21/2011

Configure Oracle XE with ArchiveLog and daily backup

Oracle generally recommends running a database with ArchiveLog mode enabled.  To enable ArchiveLog mode:

  1. 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.
  2. Launch a CMD window and connect as the Oracle DBA: SQLPLUS / AS SYSDBA
  3. Shutdown the database: SHUTDOWN IMMEDIATE
  4. Mount the database: STARTUP MOUNT
  5. Turn on ARCHIVELOG Mode: ALTER DATABASE ARCHIVELOG;
  6. Open database: ALTER DATABASE OPEN;
  7. 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.