Oracle XE Backup
After installing Oracle XE you should setup backups.
Backups for XEFor Oracle XE there is ready a backup script that uses Oracle's RMAN.
Setup Archive Log ModeAfter installing the database change it to archivelog mode: [oracle@localhost ~]$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Sun May 25 01:28:00 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect / as sysdba
Connected.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 289406976 bytes
Fixed Size 1258488 bytes
Variable Size 92277768 bytes
Database Buffers 192937984 bytes
Redo Buffers 2932736 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL>
To make sure the database is really in archive log mode run the following sql statement:
SQL> SELECT LOG_MODE FROM SYS.V$DATABASE; LOG_MODE ------------ ARCHIVELOG SQL>
Run the Initial BackupWindows run $ORACLE_HOME/bin/Backup.bat
Linux run $ORACLE_HOME/config/scripts/backup.sh[oracle@localhost ~]$ $ORACLE_HOME/config/scripts/backup.sh Doing online backup of the database. Backup of the database succeeded. Log file is at /usr/lib/oracle/xe/oxe_backup_current.log. Press ENTER key to exit [oracle@localhost ~]$
Run the Backups DailyWindows add the $ORACLE_HOME/bin/Backup.bat to a job scheduler.
- Make sure the user running the job is the same user who installed Oracle.
Linux add the $ORACLE_HOME/config/scripts/backup.sh to cron.daily
- Remove the user notification line from the end of the script