Oracle Database - How to backup database in oracle 10g xe

Asked By Divyesh Mistry on 22-Sep-11 02:52 AM
Sir,

How to schedule backup database in oracle 10g xe. ?
plz solve my problem soon as possible.

thn'x
Devil Scorpio replied to Divyesh Mistry on 22-Sep-11 03:10 AM
Hi,

You do not need to take a backup at your base time. Just enable flashback database, create a guaranteed restore point, run your tests and flashback to the previously created restore point.

The steps for this would be:

  1. Startup the instance in mount mode.

    startup force mount;

  2. Create the restore point.

    create restore point before_test guarantee flashback database;

  3. Open the database.

    alter database open;

  4. Run your tests.
  5. Shutdown and mount the instance.

    shutdown immediate; startup mount;

  6. Flashback to the restore point.

    flashback database to restore point before_test;

  7. Open the database.

    alter database open;

Reference :- http://stackoverflow.com/questions/67666/backup-restore-database-for-oracle-10g-testing-using-sqlplus-or-rman

Riley K replied to Divyesh Mistry on 22-Sep-11 12:49 PM
You can now backup your database using Enterprise Manager once you have configured your system for backup. Decide the type of backup you require, that is, full backup of all data files, incremental backup or incrementally updated backups. 

To backup all the data files on your database you need to follow these simple steps:

1. Go to Maintenance page
2. Click on the backup or recovery section
3. Click on the Schedule Backup option

Refer this link


Regards