AboutPeter Choi Expertise I am a senior Oracle DBA, PeopleSoft Administrator and Project Manager with
10+ years experience. I have been working with PeopleSoft (HRMS 5, 7, 7.x and
8.9), Oracle RDBMS (7.3 - 11gR1) on various Unix and Windows platforms, and some Oracle Application Server (9i/10gR2). I also have experience with the configuration and administration of BEA`s Tuxedo and WebLogic for PeopleSoft 8.x.
What about RMAN? Oracle is giving more stress on it. If it is a more improved form then why use IMP/EXP? Secondly are there any front-end tools like TOAD that can do the task.
-------------------------------------------
The text above is a follow-up to ...
-----Question-----
I installed Oracle 10g Express edition. In the Windows XP start menu I cannot see any Backup menu option in Oracle group. I want to know how I can enable automated backup of my database on scheduled basis.
-----Answer-----
Hi Rohit,
There is no delivered tool to perform an automated backup with the Express edition (or the Standard or Enterprise edition for that matter).
To do a simple backup, you can perform an Oracle EXPORT (type EXP.exe /? for the guide). Once you are able to take a backup, then you can use the Windows XP's scheduler to automate the backup.
Note: If you use this methodology, your Windows XP is required to be on at the time of the backup process.
The Windows XP scheduling tool can be found under START | CONTROL PANEL | SCHEDULED TASKS | ADD A SCHEDULED TASK.
Hope this helps.
Peter
Answer Hi Rohit,
RMAN, like the EXPort, is a tool that you can use. You will still need to write some scripts (batch or using a scheduler) to trigger the backup to run. Enclosed are some reference links:
