Oracle 10G Express installed on Windows 2000 Server Enterprise Edition.
I am trying to automate backups and on Oracle's website I have found the following documentation.
http://docs.oracle.com/cd/B25329_01/doc/admin.102/b25107/backrest.htm
Activate Archive Log
- SQLPLUS -> CONNECT SYS/password AS SYSDBA
- SHUTDOWN IMMEDIATE
- STARTUP MOUNT
- ALTER DATABASE ARCHIVELOG;
- ALTER DATABASE OPEN;
Backup the Database
Then using the backup.bat file provided by Oracle: D:\oraclexe\app\oracle\product\10.2.0\server\BIN\BACKUP.BAT, I can backup the database either manually or with Scheduled tasks
Using a test server, I have been able to backup and restore the database using the backup.bat and restore.bat files provided. I have not seen anything however about recycling those backups.
Questions:
- Does Oracle provide a script to cleanup backup files that are no longer needed? or What can I do to avoid filling up the D: drive with backup files?
- Is there a better method to backup Oracle 10G Express?
Thank you